left start: 0.0128 sec
left end: 0.2732 sec
listing start: 0.2787 sec
listing end: 0.4559 sec
END: 0.4561 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 = '807' or p2c.categories_id = '808' or p2c.categories_id = '809' or p2c.categories_id = '810' or p2c.categories_id = '811' or p2c.categories_id = '812' or p2c.categories_id = '813' or p2c.categories_id = '814' or p2c.categories_id = '815' or p2c.categories_id = '816' or p2c.categories_id = '817' or p2c.categories_id = '818' or p2c.categories_id = '819' or p2c.categories_id = '820' or p2c.categories_id = '821' or p2c.categories_id = '822' or p2c.categories_id = '823' or p2c.categories_id = '824' or p2c.categories_id = '825' or p2c.categories_id = '826' or p2c.categories_id = '827' or p2c.categories_id = '828' or p2c.categories_id = '829' ) group by products_id_group order by p.description