участники проекта
Query Error: SELECT UG.ID as ID, UG.USER_ID as USER_ID, UG.ROLE as ROLE, DATE_FORMAT(UG.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE, DATE_FORMAT(UG.DATE_UPDATE, '%d.%m.%Y %H:%i:%s') as DATE_UPDATE, U.NAME as USER_NAME, U.LAST_NAME as USER_LAST_NAME, U.SECOND_NAME as USER_SECOND_NAME, U.LOGIN as USER_LOGIN, U.PERSONAL_PHOTO as USER_PERSONAL_PHOTO, U.PERSONAL_GENDER as USER_PERSONAL_GENDER, CASE U.LAST_ACTIVITY_DATE > DATE_SUB(NOW(), INTERVAL 120 SECOND) THEN 'Y' ELSE 'N' END as USER_IS_ONLINE FROM b_sonet_user2group UG INNER JOIN b_user U ON (UG.USER_ID = U.ID) WHERE ((UG.GROUP_ID = 1684 )) AND ((UG.ROLE <= 'K' )) AND ((U.ACTIVE = 'Y' )) ORDER BY U.LAST_NAME ASC, U.NAME ASC LIMIT 30 OFFSET 0[[1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'THEN 'Y' ELSE 'N' END as USER_IS_ONLINE FROM b_sonet_user2group UG INNER JOIN b' at line 1]
Query Error!