1054 - Unknown column 'pa.2.customers_group_id' in 'on clause'

[ERROR:] db.php (0)
[ERROR:] class-page-results.php (0)
[ERROR:] mod-product-listing.php (0)
[ERROR:] product-specials.php (0)
[ERROR:] xoProxy.php (0)

SELECT SQL_CALC_FOUND_ROWS DISTINCT p.*, pd.products_name, pd.products_short_description AS products_short_description, pd.products_head_title_tag AS products_title, (SELECT GROUP_CONCAT(p2m.manufacturers_id) FROM products_to_manufacturers p2m WHERE p.products_id = p2m.products_id) AS manufacturers_id, slp.slp_value, slp.slp_value2, f.status, f.featured_begin, f.featured_end FROM products p LEFT JOIN products_description pd ON pd.products_id = p.products_id LEFT JOIN slp slp ON (p.products_unit_id = slp.slp_id AND slp.language_id = '2') LEFT JOIN featured f ON p.products_id = f.products_id JOIN products_to_categories pa1 ON (p.products_id = pa1.products_id AND pa1.categories_id NOT IN (194,200,209,208,207,263,287,288,289,291,292,293,294,295,296,286,285,283,265,267,269,271,273,275,277,279,281,297,290,206,205,204,237,250,251,252,253,254,255,256,257,258,259,249,248,238,239,240,241,242,243,244,246,247,260,245,203,210,223,224,225,226,227,228,229,230,231,232,222,221,211,212,213,214,215,216,217,218,219,220,233,202,201,298,300,314,315,316,317,318,319,320,321,313,312,311,301,303,304,305,308,309,310,322,307,588,596,595,594,593,592,591,590,589,597)) JOIN specials pa2 ON (p.products_id = pa2.products_id AND pa2.status = '1' AND pa.2.customers_group_id = '0' AND (pa2.specials_new_products_price < p.products_price) AND (pa2.specials_end IS NULL OR pa2.specials_end >= CURDATE()) and (pa2.specials_begin IS NULL OR pa2.specials_begin = '0000-00-00 00:00:00' or pa2.specials_begin < NOW())) WHERE pd.language_id = '2' AND p.products_status = '1' AND NOT (p.products_family != '' AND p.products_master > 0 AND p.products_master != p.products_id) order by specials_date_added desc, pd.products_name LIMIT 0, 5;

[TEP STOP]