left start: 0.0417 sec
left end: 0.2709 sec
listing start: 0.3024 sec
listing end: 1.5072 sec
END: 1.5083 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 = '765' or p2c.categories_id = '766' or p2c.categories_id = '767' or p2c.categories_id = '768' or p2c.categories_id = '769' or p2c.categories_id = '770' or p2c.categories_id = '771' or p2c.categories_id = '772' or p2c.categories_id = '773' or p2c.categories_id = '774' or p2c.categories_id = '775' or p2c.categories_id = '776' or p2c.categories_id = '777' or p2c.categories_id = '778' or p2c.categories_id = '779' or p2c.categories_id = '780' or p2c.categories_id = '781' or p2c.categories_id = '782' or p2c.categories_id = '783' or p2c.categories_id = '784' or p2c.categories_id = '785' or p2c.categories_id = '786' or p2c.categories_id = '787' or p2c.categories_id = '788' or p2c.categories_id = '789' or p2c.categories_id = '790' or p2c.categories_id = '791' or p2c.categories_id = '792' or p2c.categories_id = '793' or p2c.categories_id = '794' or p2c.categories_id = '795' or p2c.categories_id = '796' or p2c.categories_id = '797' or p2c.categories_id = '798' or p2c.categories_id = '799' or p2c.categories_id = '800' or p2c.categories_id = '801' or p2c.categories_id = '802' or p2c.categories_id = '803' or p2c.categories_id = '804' or p2c.categories_id = '805' or p2c.categories_id = '806' or p2c.categories_id = '807' or p2c.categories_id = '808' or p2c.categories_id = '809' or p2c.categories_id = '810' ) group by products_id_group order by p.description