[Bitrix\Main\DB\SqlQueryException]
Mysql query error: (1054) Unknown column 'BUF.UF_TASK_COMMENT_TYPE' in 'where clause' (400)
SEL ECT
T.ID as ID,
T.GROUP_ID as GROUP_ID,
SU.USER_ID as USER_ID,
COUNT(DISTINCT FM.ID) AS COUNT
FR OM b_tasks T
INNER JOIN b_sonet_user2group SU
ON SU.GROUP_ID = T.GROUP_ID AND SU.USER_ID = 4
LEFT JOIN b_tasks_viewed TV
ON TV.TASK_ID = T.ID AND TV.USER_ID = SU.USER_ID
INNER JOIN b_forum_message FM
ON FM.TOPIC_ID = T.FORUM_TOPIC_ID
LEFT JOIN b_uts_forum_message BUF
ON BUF.VALUE_ID = FM.ID
WHERE
T.ZOMBIE = 'N' AND (
(TV.VIEWED_DATE IS NOT NULL AND FM.POST_DATE > TV.VIEWED_DATE)
OR (TV.VIEWED_DATE IS NULL AND FM.POST_DATE >= T.CREATED_DATE)
) AND (
FM.POST_DATE >= SU.DATE_CREATE
) AND (
(
FM.AUTHOR_ID <> SU.USER_ID
AND (
(BUF.UF_TASK_COMMENT_TYPE IS NULL OR BUF.UF_TASK_COMMENT_TYPE = 0)
OR BUF.UF_TASK_COMMENT_TYPE <> 4
)
)
OR
(
BUF.UF_TASK_COMMENT_TYPE = 5
)
) AND FM.NEW_TOPIC = 'N'
GROUP BY T.ID, SU.USER_ID
Mysql query error: (1054) Unknown column 'BUF.UF_TASK_COMMENT_TYPE' in 'where clause' (400)
SEL ECT
T.ID as ID,
T.GROUP_ID as GROUP_ID,
SU.USER_ID as USER_ID,
COUNT(DISTINCT FM.ID) AS COUNT
FR OM b_tasks T
INNER JOIN b_sonet_user2group SU
ON SU.GROUP_ID = T.GROUP_ID AND SU.USER_ID = 4
LEFT JOIN b_tasks_viewed TV
ON TV.TASK_ID = T.ID AND TV.USER_ID = SU.USER_ID
INNER JOIN b_forum_message FM
ON FM.TOPIC_ID = T.FORUM_TOPIC_ID
LEFT JOIN b_uts_forum_message BUF
ON BUF.VALUE_ID = FM.ID
WHERE
T.ZOMBIE = 'N' AND (
(TV.VIEWED_DATE IS NOT NULL AND FM.POST_DATE > TV.VIEWED_DATE)
OR (TV.VIEWED_DATE IS NULL AND FM.POST_DATE >= T.CREATED_DATE)
) AND (
FM.POST_DATE >= SU.DATE_CREATE
) AND (
(
FM.AUTHOR_ID <> SU.USER_ID
AND (
(BUF.UF_TASK_COMMENT_TYPE IS NULL OR BUF.UF_TASK_COMMENT_TYPE = 0)
OR BUF.UF_TASK_COMMENT_TYPE <> 4
)
)
OR
(
BUF.UF_TASK_COMMENT_TYPE = 5
)
) AND FM.NEW_TOPIC = 'N'
GROUP BY T.ID, SU.USER_ID