1054 - Unknown column 'ptc.categories_id' in 'order clause'
SELECT p.*, pd.*, m.*,
IF(s.status, s.specials_new_products_price, NULL) AS specials_new_products_price,
IF(s.status, s.specials_new_products_price, p.products_price) AS final_price,
p.products_quantity AS in_stock,
IF(s.status, 1, 0) AS is_special
FROM
products p
LEFT JOIN specials s ON p.products_id = s.products_id
INNER JOIN products_description pd ON p.products_id = pd.products_id
LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id
INNER JOIN products_to_categories p2c
WHERE (((p.products_quantity>0) or ((p.products_quantity<1) and (DATEDIFF(now(), p.products_date_added)<30))) or
p.products_id in
(SELECT sumttid
FROM cat_table_229_257540024_1826549464)) AND p.products_status = 1 AND p.products_id = p2c.products_id AND pd.products_id = p2c.products_id AND pd.language_id =
1 AND p2c.categories_id = 229 ORDER BY BINARY ptc.categories_id=517 desc, p.products_id , pd.products_name LIMIT 0, 20