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 PD.COMP_ID= ORDER BY PD.PROD_DISPLAY_PRIORITY' at line 1