An Error Was Encountered

Error Number: 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 pdc_prio' at line 3

SELECT * FROM sp_pd_data INNER JOIN sp_pd_category ON pdd_pdc_id = pdc_id WHERE pdd_product_id = ORDER BY pdc_prio