1054 - Unknown column 'pa.1.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 specials pa1 ON (p.products_id = pa1.products_id AND pa1.status = '1' AND pa.1.customers_group_id = '0' AND (pa1.specials_new_products_price < p.products_price) AND (pa1.specials_end IS NULL OR pa1.specials_end >= CURDATE()) and (pa1.specials_begin IS NULL OR pa1.specials_begin = '0000-00-00 00:00:00' or pa1.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, 12;

[TEP STOP]