SELECT DISTINCT
      UsrMain.Status as "Status",
      UsrMain.PKey as "PKey",
      UsrMain.Salutation as "Salutation",
      UsrMain.BirthDate as "BirthDate",
      UsrMain.Sex as "Sex",
      UsrMain.Title as "Title",
      UsrMain.FirstName as "FirstName",
      UsrMain.LanguageSpoken as "LanguageSpoken",
      UsrMain.MaritalStatus as "MaritalStatus",
      UsrMain.Opening as "Opening",
      UsrMain.MiddleName as "MiddleName",
      UsrMain.EmployId as "EmployId",
      UsrMain.Name as "Name",
      UsrMain.Initials as "Initials",
      UsrMain.LoginName as "LoginName",
      UsrMain.Id as "Id",
      UsrMain.Active as "Active",
      UsrMain.DefaultDivision as "DefaultDivision",
      UsrMain.DefaultDistribChannel as "DefaultDistribChannel",
      UsrMain.DefaultSalesOrg as "DefaultSalesOrg",
      UsrMain.SysRegionalOptionsPKey as "SysRegionalOptionsPKey",
      UsrMain.CssLogicalUnitPKey as "CssLogicalUnitPKey",
      UsrMain.EtpSalesAreaPKey as "EtpSalesAreaPKey",
      UsrSales.Status as "UsrSalesStatus",
      UsrSales.PKey as "UsrSalesPKey",
      UsrSales.SalesOrg as "SalesOrg",
      UsrSales.DistribChannel as "DistribChannel",
      UsrSales.Division as "Division",
      UsrSales.UsrMainPKey as "UsrMainPKey",
      UsrSales.EtpSalesAreaPKey as "UsrSalesEtpSalesAreaPKey",
      UsrSales.BplMainPKey as "BplMainPKey",
      UsrSales.SysPeriodPKey as "SysPeriodPKey",
      UsrSales.UsrGroupPKey as "UsrGroupPKey",
      UsrSales.BplSegmentPKey as "BplSegmentPKey",
      UsrSales.SdoMetaPKey as "SdoMetaPKey",
      UsrSales.SdoItemMetaPKey as "SdoItemMetaPKey",
      UsrSales.ClbMetaPKey as "ClbMetaPKey",
      UsrSales.BpaMainPKey as "UsrSalesBpaMainPKey",
      CssLogicalUnit.UserLu as "UserLu",
      UsrMain.LastName as "LastName",
      UsrMain.UserAu as "UserAu",
      CASE WHEN MobileCssLogicalUnit.UserLu is NULL then N' ' ELSE MobileCssLogicalUnit.UserLu END as "MobileUserLu",
      UsrMeta.UsrType as "MetaUsrType",
      UsrMain.PwdExpirationDate as "PwdExpirationDate",
      UsrMain.PwdChangeNextLogin as "PwdChangeNextLogin" 
FROM
      USRMAIN UsrMain 
     LEFT OUTER JOIN
      CSSLOGICALUNIT MobileCssLogicalUnit 
     LEFT OUTER JOIN
      CSSTEXT MobileCssText ON MobileCssText.ReferencePKey=MobileCssLogicalUnit.PKey
      AND MobileCssText.Usage='LogicalUnit'
      AND MobileCssText.Status<>'d'
      AND MobileCssText.Language=#UserLanguage#
      AND MobileCssLogicalUnit.Status<>'d'  
     INNER JOIN
      CSSLUMETA MobileCssLuMeta ON MobileCssLuMeta.PKey=MobileCssLogicalUnit.CssLuMetaPKey 
      AND MobileCssLuMeta.Status<>'d'
      AND MobileCssLogicalUnit.Status<>'d' ON MobileCssLogicalUnit.PKey=UsrMain.CssLogicalUnitMobilePKey
      AND MobileCssLogicalUnit.Status<>'d'
      AND UsrMain.Status<>'d'
      AND UsrMain.Client=#Client#  
     INNER JOIN
      USRSALES UsrSales ON UsrMain.PKey=UsrSales.UsrMainPKey
      AND UsrSales.Status<>'d'
      AND UsrSales.SalesOrg=#SalesOrg#
      AND UsrSales.DistribChannel=#DistribChannel#
      AND UsrSales.Division=#Division#
      AND UsrSales.Client=#Client#
      AND UsrMain.Status<>'d'
      AND UsrMain.Client=#Client# 
     INNER JOIN
      CSSLOGICALUNIT CssLogicalUnit ON CssLogicalUnit.PKey=UsrMain.CssLogicalUnitPKey
      AND CssLogicalUnit.Status<>'d'
      AND UsrMain.Status<>'d'
      AND UsrMain.Client=#Client# 
     INNER JOIN
      USRMETA UsrMeta ON UsrMain.UsrMetaPKey=UsrMeta.PKey
      AND UsrMeta.Status<>'d'
      AND UsrMeta.Client=#Client#
      AND UsrMain.Status<>'d'
      AND UsrMain.Client=#Client# 
     INNER JOIN
      ETPORGUSRREL EtpOrgUsrRel  
     INNER JOIN
      ETPORGUSRREL MainOrgUnitEtpOrgUsrRel ON EtpOrgUsrRel.EtpOrgMainPKey=MainOrgUnitEtpOrgUsrRel.EtpOrgMainPKey
      AND MainOrgUnitEtpOrgUsrRel.UsrMainPKey=#UserPKey#
      AND MainOrgUnitEtpOrgUsrRel.ValidFrom<=#today#
      AND #today#<=MainOrgUnitEtpOrgUsrRel.ValidThru
      AND MainOrgUnitEtpOrgUsrRel.Status<>'d'
      AND MainOrgUnitEtpOrgUsrRel.SalesOrg=#SalesOrg#
      AND MainOrgUnitEtpOrgUsrRel.DistribChannel=#DistribChannel#
      AND MainOrgUnitEtpOrgUsrRel.Division=#Division#
      AND MainOrgUnitEtpOrgUsrRel.Client=#Client# ON UsrMain.PKey=EtpOrgUsrRel.UsrMainPKey
      AND EtpOrgUsrRel.Status<>'d'
      AND EtpOrgUsrRel.SalesOrg=#SalesOrg#
      AND EtpOrgUsrRel.DistribChannel=#DistribChannel#
      AND EtpOrgUsrRel.Division=#Division#
      AND EtpOrgUsrRel.Client=#Client#
      AND UsrMain.Status<>'d'
      AND UsrMain.Client=#Client# 
WHERE
      UsrMain.Status<>'d'
      AND UsrMain.Client=#Client#
      AND UsrMain.Active='1' 
      AND EtpOrgUsrRel.UsrMainPKey<>#UserPKey#
      AND #cond# #sort#