SELECT *
                FROM
                    " . CRM::$GLOBALS["fullprefix"] . "modules dat
                    LEFT JOIN
                    (
                        SELECT *
                        FROM " . CRM::$GLOBALS["fullprefix"] . "modules_content
                        ORDER BY IF(langId = " . CRM::$GLOBALS["lang"] . ", 1, 0) DESC
                    ) cnt ON dat.id = cnt.parentId
                GROUP BY dat.id