left start: 0.013 sec
left end: 0.1803 sec
listing start: 0.1875 sec
listing end: 0.4862 sec
END: 0.4864 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 = '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' ) group by products_id_group order by p.description