09/18/2019 11:33:35
Date
DB Execute Failed. ERROR: more than one row returned by a subquery used as an expression
Failure Notice
SELECT '0' AS ID,'' AS CATEGORY_TITLE,
'CUSTOM_'||cf.ID AS COLUMN_NAME,cf.TYPE,cf.TITLE,cf.SELECT_OPTIONS
FROM STAFF_FIELDS cf
WHERE (SELECT CAN_USE
FROM PROFILE_EXCEPTIONS WHERE PROFILE_ID='1'
AND MODNAME='Users/User.php&category_id='||cf.CATEGORY_ID)='Y'
AND ((SELECT VALUE
FROM PROGRAM_USER_CONFIG
WHERE TITLE=cast(cf.ID AS TEXT)
AND PROGRAM='StaffFieldsSearch'
AND USER_ID='1')='Y')
ORDER BY cf.SORT_ORDER,cf.TITLE
SQL query