left start: 0.0185 sec left end: 0.3457 sec listing start: 0.3989 sec listing end: 0.6838 sec END: 0.6845 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 = '1455' or p2c.categories_id = '1456' or p2c.categories_id = '1457' or p2c.categories_id = '1458' or p2c.categories_id = '1459' or p2c.categories_id = '1460' or p2c.categories_id = '1461' or p2c.categories_id = '1462' or p2c.categories_id = '1463' or p2c.categories_id = '1464' or p2c.categories_id = '1465' or p2c.categories_id = '1466' or p2c.categories_id = '1467' or p2c.categories_id = '1468' or p2c.categories_id = '1469' or p2c.categories_id = '1470' or p2c.categories_id = '1471' or p2c.categories_id = '1472' or p2c.categories_id = '1473' or p2c.categories_id = '1474' or p2c.categories_id = '1475' or p2c.categories_id = '1476' or p2c.categories_id = '1477' or p2c.categories_id = '1478' or p2c.categories_id = '1479' or p2c.categories_id = '1480' or p2c.categories_id = '1481' or p2c.categories_id = '1482' or p2c.categories_id = '1483' or p2c.categories_id = '1484' or p2c.categories_id = '1485' or p2c.categories_id = '1486' or p2c.categories_id = '1487' or p2c.categories_id = '1488' or p2c.categories_id = '1489' or p2c.categories_id = '1490' or p2c.categories_id = '1491' or p2c.categories_id = '1492' or p2c.categories_id = '1493' or p2c.categories_id = '1494' or p2c.categories_id = '1495' or p2c.categories_id = '1496' or p2c.categories_id = '1497' or p2c.categories_id = '1498' or p2c.categories_id = '1499' or p2c.categories_id = '1500' or p2c.categories_id = '1501' or p2c.categories_id = '1502' or p2c.categories_id = '1503' or p2c.categories_id = '1504' or p2c.categories_id = '1505' or p2c.categories_id = '1506' or p2c.categories_id = '1507' or p2c.categories_id = '1508' or p2c.categories_id = '1509' or p2c.categories_id = '1510' or p2c.categories_id = '1511' or p2c.categories_id = '1512' or p2c.categories_id = '1513' or p2c.categories_id = '1514' or p2c.categories_id = '1515' or p2c.categories_id = '1516' or p2c.categories_id = '1517' or p2c.categories_id = '1518' or p2c.categories_id = '1519' or p2c.categories_id = '1520' or p2c.categories_id = '1521' or p2c.categories_id = '1522' or p2c.categories_id = '1523' or p2c.categories_id = '1524' or p2c.categories_id = '1525' or p2c.categories_id = '1526' or p2c.categories_id = '1527' or p2c.categories_id = '1528' or p2c.categories_id = '1529' ) group by products_id_group order by p.description