Displaying 1 to 20 (of 131 products)
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_421_1624104333_336352152)) 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 = 421 ORDER BY BINARY ptc.categories_id=517 desc, p.products_id , pd.products_name LIMIT 0, 20

[TEP STOP]