Bremen Stubnitz Media Archive Selections

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC' at line 25 query: SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, node.language AS node_language, node_data_field_media_preview.field_media_preview_fid AS node_data_field_media_preview_field_media_preview_fid, node_data_field_media_preview.field_media_preview_list AS node_data_field_media_preview_field_media_preview_list, node_data_field_media_preview.field_media_preview_data AS node_data_field_media_preview_field_media_preview_data, node.type AS node_type, node.vid AS node_vid, node_data_field_event_type.field_event_type_value AS node_data_field_event_type_field_event_type_value, node_data_field_harbour.field_harbour_value AS node_data_field_harbour_field_harbour_value, node_data_field_year.field_year_value AS node_data_field_year_field_year_value, node_data_field_date.field_date_value AS node_data_field_date_field_date_value, term_data.name AS term_data_name, position FROM node node LEFT JOIN term_node term_node ON node.vid = term_node.vid INNER JOIN term_data term_data ON term_node.tid = term_data.tid LEFT JOIN content_field_media_preview node_data_field_media_preview ON node.vid = node_data_field_media_preview.vid LEFT JOIN content_field_event_type node_data_field_event_type ON node.vid = node_data_field_event_type.vid LEFT JOIN content_field_harbour node_data_field_harbour ON node.vid = node_data_field_harbour.vid LEFT JOIN content_field_year node_data_field_year ON node.vid = node_data_field_year.vid LEFT JOIN content_field_date node_data_field_date ON node.vid = node_data_field_date.vid WHERE (node.type in ('audio', 'videoclip')) AND (term_data.name = 'media_bremen_2012') GROUP BY nid ORDER BY term_data_name ASC, DESC in /var/www/ms/drupal-6.16/modules/views/includes/view.inc on line 814.

Partners