left start: 0.0389 sec
left end: 0.2841 sec
listing start: 0.3068 sec
listing end: 1.069 sec
END: 1.0707 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 = '920' or p2c.categories_id = '921' or p2c.categories_id = '922' or p2c.categories_id = '923' or p2c.categories_id = '924' or p2c.categories_id = '925' or p2c.categories_id = '926' or p2c.categories_id = '927' or p2c.categories_id = '928' or p2c.categories_id = '929' or p2c.categories_id = '930' or p2c.categories_id = '931' or p2c.categories_id = '932' or p2c.categories_id = '933' or p2c.categories_id = '934' or p2c.categories_id = '935' or p2c.categories_id = '936' or p2c.categories_id = '937' or p2c.categories_id = '938' or p2c.categories_id = '939' or p2c.categories_id = '940' or p2c.categories_id = '941' or p2c.categories_id = '942' or p2c.categories_id = '943' or p2c.categories_id = '944' or p2c.categories_id = '945' or p2c.categories_id = '946' or p2c.categories_id = '947' or p2c.categories_id = '948' or p2c.categories_id = '949' or p2c.categories_id = '950' or p2c.categories_id = '951' or p2c.categories_id = '952' or p2c.categories_id = '953' or p2c.categories_id = '954' or p2c.categories_id = '955' or p2c.categories_id = '956' or p2c.categories_id = '957' or p2c.categories_id = '958' or p2c.categories_id = '959' or p2c.categories_id = '960' or p2c.categories_id = '961' or p2c.categories_id = '962' or p2c.categories_id = '963' or p2c.categories_id = '964' or p2c.categories_id = '965' or p2c.categories_id = '966' or p2c.categories_id = '967' or p2c.categories_id = '968' or p2c.categories_id = '969' or p2c.categories_id = '970' or p2c.categories_id = '971' or p2c.categories_id = '972' or p2c.categories_id = '973' or p2c.categories_id = '974' or p2c.categories_id = '975' or p2c.categories_id = '976' or p2c.categories_id = '977' or p2c.categories_id = '978' or p2c.categories_id = '8240' or p2c.categories_id = '8241' or p2c.categories_id = '8242' or p2c.categories_id = '8243' ) group by products_id_group order by p.description