Размер шрифта: A A A
Цвет сайта: A A A A

Список опросов


MySQL 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, IF((C.VOTE_SINGLE = 'Y'), (IF(V.ID = VV.ACTIVE_VOTE_ID, 'green', 'red')), (IF(V.ACTIVE = 'Y' AND V.DATE_START <= NOW() AND NOW() <= V.DATE_END, 'green', 'red'))) 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 0, 10[Got error 122 from storage engine]

DB query error.
Please try later.