Błąd zapytania sql : SELECT DISTINCT id,name,price FROM (SELECT id,name,price FROM product WHERE active=1 AND promotion=1 AND promotionTime=0 AND (stock>0 OR (SELECT sum(stock) from product_size AS ps ,size AS s where ps.sizeId=s.id AND productId=p.id)>0) UNION SELECT id,name,price FROM product WHERE active=1 AND promotion=1 AND (stock>0 OR (SELECT sum(stock) from product_size AS ps ,size AS s where ps.sizeId=s.id AND productId=p.id)>0) AND promotionTime=1 AND promotionFromDate<='2012-02-06' AND promotionToDate>='2012-02-06') AS q ORDER BY name ASC
Unknown column 'p.id' in 'where clause'