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 sort' at line 1<hr />SELECT SHOP2_navi.ID, SHOP2_navi.parentID, SHOP2_navi.text, SHOP2_navi.sort, SHOP2_navi_description.text as desc_text FROM SHOP2_navi LEFT JOIN SHOP2_navi_description ON SHOP2_navi.ID = SHOP2_navi_description.IDnavi WHERE parentID =  ORDER BY sort<hr />