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

[ERROR:] db.php (0)
[ERROR:] store-applications-core.php (0)
[ERROR:] product-specials.php (0)
[ERROR:] xoProxy.php (0)

SELECT p2m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, COUNT(DISTINCT p.products_id) products_count FROM products_to_manufacturers p2m JOIN manufacturers m ON m.manufacturers_id = p2m.manufacturers_id JOIN products p ON p.products_id = p2m.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 p.products_status = '1' AND NOT (p.products_family != '' AND p.products_master > 0 AND p.products_master != p.products_id) GROUP BY p2m.manufacturers_id ORDER BY m.sort_order, m.manufacturers_name;

[TEP STOP]