left start: 0.0386 sec
left end: 0.2216 sec
listing start: 0.3056 sec
listing end: 0.6303 sec
END: 0.6318 sec

select p.products_image1, p.description products_name , p.products_id, p.products_price,p.products_price_special, p.products_price final_price from products p , products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and ( p2c.categories_id = '279' or p2c.categories_id = '280' or p2c.categories_id = '281' or p2c.categories_id = '282' or p2c.categories_id = '283' or p2c.categories_id = '284' or p2c.categories_id = '285' or p2c.categories_id = '286' or p2c.categories_id = '287' or p2c.categories_id = '288' or p2c.categories_id = '289' or p2c.categories_id = '290' or p2c.categories_id = '291' or p2c.categories_id = '292' or p2c.categories_id = '293' or p2c.categories_id = '294' or p2c.categories_id = '295' or p2c.categories_id = '296' or p2c.categories_id = '297' or p2c.categories_id = '298' or p2c.categories_id = '299' or p2c.categories_id = '300' or p2c.categories_id = '301' or p2c.categories_id = '302' or p2c.categories_id = '303' or p2c.categories_id = '304' or p2c.categories_id = '305' or p2c.categories_id = '306' or p2c.categories_id = '307' or p2c.categories_id = '308' or p2c.categories_id = '309' or p2c.categories_id = '310' or p2c.categories_id = '311' or p2c.categories_id = '312' or p2c.categories_id = '313' or p2c.categories_id = '314' or p2c.categories_id = '315' or p2c.categories_id = '316' or p2c.categories_id = '317' or p2c.categories_id = '318' or p2c.categories_id = '319' or p2c.categories_id = '320' or p2c.categories_id = '321' or p2c.categories_id = '322' or p2c.categories_id = '323' or p2c.categories_id = '324' or p2c.categories_id = '325' or p2c.categories_id = '326' or p2c.categories_id = '327' or p2c.categories_id = '328' or p2c.categories_id = '329' or p2c.categories_id = '330' or p2c.categories_id = '331' or p2c.categories_id = '332' or p2c.categories_id = '333' or p2c.categories_id = '334' or p2c.categories_id = '335' or p2c.categories_id = '336' or p2c.categories_id = '337' or p2c.categories_id = '338' or p2c.categories_id = '339' or p2c.categories_id = '340' or p2c.categories_id = '341' or p2c.categories_id = '342' or p2c.categories_id = '343' or p2c.categories_id = '344' or p2c.categories_id = '345' or p2c.categories_id = '346' or p2c.categories_id = '347' or p2c.categories_id = '348' or p2c.categories_id = '349' or p2c.categories_id = '350' or p2c.categories_id = '351' or p2c.categories_id = '352' or p2c.categories_id = '353' or p2c.categories_id = '354' or p2c.categories_id = '355' or p2c.categories_id = '356' or p2c.categories_id = '357' or p2c.categories_id = '358' or p2c.categories_id = '359' or p2c.categories_id = '360' or p2c.categories_id = '361' or p2c.categories_id = '362' or p2c.categories_id = '363' or p2c.categories_id = '364' or p2c.categories_id = '365' or p2c.categories_id = '366' or p2c.categories_id = '367' or p2c.categories_id = '368' or p2c.categories_id = '369' or p2c.categories_id = '370' or p2c.categories_id = '371' or p2c.categories_id = '372' or p2c.categories_id = '373' or p2c.categories_id = '374' or p2c.categories_id = '375' or p2c.categories_id = '376' or p2c.categories_id = '377' or p2c.categories_id = '378' or p2c.categories_id = '379' or p2c.categories_id = '380' or p2c.categories_id = '381' or p2c.categories_id = '382' or p2c.categories_id = '383' or p2c.categories_id = '384' or p2c.categories_id = '385' or p2c.categories_id = '386' or p2c.categories_id = '387' or p2c.categories_id = '388' or p2c.categories_id = '389' or p2c.categories_id = '390' or p2c.categories_id = '391' or p2c.categories_id = '392' or p2c.categories_id = '393' or p2c.categories_id = '394' or p2c.categories_id = '395' or p2c.categories_id = '396' or p2c.categories_id = '397' or p2c.categories_id = '398' or p2c.categories_id = '399' or p2c.categories_id = '400' or p2c.categories_id = '401' or p2c.categories_id = '402' or p2c.categories_id = '403' or p2c.categories_id = '8228' or p2c.categories_id = '8229' or p2c.categories_id = '8230' or p2c.categories_id = '404' or p2c.categories_id = '405' or p2c.categories_id = '406' or p2c.categories_id = '407' or p2c.categories_id = '408' or p2c.categories_id = '409' or p2c.categories_id = '410' or p2c.categories_id = '411' or p2c.categories_id = '412' or p2c.categories_id = '413' or p2c.categories_id = '414' or p2c.categories_id = '415' or p2c.categories_id = '416' or p2c.categories_id = '417' or p2c.categories_id = '418' or p2c.categories_id = '419' or p2c.categories_id = '420' or p2c.categories_id = '421' or p2c.categories_id = '422' or p2c.categories_id = '423' or p2c.categories_id = '424' or p2c.categories_id = '425' or p2c.categories_id = '426' or p2c.categories_id = '427' or p2c.categories_id = '428' or p2c.categories_id = '429' or p2c.categories_id = '430' or p2c.categories_id = '431' or p2c.categories_id = '432' or p2c.categories_id = '433' or p2c.categories_id = '434' or p2c.categories_id = '435' or p2c.categories_id = '436' or p2c.categories_id = '437' or p2c.categories_id = '438' or p2c.categories_id = '439' or p2c.categories_id = '440' or p2c.categories_id = '441' or p2c.categories_id = '442' or p2c.categories_id = '443' or p2c.categories_id = '444' or p2c.categories_id = '445' or p2c.categories_id = '446' or p2c.categories_id = '447' or p2c.categories_id = '448' or p2c.categories_id = '449' or p2c.categories_id = '450' or p2c.categories_id = '451' or p2c.categories_id = '452' or p2c.categories_id = '453' or p2c.categories_id = '454' or p2c.categories_id = '455' or p2c.categories_id = '456' or p2c.categories_id = '457' or p2c.categories_id = '8231' or p2c.categories_id = '8232' or p2c.categories_id = '458' or p2c.categories_id = '459' or p2c.categories_id = '460' or p2c.categories_id = '461' or p2c.categories_id = '462' or p2c.categories_id = '463' or p2c.categories_id = '464' or p2c.categories_id = '465' or p2c.categories_id = '466' or p2c.categories_id = '467' or p2c.categories_id = '468' or p2c.categories_id = '469' or p2c.categories_id = '470' or p2c.categories_id = '471' or p2c.categories_id = '472' or p2c.categories_id = '473' or p2c.categories_id = '474' or p2c.categories_id = '475' or p2c.categories_id = '476' or p2c.categories_id = '477' or p2c.categories_id = '478' or p2c.categories_id = '479' or p2c.categories_id = '480' or p2c.categories_id = '481' or p2c.categories_id = '482' or p2c.categories_id = '483' or p2c.categories_id = '484' or p2c.categories_id = '485' or p2c.categories_id = '486' or p2c.categories_id = '487' or p2c.categories_id = '488' or p2c.categories_id = '489' or p2c.categories_id = '490' or p2c.categories_id = '491' or p2c.categories_id = '8233' or p2c.categories_id = '8234' or p2c.categories_id = '492' or p2c.categories_id = '493' or p2c.categories_id = '494' or p2c.categories_id = '495' or p2c.categories_id = '496' or p2c.categories_id = '497' or p2c.categories_id = '498' or p2c.categories_id = '499' or p2c.categories_id = '500' or p2c.categories_id = '501' or p2c.categories_id = '502' or p2c.categories_id = '503' or p2c.categories_id = '504' or p2c.categories_id = '505' or p2c.categories_id = '506' or p2c.categories_id = '507' or p2c.categories_id = '508' or p2c.categories_id = '509' or p2c.categories_id = '510' or p2c.categories_id = '511' or p2c.categories_id = '512' or p2c.categories_id = '513' or p2c.categories_id = '514' or p2c.categories_id = '515' or p2c.categories_id = '516' or p2c.categories_id = '517' or p2c.categories_id = '518' or p2c.categories_id = '519' or p2c.categories_id = '520' or p2c.categories_id = '521' or p2c.categories_id = '8235' ) group by products_id_group order by p.description