Query Error:
SELECT C.TITLE CHANNEL_TITLE, V.*, V.KEEP_IP_SEC as DELAY, 'S' as DELAY_TYPE,
DATE_FORMAT(V.DATE_START, '%d.%m.%Y %H:%i:%s') DATE_START,
DATE_FORMAT(V.DATE_END, '%d.%m.%Y %H:%i:%s') DATE_END,
V4.MAX_PERMISSION, V4.LAMP
FROM (
SELECT V.CHANNEL_ID, V.ID,
max(G.PERMISSION) as MAX_PERMISSION,
(CASE WHEN (C.VOTE_SINGLE = 'Y') THEN
(CASE WHEN (V.ID = VV.ACTIVE_VOTE_ID) THEN 'green' ELSE 'red' END) ELSE
(CASE WHEN (V.ACTIVE = 'Y' AND V.DATE_START <= NOW() AND NOW() <= V.DATE_END) THEN 'green' ELSE 'red' END)) END LAMP
FROM b_vote V
INNER JOIN b_vote_channel C ON (C.ACTIVE = 'Y' AND C.HIDDEN = 'N' AND V.CHANNEL_ID = C.ID)
LEFT JOIN (
SELECT VVV.CHANNEL_ID, MAX(VVV.ID) AS ACTIVE_VOTE_ID
FROM b_vote VVV, b_vote_channel CCC
WHERE VVV.CHANNEL_ID = CCC.ID AND CCC.VOTE_SINGLE='Y' AND VVV.ACTIVE = 'Y'
AND NOW() >= VVV.DATE_START AND VVV.DATE_END >= NOW()
GROUP BY VVV.CHANNEL_ID) VV ON (VV.CHANNEL_ID = V.CHANNEL_ID)
LEFT JOIN b_vote_channel_2_group G ON (G.CHANNEL_ID = C.ID and G.GROUP_ID in (2))
LEFT JOIN b_vote_channel_2_site CS ON (C.ID = CS.CHANNEL_ID)
WHERE
(1=1
AND
(
(
(CS.SITE_ID='s1' and CS.SITE_ID is not null)
)
)
)
AND V.ACTIVE = 'Y' AND V.DATE_START <= NOW()
GROUP BY V.CHANNEL_ID, V.ID
HAVING MAX_PERMISSION > 0
) V4
INNER JOIN b_vote V ON (V4.ID = V.ID)
INNER JOIN b_vote_channel C ON (V4.CHANNEL_ID = C.ID)
ORDER BY C.C_SORT, C.ID, V.C_SORT, V.DATE_START desc LIMIT 10 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 ') END LAMP
FROM b_vote V
INNER JOIN b_vote_channel C ON (C.ACTIVE = 'Y'' at line 10]
Query Error!