select csGroups.ID as groupid,csUsers.UserName as username,csUsers.ID as id,csGroups_lang.Title as grouptitle from csGroups_lang,csUsers,csGroups,csUsers_Groups where csGroups.ID = csGroups_lang.ID and csUsers.ID = csUsers_Groups.UserID and csGroups.ID = csUsers_Groups.GroupID and (csUsers.ID IN (1,2)) order by username asc limit 0,10