user warning: 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 ' 0) AS _value_coalesced
FROM node node
LEFT JOIN votingapi_cache votingapi_ca' at line 11
query: SELECT DISTINCT node.nid AS nid,
node_data_field_photokonkurs.field_photokonkurs_fid AS node_data_field_photokonkurs_field_photokonkurs_fid,
node_data_field_photokonkurs.field_photokonkurs_list AS node_data_field_photokonkurs_field_photokonkurs_list,
node_data_field_photokonkurs.field_photokonkurs_data AS node_data_field_photokonkurs_field_photokonkurs_data,
node.type AS node_type,
node.vid AS node_vid,
node_data_field_photokonkurs.field_author_photo_value AS node_data_field_photokonkurs_field_author_photo_value,
node_data_field_photokonkurs.field_mesto_value AS node_data_field_photokonkurs_field_mesto_value,
node.title AS node_title,
value,
COALESCE(.value, 0) AS _value_coalesced
FROM node node
LEFT JOIN votingapi_cache votingapi_cache_node ON node.nid = votingapi_cache_node.content_id AND votingapi_cache_node.content_type = 'advpoll'
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
LEFT JOIN content_type_photonakonkurs node_data_field_photokonkurs ON node.vid = node_data_field_photokonkurs.vid
INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'domain_site') OR (na.gid = 2 AND na.realm = 'domain_id') OR (na.gid = 1 AND na.realm = 'term_access'))) AND ( (node.type in ('photonakonkurs')) AND (node_revisions.timestamp >= 1388534400) AND (node_revisions.timestamp <= 1420070400) AND (node.status <> 0)
)ORDER BY _value_coalesced DESC
in /sites/astrgorod_portal/www/sites/all/modules/views/includes/view.inc on line 775.
