left start: 0.0316 sec
left end: 0.3202 sec
listing start: 0.4112 sec
listing end: 1.6456 sec
END: 1.647 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 = '594' or p2c.categories_id = '595' or p2c.categories_id = '596' or p2c.categories_id = '597' or p2c.categories_id = '598' or p2c.categories_id = '599' or p2c.categories_id = '600' or p2c.categories_id = '601' or p2c.categories_id = '602' or p2c.categories_id = '603' or p2c.categories_id = '604' or p2c.categories_id = '605' or p2c.categories_id = '606' or p2c.categories_id = '607' or p2c.categories_id = '608' or p2c.categories_id = '609' or p2c.categories_id = '610' or p2c.categories_id = '611' or p2c.categories_id = '612' or p2c.categories_id = '613' or p2c.categories_id = '614' or p2c.categories_id = '615' or p2c.categories_id = '616' or p2c.categories_id = '617' or p2c.categories_id = '618' or p2c.categories_id = '619' or p2c.categories_id = '620' or p2c.categories_id = '621' or p2c.categories_id = '622' or p2c.categories_id = '623' or p2c.categories_id = '624' or p2c.categories_id = '625' or p2c.categories_id = '626' or p2c.categories_id = '627' or p2c.categories_id = '628' or p2c.categories_id = '629' or p2c.categories_id = '630' or p2c.categories_id = '631' or p2c.categories_id = '632' or p2c.categories_id = '633' or p2c.categories_id = '634' or p2c.categories_id = '635' or p2c.categories_id = '636' or p2c.categories_id = '637' or p2c.categories_id = '638' or p2c.categories_id = '639' or 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 = '8237' or p2c.categories_id = '8238' or p2c.categories_id = '8239' 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' ) group by products_id_group order by p.description