left start: 0.015 sec
left end: 0.2048 sec
listing start: 0.2134 sec
listing end: 0.5407 sec
END: 0.541 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 = '1568' or p2c.categories_id = '1569' or p2c.categories_id = '1570' or p2c.categories_id = '1571' or p2c.categories_id = '1572' or p2c.categories_id = '1573' or p2c.categories_id = '1574' or p2c.categories_id = '1575' or p2c.categories_id = '1576' or p2c.categories_id = '1577' or p2c.categories_id = '1578' or p2c.categories_id = '1579' or p2c.categories_id = '1580' or p2c.categories_id = '1581' or p2c.categories_id = '1582' or p2c.categories_id = '1583' or p2c.categories_id = '1584' or p2c.categories_id = '1585' or p2c.categories_id = '1586' or p2c.categories_id = '1587' or p2c.categories_id = '1588' or p2c.categories_id = '1589' or p2c.categories_id = '1590' or p2c.categories_id = '1591' or p2c.categories_id = '1592' or p2c.categories_id = '1593' or p2c.categories_id = '1594' or p2c.categories_id = '1595' or p2c.categories_id = '1596' or p2c.categories_id = '1597' or p2c.categories_id = '1598' or p2c.categories_id = '1599' or p2c.categories_id = '1600' or p2c.categories_id = '1601' ) group by products_id_group order by p.description