user warning: Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'gq_main.votingapi_cache_node_percent_average.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: execute /* Anonymous : execute */ SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node_data_field_game_screenshot.field_game_screenshot_fid AS node_data_field_game_screenshot_field_game_screenshot_fid, node_data_field_game_screenshot.field_game_screenshot_list AS node_data_field_game_screenshot_field_game_screenshot_list, node_data_field_game_screenshot.field_game_screenshot_data AS node_data_field_game_screenshot_field_game_screenshot_data, node.type AS node_type, node.vid AS node_vid, votingapi_cache_node_percent_average.value AS votingapi_cache_node_percent_average_value FROM node node LEFT JOIN votingapi_cache votingapi_cache_node_percent_average ON node.nid = votingapi_cache_node_percent_average.content_id AND (votingapi_cache_node_percent_average.content_type = 'node' AND votingapi_cache_node_percent_average.value_type = 'percent' AND votingapi_cache_node_percent_average.function = 'average') LEFT JOIN term_node term_node ON node.vid = term_node.vid INNER JOIN term_data term_data ON term_node.tid = term_data.tid LEFT JOIN content_type_minigame node_data_field_game_screenshot ON node.vid = node_data_field_game_screenshot.vid WHERE (node.type in ('minigame')) AND (node.status <> 0) AND (term_data.name = 'arcade') GROUP BY nid ORDER BY votingapi_cache_node_percent_average_value DESC in /var/www/sites/all/modules/views/includes/view.inc on line 775.