1054 - Unknown column 'p.products_id' in 'on clause'
select distinct p.products_id, p.products_price, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id in (439,1494,1495,1379,1496,1504,1506,1500,1502,1497,1499,1505,1498,1503,1501,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1380,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,79) and p.products_status = '1' and f.status = '1' order by rand() DESC limit 30
[TEP STOP]
|
