left start: 0.0308 sec
left end: 0.3054 sec
listing start: 0.3688 sec
listing end: 0.6809 sec
END: 0.6812 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 = '216' or p2c.categories_id = '217' or p2c.categories_id = '218' or p2c.categories_id = '219' or p2c.categories_id = '220' or p2c.categories_id = '221' or p2c.categories_id = '222' or p2c.categories_id = '223' or p2c.categories_id = '224' or p2c.categories_id = '225' or p2c.categories_id = '226' or p2c.categories_id = '227' or p2c.categories_id = '228' or p2c.categories_id = '229' or p2c.categories_id = '230' or p2c.categories_id = '231' or p2c.categories_id = '232' or p2c.categories_id = '233' or p2c.categories_id = '234' or p2c.categories_id = '235' or p2c.categories_id = '236' or p2c.categories_id = '237' or p2c.categories_id = '238' or p2c.categories_id = '239' or p2c.categories_id = '240' or p2c.categories_id = '241' or p2c.categories_id = '242' or p2c.categories_id = '243' or p2c.categories_id = '244' or p2c.categories_id = '245' or p2c.categories_id = '246' or p2c.categories_id = '247' or p2c.categories_id = '248' or p2c.categories_id = '249' or p2c.categories_id = '250' or p2c.categories_id = '251' or p2c.categories_id = '252' or p2c.categories_id = '253' or p2c.categories_id = '254' or p2c.categories_id = '255' or p2c.categories_id = '256' or p2c.categories_id = '257' or p2c.categories_id = '258' or p2c.categories_id = '259' or p2c.categories_id = '260' or p2c.categories_id = '261' or p2c.categories_id = '262' or p2c.categories_id = '263' or p2c.categories_id = '264' or p2c.categories_id = '265' or p2c.categories_id = '266' or p2c.categories_id = '267' or p2c.categories_id = '268' or p2c.categories_id = '269' or p2c.categories_id = '270' or p2c.categories_id = '271' or p2c.categories_id = '272' or p2c.categories_id = '273' or p2c.categories_id = '274' or p2c.categories_id = '275' or p2c.categories_id = '276' or p2c.categories_id = '277' or p2c.categories_id = '278' or 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 = '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' ) group by products_id_group order by p.description