Unknown column 'p.deleted' in 'where clause' (SELECT p.*,SUM(pl.available) AS available, SUM(pl.allocated) AS allocated FROM mod_stock_productcategories AS pc JOIN mod_stock_categories AS c USING (categoryid) JOIN mod_stock_parts AS p ON pc.productid=p.id LEFT JOIN mod_stock_partsinlocations AS pl ON pl.partid=p.id WHERE (pc.categoryid='1' OR c.parentid='1') AND p.isproduct > 0 AND (pl.available > 0 OR (p.isinfinitestock > 0 AND ( SELECT SUM(al.`available`) AS instock FROM mod_stock_alternative AS a LEFT JOIN mod_stock_partsinlocations AS al ON a.alternativeid=al.partid WHERE a.partid=p.id ) > 0)) AND p.`deleted`=0 GROUP BY p.id ORDER BY p.bestseller DESC, p.`name` ASC;)