1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND p.products_status = 1
GROUP BY ptc.products_id
ORDER BY field(p.type, 'core' at line 5
SELECT ptc.*, p.products_status, p.special_order, p.preorder, p.products_price, p.sort_priority, pd.products_name
FROM products_to_categories as ptc
LEFT JOIN products as p ON p.products_id = ptc.products_id
LEFT JOIN products_description as pd ON pd.products_id = ptc.products_id
WHERE categories_id = AND p.products_status = 1
GROUP BY ptc.products_id
ORDER BY field(p.type, 'core', 'upgrade', 'softgood', 'part', ''), p.sort_priority desc, pd.products_name