SELECT 1000000 *Osoba.Atr_ObiLp + Osoba.Atr_ObiNumer AS Id ,osoba.Atr_Wartosc AS SklepLogin ,Hasla.Atr_Wartosc AS SklepHaslo,Hasla2.Atr_Wartosc AS SklepHaslo2,
            CASE TLM_Jezyk WHEN 701 THEN TLM_Tekst  ELSE StatusKontka.Atr_Wartosc END  AS SklepStatus,AtW_ID AS StatusNumer FROM cdn.Atrybuty AS Osoba
            JOIN cdn.Atrybuty StatusKontka ON  Osoba.Atr_ObiNumer=StatusKontka.Atr_ObiNumer AND Osoba.atr_obilp=StatusKontka.atr_obilp AND StatusKontka.Atr_ObiTyp=32 AND StatusKontka.Atr_AtkId=56
            JOIN cdn.AtrybutyWartosci ON StatusKontka.Atr_Wartosc=AtW_Wartosc  AND AtW_AtKId=56
             JOIN cdn.Atrybuty AS Hasla WITH (nolock) ON Osoba.Atr_ObiNumer = hasla.Atr_ObiNumer AND Osoba.atr_obilp = hasla.atr_obilp AND hasla.Atr_ObiSubLp = 8211 AND hasla.Atr_AtkId = 53
            LEFT JOIN cdn.Atrybuty AS Hasla2  WITH (nolock) ON Osoba.Atr_ObiNumer = hasla2.Atr_ObiNumer AND Osoba.atr_obilp = hasla2.atr_obilp AND hasla2.Atr_ObiSubLp = 8211 AND hasla2.Atr_AtkId = 54
            LEFT JOIN cdn.tlumaczenia ON TLM_Numer=AtW_ID AND TLM_Typ=14417 AND TLM_Jezyk=0
            WHERE Osoba.Atr_Wartosc='xxxxxx' AND Osoba.Atr_AtkId=55 AND Osoba.Atr_ObiTyp=32