Area
SELECT b.name , a.idx from code_list as a
left outer join code_list_lang as b on a.idx = b.code_list_idx and b.lang='EN'
where a.idx in () order by b.name
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 b.name' at line 3