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 'order by p.sort_order ASC' at line 11
SELECT p.products_id, pd.products_url
FROM products p,
products_description pd,
products_to_categories ptc
WHERE p.products_status = '1'
AND p.products_en_available = '1'
AND pd.products_id = p.products_id
AND p.products_availability != '0'
AND pd.language_id=1
AND p.products_id = ptc.products_id
AND ptc.categories_id = order by p.sort_order ASC
