• 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 'DISTINCT(node.nid), node_counter.totalcount AS node_counter_totalcount FROM ' at line 1 query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), node_counter.totalcount AS node_counter_totalcount FROM node node LEFT JOIN votingapi_cache votingapi_cache_node ON node.nid = votingapi_cache_node.content_id AND votingapi_cache_node.content_type = 'node' LEFT JOIN node_counter node_counter ON node.nid = node_counter.nid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all'))) AND ( (node.status <> 0) AND (node.type in ('love_letter')) )ORDER BY node_counter_totalcount DESC ) count_alias in /home8/yaminiec/public_html/myfoodvalentine/sites/all/modules/views/includes/view.inc on line 705.
  • 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 'DISTINCT(node.nid), node_counter.totalcount AS node_counter_totalcount FROM ' at line 1 query: SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), node_counter.totalcount AS node_counter_totalcount FROM node node LEFT JOIN votingapi_cache votingapi_cache_node ON node.nid = votingapi_cache_node.content_id AND votingapi_cache_node.content_type = 'node' LEFT JOIN node_counter node_counter ON node.nid = node_counter.nid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all'))) AND ( (node.status <> 0) AND (node.type in ('love_letter')) )ORDER BY node_counter_totalcount DESC LIMIT 0, 4 in /home8/yaminiec/public_html/myfoodvalentine/sites/all/modules/views/includes/view.inc on line 731.
  • 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 'DISTINCT(node.nid), node.title AS node_title, node_data_field_no_love_lett' at line 1 query: SELECT DISTINCT(node.nid) AS DISTINCT(node.nid), node.title AS node_title, node_data_field_no_love_letter.field_no_love_letter_value AS node_data_field_no_love_letter_field_no_love_letter_value, node.type AS node_type, node.vid AS node_vid FROM node node LEFT JOIN content_type_food node_data_field_no_love_letter ON node.vid = node_data_field_no_love_letter.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all'))) AND ( (node.status <> 0) AND (node.type in ('food')) )ORDER BY node_data_field_no_love_letter_field_no_love_letter_value DESC LIMIT 0, 10 in /home8/yaminiec/public_html/myfoodvalentine/sites/all/modules/views/includes/view.inc on line 731.