left start: 0.0436 sec
left end: 0.2481 sec
listing start: 0.2896 sec
listing end: 1.3613 sec
END: 1.3623 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 = '147' or p2c.categories_id = '148' or p2c.categories_id = '149' or p2c.categories_id = '150' or p2c.categories_id = '151' or p2c.categories_id = '152' or p2c.categories_id = '153' or p2c.categories_id = '154' or p2c.categories_id = '156' or p2c.categories_id = '157' or p2c.categories_id = '158' or p2c.categories_id = '159' or p2c.categories_id = '160' or p2c.categories_id = '161' or p2c.categories_id = '162' or p2c.categories_id = '163' or p2c.categories_id = '164' or p2c.categories_id = '165' or p2c.categories_id = '166' or p2c.categories_id = '167' or p2c.categories_id = '168' or p2c.categories_id = '169' or p2c.categories_id = '170' or p2c.categories_id = '172' or p2c.categories_id = '173' or p2c.categories_id = '174' or p2c.categories_id = '175' or p2c.categories_id = '176' or p2c.categories_id = '177' or p2c.categories_id = '178' or p2c.categories_id = '179' or p2c.categories_id = '180' or p2c.categories_id = '181' or p2c.categories_id = '182' or p2c.categories_id = '183' or p2c.categories_id = '184' or p2c.categories_id = '185' or p2c.categories_id = '186' or p2c.categories_id = '187' or p2c.categories_id = '188' or p2c.categories_id = '189' or p2c.categories_id = '190' or p2c.categories_id = '191' or p2c.categories_id = '192' or p2c.categories_id = '193' or p2c.categories_id = '194' or p2c.categories_id = '195' or p2c.categories_id = '196' or p2c.categories_id = '197' or p2c.categories_id = '198' or p2c.categories_id = '199' or p2c.categories_id = '200' or p2c.categories_id = '202' or p2c.categories_id = '203' or p2c.categories_id = '204' or p2c.categories_id = '205' or p2c.categories_id = '206' or p2c.categories_id = '207' or p2c.categories_id = '208' or p2c.categories_id = '209' or p2c.categories_id = '210' or p2c.categories_id = '211' or p2c.categories_id = '212' or p2c.categories_id = '213' or p2c.categories_id = '214' or p2c.categories_id = '215' or 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 = '8223' or p2c.categories_id = '8224' or p2c.categories_id = '8225' or p2c.categories_id = '8226' or p2c.categories_id = '8227' or p2c.categories_id = '243' or p2c.categories_id = '244' or p2c.categories_id = '245' ) group by products_id_group order by p.description