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 name_' at line 1
SELECT ml1.content as name_fr, ml2.content as name_en, t.id FROM tblTags t left join tblCoreText ml1 on t.name_mlid=ml1.content_id and ml1.lang_id=1 left join tblCoreText ml2 on t.name_mlid=ml2.content_id and ml2.lang_id=3 WHERE t.id in (select tag_id from tblArticlesTags where article_id=) ORDER BY name_