left start: 0.0121 sec
left end: 0.1803 sec
listing start: 0.2138 sec
listing end: 0.4583 sec
END: 0.4585 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 = '640' or p2c.categories_id = '641' or p2c.categories_id = '642' or p2c.categories_id = '643' or p2c.categories_id = '644' or p2c.categories_id = '645' or p2c.categories_id = '646' or p2c.categories_id = '647' or p2c.categories_id = '648' or p2c.categories_id = '649' or p2c.categories_id = '650' or p2c.categories_id = '651' or p2c.categories_id = '652' or p2c.categories_id = '653' or p2c.categories_id = '654' or p2c.categories_id = '655' or p2c.categories_id = '656' or p2c.categories_id = '657' or p2c.categories_id = '658' or p2c.categories_id = '659' or p2c.categories_id = '660' or p2c.categories_id = '661' or p2c.categories_id = '662' or p2c.categories_id = '663' or p2c.categories_id = '664' or p2c.categories_id = '665' or p2c.categories_id = '666' or p2c.categories_id = '667' or p2c.categories_id = '668' or p2c.categories_id = '669' or p2c.categories_id = '670' or p2c.categories_id = '671' or p2c.categories_id = '672' or p2c.categories_id = '673' or p2c.categories_id = '674' or p2c.categories_id = '675' or p2c.categories_id = '676' or p2c.categories_id = '677' or p2c.categories_id = '678' or p2c.categories_id = '679' or p2c.categories_id = '680' or p2c.categories_id = '681' or p2c.categories_id = '682' or p2c.categories_id = '683' or p2c.categories_id = '684' or p2c.categories_id = '685' or p2c.categories_id = '686' or p2c.categories_id = '687' or p2c.categories_id = '688' or p2c.categories_id = '689' or p2c.categories_id = '690' or p2c.categories_id = '691' or p2c.categories_id = '692' or p2c.categories_id = '693' or p2c.categories_id = '694' or p2c.categories_id = '695' or p2c.categories_id = '696' or p2c.categories_id = '697' or p2c.categories_id = '698' or p2c.categories_id = '699' or p2c.categories_id = '700' or p2c.categories_id = '701' or p2c.categories_id = '702' or p2c.categories_id = '703' or p2c.categories_id = '704' or p2c.categories_id = '705' or 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' or p2c.categories_id = '764' or 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' ) group by products_id_group order by p.description