mysql 5.0.51/drupal 7.0
errors:
# 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 ')) AND (FROM_UNIXTIME(node.created) > DATE_SUB(NOW(),INTERVAL 7 DAY)) GROUP BY ' at line 36 query: SELECT COUNT(*) FROM (SELECT node.nid AS nid, node.title AS node_title, node_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, node_revisions.body AS node_revisions_body, node.type AS node_type, node.vid AS node_vid, node_node_data_field_source.title AS node_node_data_field_source_title, node_node_data_field_source.nid AS node_node_data_field_source_nid, node_node_data_field_source_node_data_field_url.field_url_value AS node_node_data_field_source_node_data_field_url_field_url_value, node_node_data_field_source.type AS node_node_data_field_source_type, node_node_data_field_source.vid AS node_node_data_field_source_vid, node_node_data_field_source_node_data_field_url.field_combined_rank_value AS node_node_data_field_source_node_data_field_url_field_combined_rank_value, node_node_data_field_source_node_data_field_url.field_alexa_data_url_value AS node_node_data_field_source_node_data_field_url_field_alexa_data_url_value, node_node_data_field_source_node_data_field_url.field_favicon_url_value AS node_node_data_field_source_node_data_field_url_field_favicon_url_value, feedapi_node_item.url AS feedapi_node_item_url, feedapi_node_item.timestamp AS feedapi_node_item_timestamp, votingapi_cache_node_points_vote_sum.value AS votingapi_cache_node_points_vote_sum_value, node.created AS node_created, node_node_data_field_source_node_data_field_combined_rank.field_combined_rank_value AS node_node_data_field_source_node_data_field_combined_rank_field_combined_rank_value, DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL -18000 SECOND), '%Y%m%d') AS node_created_day FROM node node LEFT JOIN content_type_mention node_data_field_source ON node.vid = node_data_field_source.vid INNER JOIN node node_node_data_field_source ON node_data_field_source.field_source_nid = node_node_data_field_source.nid LEFT JOIN votingapi_cache votingapi_cache_node_points_vote_sum ON node.nid = votingapi_cache_node_points_vote_sum.content_id AND (votingapi_cache_node_points_vote_sum.content_type = 'node' AND votingapi_cache_node_points_vote_sum.value_type = 'points' AND votingapi_cache_node_points_vote_sum.tag = 'vote' AND votingapi_cache_node_points_vote_sum.function = 'sum') LEFT JOIN flag_content flag_content_node ON node_node_data_field_source.nid = flag_content_node.content_id AND flag_content_node.fid = 3 LEFT JOIN flag_content flag_content_node_1 ON node_node_data_field_source.nid = flag_content_node_1.content_id AND flag_content_node_1.fid = 2 LEFT JOIN flag_content flag_content_node_2 ON node.nid = flag_content_node_2.content_id AND flag_content_node_2.fid = 1 LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN content_type_source node_node_data_field_source_node_data_field_url ON node_node_data_field_source.vid = node_node_data_field_source_node_data_field_url.vid LEFT JOIN feedapi_node_item_feed feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN feedapi_node_item feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid LEFT JOIN content_type_source node_node_data_field_source_node_data_field_combined_rank ON node_node_data_field_source.vid = node_node_data_field_source_node_data_field_combined_rank.vid LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_node term_node2 ON node.vid = term_node2.vid WHERE (node.type in ('mention')) AND (node.status <> 0) AND (flag_content_node.uid IS NULL) AND (term_node.tid in (-1)) AND (term_node2.tid in ()) AND (FROM_UNIXTIME(node.created) > DATE_SUB(NOW(),INTERVAL 7 DAY)) GROUP BY nid, node_title, node_revisions_teaser, node_revisions_format, node_revisions_body, node_type, node_vid, node_node_data_field_source_title, node_node_data_field_source_nid, node_node_data_field_source_node_data_field_url_field_url_value, node_node_data_field_source_type, node_node_data_field_source_vid, node_node_data_field_source_node_data_field_url_field_combined_rank_value, node_node_data_field_source_node_data_field_url_field_alexa_data_url_value, node_node_data_field_source_node_data_field_url_field_favicon_url_value, feedapi_node_item_url, feedapi_node_item_timestamp, votingapi_cache_node_points_vote_sum_value, node_created, node_node_data_field_source_node_data_field_combined_rank_field_combined_rank_value, node_created_day ORDER BY node_created DESC, node_node_data_field_source_node_data_field_combined_rank_field_combined_rank_value DESC, node_created_day DESC ) count_alias in /var/www/tattler/sites/all/modules/views/includes/view.inc on line 729.
# 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 ')) AND (FROM_UNIXTIME(node.created) > DATE_SUB(NOW(),INTERVAL 7 DAY)) GROUP BY ' at line 36 query: SELECT node.nid AS nid, node.title AS node_title, node_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, node_revisions.body AS node_revisions_body, node.type AS node_type, node.vid AS node_vid, node_node_data_field_source.title AS node_node_data_field_source_title, node_node_data_field_source.nid AS node_node_data_field_source_nid, node_node_data_field_source_node_data_field_url.field_url_value AS node_node_data_field_source_node_data_field_url_field_url_value, node_node_data_field_source.type AS node_node_data_field_source_type, node_node_data_field_source.vid AS node_node_data_field_source_vid, node_node_data_field_source_node_data_field_url.field_combined_rank_value AS node_node_data_field_source_node_data_field_url_field_combined_rank_value, node_node_data_field_source_node_data_field_url.field_alexa_data_url_value AS node_node_data_field_source_node_data_field_url_field_alexa_data_url_value, node_node_data_field_source_node_data_field_url.field_favicon_url_value AS node_node_data_field_source_node_data_field_url_field_favicon_url_value, feedapi_node_item.url AS feedapi_node_item_url, feedapi_node_item.timestamp AS feedapi_node_item_timestamp, votingapi_cache_node_points_vote_sum.value AS votingapi_cache_node_points_vote_sum_value, node.created AS node_created, node_node_data_field_source_node_data_field_combined_rank.field_combined_rank_value AS node_node_data_field_source_node_data_field_combined_rank_field_combined_rank_value, DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL -18000 SECOND), '%Y%m%d') AS node_created_day FROM node node LEFT JOIN content_type_mention node_data_field_source ON node.vid = node_data_field_source.vid INNER JOIN node node_node_data_field_source ON node_data_field_source.field_source_nid = node_node_data_field_source.nid LEFT JOIN votingapi_cache votingapi_cache_node_points_vote_sum ON node.nid = votingapi_cache_node_points_vote_sum.content_id AND (votingapi_cache_node_points_vote_sum.content_type = 'node' AND votingapi_cache_node_points_vote_sum.value_type = 'points' AND votingapi_cache_node_points_vote_sum.tag = 'vote' AND votingapi_cache_node_points_vote_sum.function = 'sum') LEFT JOIN flag_content flag_content_node ON node_node_data_field_source.nid = flag_content_node.content_id AND flag_content_node.fid = 3 LEFT JOIN flag_content flag_content_node_1 ON node_node_data_field_source.nid = flag_content_node_1.content_id AND flag_content_node_1.fid = 2 LEFT JOIN flag_content flag_content_node_2 ON node.nid = flag_content_node_2.content_id AND flag_content_node_2.fid = 1 LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN content_type_source node_node_data_field_source_node_data_field_url ON node_node_data_field_source.vid = node_node_data_field_source_node_data_field_url.vid LEFT JOIN feedapi_node_item_feed feedapi_node_item_feed ON node.nid = feedapi_node_item_feed.feed_item_nid LEFT JOIN feedapi_node_item feedapi_node_item ON feedapi_node_item_feed.feed_item_nid = feedapi_node_item.nid LEFT JOIN content_type_source node_node_data_field_source_node_data_field_combined_rank ON node_node_data_field_source.vid = node_node_data_field_source_node_data_field_combined_rank.vid LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_node term_node2 ON node.vid = term_node2.vid WHERE (node.type in ('mention')) AND (node.status <> 0) AND (flag_content_node.uid IS NULL) AND (term_node.tid in (-1)) AND (term_node2.tid in ()) AND (FROM_UNIXTIME(node.created) > DATE_SUB(NOW(),INTERVAL 7 DAY)) GROUP BY nid, node_title, node_revisions_teaser, node_revisions_format, node_revisions_body, node_type, node_vid, node_node_data_field_source_title, node_node_data_field_source_nid, node_node_data_field_source_node_data_field_url_field_url_value, node_node_data_field_source_type, node_node_data_field_source_vid, node_node_data_field_source_node_data_field_url_field_combined_rank_value, node_node_data_field_source_node_data_field_url_field_alexa_data_url_value, node_node_data_field_source_node_data_field_url_field_favicon_url_value, feedapi_node_item_url, feedapi_node_item_timestamp, votingapi_cache_node_points_vote_sum_value, node_created, node_node_data_field_source_node_data_field_combined_rank_field_combined_rank_value, node_created_day ORDER BY node_created DESC, node_node_data_field_source_node_data_field_combined_rank_field_combined_rank_value DESC, node_created_day DESC LIMIT 0, 40 in /var/www/tattler/sites/all/modules/views/includes/view.inc on line 755.