user warning: Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'pcp_drupal.term_data.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT DISTINCT(node.nid) AS nid_1, node.nid AS nid, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.tid AS term_data_tid, node.created AS node_created, COUNT(node.nid) AS node_nid, node_counter.totalcount AS node_counter_totalcount, node_counter.timestamp AS node_counter_timestamp, node_counter.daycount AS node_counter_daycount FROM node node LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid LEFT JOIN node_counter node_counter ON node.nid = node_counter.nid WHERE ((term_node.tid IN (404, 402, 413)) AND (node.nid != 300117) AND (node.nid != 300117 OR node.nid IS NULL)) AND ((node.status = 1) AND (node.type not in ('agenda', 'mini_dossier')) AND (node.language in ('pt-pt')) ) GROUP BY nid_1 ORDER BY node_nid DESC, node_counter_totalcount DESC, node_counter_timestamp DESC, node_counter_daycount DESC, node_created DESC LIMIT 0, 4 in /home/pcp/public_html/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1191.