|
|
|
Module: vote (4.0.6)
Class: CVote
File: /home/visionco/public_html/bitrix/modules/vote/classes/mysql/vote.php
Function: GetList
Line: 374
MySQL Query Error:
SELECT
C.TITLE as CHANNEL_TITLE,
V.*,
DATE_FORMAT(V.DATE_START, '%H:%i | %d-%m-%Y') DATE_START,
DATE_FORMAT(V.DATE_END, '%H:%i | %d-%m-%Y') DATE_END,
UNIX_TIMESTAMP(V.DATE_END)-UNIX_TIMESTAMP(V.DATE_START) PERIOD,
count(Q.ID) QUESTIONS,
if(V.ACTIVE='N','red',
if(now()<V.DATE_START, 'red',
if (now()>V.DATE_END, 'red',
'green')
)
) LAMP
FROM
b_vote V,
b_vote_channel C
LEFT JOIN b_vote_question Q ON (Q.VOTE_ID=V.ID)
WHERE
(1=1
AND
(
(
(V.ID='5' and V.ID is not null)
)
)
)
and C.ID=V.CHANNEL_ID
GROUP BY V.ID
ORDER BY V.ID desc
[Unknown column 'V.ID' in 'on clause']
DB query error.
Please try later. |
|
|
