Třídová akce

Kód:

1

Tělo:

SELECT A.ID, A.Name, A.ShortName, A.LoginName, ADR.EMail,
  ( SELECT COUNT(*)
  	FROM SecurityPrivilegeRights SPR
  	JOIN SecurityUserRoleLinks SURL ON SURL.Role_ID = SPR.Role_ID
  	WHERE SURL.User_ID = A.ID
  ) AS IsAdmin
FROM SecurityUsers A
JOIN Addresses ADR ON ADR.ID = A.Address_ID
WHERE A.ID = :UserID

Generated by ABRA Software a.s. 27.10.2021 16:34:11