Error: Unknown column 'p.date_closed' in 'where clause'
Error No: 1054
SELECT COUNT(*) AS total FROM gu_product WHERE status = '1' AND date_available <= NOW() AND (NOW() <= p.date_closed OR p.date_closed = '0000-00-00') AND manufacturer_id = '1'