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, 3186, 858, 3180, 2470)) AND (node.nid != 304664) AND (node.nid != 304664 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.
