select s.ID, S.Localeid, s.foreignKey, s.priority, isnull(TS.Name ,s.name),s.defaultcontent from locales l inner join sections s on l.id = s.localeid left join sections TS on l.mappedtolocale = TS.id where l.locale = 'sv-SE' order by 2 asc

Synchronisation report

Last update ID = 23

Current Content Version = 23

sv-SE - 53431

DONE