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/ on line 775.