Notice: Error: Unknown column 'p2c.category_id' in 'where clause'
Error No: 1054
SELECT COUNT(DISTINCT ps.product_id) AS total FROM oc_product_special ps LEFT JOIN oc_product p ON (ps.product_id = p.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND ((p2c.category_id IN (103,104,105,106,113,114,115,116,117,118,271,335,124,125,126,128,129,130,132,133,134,316,143,144,145,147,148,149,150,1,1,152,108,109,110,111,112,274,241,222,127,217,158,159,345,344,135,119,120,121,122,124,125,126,127,128,129,130,132,133,134,135,136,137,138,140,141,143,144,145,147,148,149,150,151,152,217,303,309,310,311,316,336,341,344,345,349,354) AND p.quantity=0) OR p.quantity>=1) AND p2s.store_id = '0' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) in /home/sbshop/public_html/system/database/mysql.php on line 50