1054 - Unknown column 'pa1.specials_date_added' in 'order clause'

[ERROR:] db.php (0)
[ERROR:] class-page-results.php (0)
[ERROR:] mod-product-listing.php (133)
[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 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 (54,56)) JOIN specials pa2 ON (p.products_id = pa2.products_id AND pa2.status = '1' 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' 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 pa1.specials_date_added desc, pd.products_name LIMIT 0, 45;

[TEP STOP]