user warning: Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'romaeduc_web.node_node_data_field_related_publications_1_node_data_field_related_publications.delta' 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, node.title AS node_title, node_data_field_publication.field_publication_fid AS node_data_field_publication_field_publication_fid, node_data_field_publication.field_publication_list AS node_data_field_publication_field_publication_list, node_data_field_publication.field_publication_data AS node_data_field_publication_field_publication_data, node.type AS node_type, node.vid AS node_vid, node_node_data_field_related_publications_1_node_data_field_related_publications.delta AS node_node_data_field_related_publications_1_node_data_field_related_publications_delta FROM node node LEFT JOIN ( content_field_related_publications node_data_field_related_publications INNER JOIN node node_node_data_field_related_publications ON node_data_field_related_publications.vid = node_node_data_field_related_publications.vid ) ON node.nid = node_data_field_related_publications.field_related_publications_nid LEFT JOIN content_field_related_publications node_node_data_field_related_publications_node_data_field_related_publications ON node_node_data_field_related_publications.vid = node_node_data_field_related_publications_node_data_field_related_publications.vid LEFT JOIN node node_node_data_field_related_publications_1 ON node_node_data_field_related_publications_node_data_field_related_publications.field_related_publications_nid = node_node_data_field_related_publications_1.nid LEFT JOIN content_type_publication node_data_field_publication ON node.vid = node_data_field_publication.vid LEFT JOIN content_field_related_publications node_node_data_field_related_publications_1_node_data_field_related_publications ON node_node_data_field_related_publications_1.vid = node_node_data_field_related_publications_1_node_data_field_related_publications.vid WHERE (node.status = 1 OR (node.uid = 0 AND 0 <> 0) OR 0 = 1) AND (node.type in ('publication')) AND (node_node_data_field_related_publications.nid = 269 ) GROUP BY nid ORDER BY node_node_data_field_related_publications_1_node_data_field_related_publications_delta ASC LIMIT 0, 3 in /home/romaeduc/old/public_html/sites/all/modules/views/includes/view.inc on line 807.

Annual Reports

Picture