Infomaterial
user warning: Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ktecsaburg_db.node_data_field_verknuepfung.field_verknuepfung_nid' 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.type AS node_type,
node.vid AS node_vid,
node.title AS node_title,
node.language AS node_language,
node_data_field_verknuepfung.field_verknuepfung_nid AS node_data_field_verknuepfung_field_verknuepfung_nid,
node_data_field_verknuepfung.delta AS node_data_field_verknuepfung_delta,
node_data_field_file_upload.field_file_upload_fid AS node_data_field_file_upload_field_file_upload_fid,
node_data_field_file_upload.field_file_upload_list AS node_data_field_file_upload_field_file_upload_list,
node_data_field_file_upload.field_file_upload_data AS node_data_field_file_upload_field_file_upload_data,
node_data_field_file_upload.field_quelle_value AS node_data_field_file_upload_field_quelle_value,
node_data_field_file_upload.field_quelle_format AS node_data_field_file_upload_field_quelle_format
FROM node node
LEFT JOIN content_field_verknuepfung node_data_field_verknuepfung ON node.vid = node_data_field_verknuepfung.vid
LEFT JOIN node node_node_data_field_verknuepfung ON node_data_field_verknuepfung.field_verknuepfung_nid = node_node_data_field_verknuepfung.nid
LEFT JOIN content_type_infomaterial node_data_field_file_upload ON node.vid = node_data_field_file_upload.vid
WHERE node.type in ('infomaterial')
GROUP BY nid
in /var/www/vhosts/ktec-saarburg.de/httpdocs/sites/all/modules/views/includes/view.inc on line 811.
