Архив опросов


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!