Notice: Error: Unknown column 'p2c.category_id' in 'where clause'
Error No: 1054
SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_to_category p2cc ON (p.product_id = p2cc.product_id) LEFT JOIN product_to_customer_groups p2cg ON (p2s.product_id = p2cg.p2cg_product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id != '374' AND p.product_id != '452' AND p.product_id != '453' AND p.product_id != '454' AND p.product_id != '455' AND p.product_id != '456' AND p.product_id != '457' AND p.product_id != '458' AND p.product_id != '459' AND p.product_id != '460' AND p.product_id != '461' AND p.product_id != '462' AND p.product_id != '463' AND p.product_id != '464' AND p.product_id != '465' AND p.product_id != '466' AND p.product_id != '467' AND p.product_id != '468' AND p.product_id != '469' AND p.product_id != '470' AND p.product_id != '471' AND p.product_id != '472' AND p.product_id != '473' AND p.product_id != '474' AND p.product_id != '475' AND p.product_id != '476' AND p.product_id != '477' AND p.product_id != '478' AND p.product_id != '479' AND p.product_id != '480' AND p.product_id != '481' AND p.product_id != '482' AND p.product_id != '483' AND p.product_id != '484' AND p.product_id != '485' AND p.product_id != '486' AND p.product_id != '487' AND p.product_id != '488' AND p.product_id != '489' AND p.product_id != '490' AND p.product_id != '516' AND p.product_id != '521' AND p.product_id != '522' AND p.product_id != '523' AND p.product_id != '524' AND p.product_id != '525' AND p.product_id != '528' AND p.product_id != '530' AND p.product_id != '531' AND p.product_id != '532' AND p.product_id != '533' AND p.product_id != '534' AND p.product_id != '535' AND p.product_id != '537' AND p.product_id != '538' AND p.product_id != '539' AND p.product_id != '540' AND p.product_id != '380' AND p.product_id != '381' AND p.product_id != '382' AND p.product_id != '385' AND p.product_id != '405' AND p.product_id != '406' AND p.product_id != '407' AND p.product_id != '408' AND p.product_id != '409' AND p.product_id != '410' AND p.product_id != '411' AND p.product_id != '412' AND p.product_id != '413' AND p.product_id != '414' AND p.product_id != '415' AND p.product_id != '416' AND p.product_id != '494' AND p.product_id != '495' AND p.product_id != '496' AND p.product_id != '497' AND p.product_id != '498' AND p.product_id != '560' AND p.product_id != '571' AND p.product_id != '572' AND p.product_id != '573' AND p.product_id != '574' AND p.product_id != '575' AND p.product_id != '576' AND p.product_id != '609' AND p.product_id != '610' AND p.product_id != '611' AND p.product_id != '612' AND p.product_id != '613' AND p.product_id != '614' AND p.product_id != '615' AND p.product_id != '616' AND p.product_id != '617' AND p.product_id != '618' AND p.product_id != '624' AND p.product_id != '625' AND p.product_id != '626' AND (pd.tag LIKE '%halo%') AND p2cg.p2cg_product_id IS NULL OR p2c.category_id = '0' AND p2cg.p2cg_customer_group_id = '1' in /home3/bbtstyle/public_html/system/database/mysql.php on line 50