Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static string UsersLoginByEmail(string email)
- {
- RETURN $@"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,StatusKontka.Atr_Wartosc as SklepStatus 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.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
- where Osoba.Atr_Wartosc='{email}' and Osoba.Atr_AtkId=55 and Osoba.Atr_ObiTyp=32
- ";
- }
Add Comment
Please, Sign In to add comment