Index: trunk/core/units/languages/import_xml.php =================================================================== diff -u -N -r3316 -r3536 --- trunk/core/units/languages/import_xml.php (.../import_xml.php) (revision 3316) +++ trunk/core/units/languages/import_xml.php (.../import_xml.php) (revision 3536) @@ -354,7 +354,11 @@ if($event_ids) { $ret .= "\t\t".''."\n"; - $event_sql = 'SELECT * FROM '.$emailevents_table.' WHERE LanguageId = %s AND EventId IN (%s)'; + $event_sql = ' SELECT em.* + FROM '.$emailevents_table.' em + LEFT JOIN '.$mainevents_table.' e ON e.EventId = em.EventId + WHERE em.LanguageId = %s AND em.EventId IN (%s) + ORDER BY e.Event'; $rows = $this->Conn->Query( sprintf($event_sql,$language_id, $event_ids ? implode(',',$event_ids) : '' ) ); foreach($rows as $row) {