user warning: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'pauspetr_konoha.node.title' 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), node.title AS node_title, node.changed AS node_changed, node.created AS node_created, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node.type AS node_type FROM node node LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status = '1') AND (node.uid = 29271) AND (LEFT(TRIM(LEADING 'AND ' FROM (TRIM(LEADING 'THE ' FROM (TRIM(LEADING 'A ' FROM (TRIM(LEADING '\'' FROM (TRIM(LEADING '"' FROM (TRIM(LEADING ' ' FROM (UPPER(node.title))))))))))))), 1) = 'P') GROUP BY node.nid ORDER BY LEFT(TRIM(LEADING 'AND ' FROM (TRIM(LEADING 'THE ' FROM (TRIM(LEADING 'A ' FROM (TRIM(LEADING '\'' FROM (TRIM(LEADING '"' FROM (TRIM(LEADING ' ' FROM (UPPER(node.title))))))))))))), 1), node_title ASC, node_title ASC LIMIT 0, 500 in /var/www/html/includes/database.mysql.inc on line 172.