left start: 0.0386 sec
left end: 0.2371 sec
listing start: 0.2842 sec
listing end: 1.2807 sec
END: 1.2823 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 = '706' or p2c.categories_id = '707' or p2c.categories_id = '708' or p2c.categories_id = '709' or p2c.categories_id = '710' or p2c.categories_id = '711' or p2c.categories_id = '712' or p2c.categories_id = '713' or p2c.categories_id = '714' or p2c.categories_id = '715' or p2c.categories_id = '716' or p2c.categories_id = '717' or p2c.categories_id = '718' or p2c.categories_id = '719' or p2c.categories_id = '720' or p2c.categories_id = '721' or p2c.categories_id = '722' or p2c.categories_id = '723' or p2c.categories_id = '724' or p2c.categories_id = '725' or p2c.categories_id = '726' or p2c.categories_id = '727' or p2c.categories_id = '728' or p2c.categories_id = '729' or p2c.categories_id = '730' or p2c.categories_id = '731' or p2c.categories_id = '732' or p2c.categories_id = '733' or p2c.categories_id = '734' or p2c.categories_id = '735' or p2c.categories_id = '736' or p2c.categories_id = '737' or p2c.categories_id = '738' or p2c.categories_id = '739' or p2c.categories_id = '740' or p2c.categories_id = '741' or p2c.categories_id = '742' or p2c.categories_id = '743' or p2c.categories_id = '744' or p2c.categories_id = '745' or p2c.categories_id = '746' or p2c.categories_id = '747' or p2c.categories_id = '748' or p2c.categories_id = '749' or p2c.categories_id = '750' or p2c.categories_id = '751' or p2c.categories_id = '752' or p2c.categories_id = '753' or p2c.categories_id = '754' or p2c.categories_id = '755' or p2c.categories_id = '756' or p2c.categories_id = '757' or p2c.categories_id = '758' or p2c.categories_id = '759' or p2c.categories_id = '760' or p2c.categories_id = '761' or p2c.categories_id = '762' or p2c.categories_id = '763' ) group by products_id_group order by p.description