lsa_YOS/src/custom/restcontroller/webmanage/role/SQL/角色选项限制查询列表.sql

SELECT t1.*
from (
         SELECT DISTINCT t1.roleid, t1.optiontypeid, t2.remarks optionttypename, t3.rolename
         from sys_role_optionlimit t1
                  LEFT JOIN sys_optiontype t2 ON t2.optiontypeid = t1.optiontypeid
                  LEFT JOIN sys_role t3 ON t3.roleid = t1.roleid
         where t3.siteid = $siteid$
           and t1.roleid = $roleid$
     ) t1