Loading ...

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 'ORDER BY node_changed DESC LIMIT 0, 1' at line 30 query: SELECT node.nid AS nid, COALESCE(node_node_data_field_moddl_mod_ref_node_data_field_mod_title.field_mod_title_value, node_node_data_field_moddl_mod_ref.nid, node_node_data_field_moddl_mod_ref.type, node_node_data_field_moddl_mod_ref.vid, node_node_data_field_moddesc_mod_ref_node_data_field_mod_title.field_mod_title_value, node_node_data_field_moddesc_mod_ref.nid, node_node_data_field_moddesc_mod_ref.type, node_node_data_field_moddesc_mod_ref.vid) AS node_node_data_field_moddl_mod_ref_node_data_field_mod_title_field_mod_title_value, users.name AS users_name, COALESCE(node_node_data_field_moddl_mod_ref.changed, node_node_data_field_moddesc_mod_ref.changed) AS node_node_data_field_moddl_mod_ref_changed, node_node_data_field_moddl_system_ref.title AS node_node_data_field_moddl_system_ref_title, node_node_data_field_moddl_system_ref.nid AS node_node_data_field_moddl_system_ref_nid, COALESCE(node_node_data_field_moddl_system_ref_node_data_field_system_image.field_system_image_fid, node_node_data_field_moddl_system_ref_node_data_field_system_image.field_system_image_list, node_node_data_field_moddl_system_ref_node_data_field_system_image.field_system_image_data, node_node_data_field_moddl_system_ref.nid, node_node_data_field_moddl_system_ref.type, node_node_data_field_moddl_system_ref.vid, node_node_data_field_moddesc_system_ref_node_data_field_system_image.field_system_image_fid, node_node_data_field_moddesc_system_ref_node_data_field_system_image.field_system_image_list, node_node_data_field_moddesc_system_ref_node_data_field_system_image.field_system_image_data, node_node_data_field_moddesc_system_ref.nid, node_node_data_field_moddesc_system_ref.type, node_node_data_field_moddesc_system_ref.vid) AS node_node_data_field_moddl_system_ref_node_data_field_system_image_field_system_image_fid, node.changed AS node_changed FROM node node LEFT JOIN content_type_mod_download node_data_field_moddl_mod_ref ON node.vid = node_data_field_moddl_mod_ref.vid LEFT JOIN node node_node_data_field_moddl_mod_ref ON node_data_field_moddl_mod_ref.field_moddl_mod_ref_nid = node_node_data_field_moddl_mod_ref.nid LEFT JOIN content_type_mod node_node_data_field_moddl_mod_ref_node_data_field_mod_game_ref ON node_node_data_field_moddl_mod_ref.vid = node_node_data_field_moddl_mod_ref_node_data_field_mod_game_ref.vid LEFT JOIN node node_node_data_field_mod_game_ref ON node_node_data_field_moddl_mod_ref_node_data_field_mod_game_ref.field_mod_game_ref_nid = node_node_data_field_mod_game_ref.nid LEFT JOIN content_type_mod_download node_data_field_moddl_system_ref ON node.vid = node_data_field_moddl_system_ref.vid LEFT JOIN node node_node_data_field_moddl_system_ref ON node_data_field_moddl_system_ref.field_moddl_system_ref_nid = node_node_data_field_moddl_system_ref.nid LEFT JOIN content_field_moddl_language_ref node_data_field_moddl_language_ref ON node.vid = node_data_field_moddl_language_ref.vid LEFT JOIN node node_node_data_field_moddl_language_ref ON node_data_field_moddl_language_ref.field_moddl_language_ref_nid = node_node_data_field_moddl_language_ref.nid LEFT JOIN content_type_mod_description node_data_field_moddesc_mod_ref ON node.vid = node_data_field_moddesc_mod_ref.vid LEFT JOIN node node_node_data_field_moddesc_mod_ref ON node_data_field_moddesc_mod_ref.field_moddesc_mod_ref_nid = node_node_data_field_moddesc_mod_ref.nid LEFT JOIN content_type_mod_description node_data_field_moddesc_system_ref ON node.vid = node_data_field_moddesc_system_ref.vid LEFT JOIN node node_node_data_field_moddesc_system_ref ON node_data_field_moddesc_system_ref.field_moddesc_system_ref_nid = node_node_data_field_moddesc_system_ref.nid LEFT JOIN content_type_mod node_node_data_field_moddesc_mod_ref_node_data_field_mod_game_ref ON node_node_data_field_moddesc_mod_ref.vid = node_node_data_field_moddesc_mod_ref_node_data_field_mod_game_ref.vid LEFT JOIN node node_node_data_field_mod_game_ref_1 ON node_node_data_field_moddesc_mod_ref_node_data_field_mod_game_ref.field_mod_game_ref_nid = node_node_data_field_mod_game_ref_1.nid LEFT JOIN content_type_mod node_node_data_field_moddl_mod_ref_node_data_field_mod_title ON node_node_data_field_moddl_mod_ref.vid = node_node_data_field_moddl_mod_ref_node_data_field_mod_title.vid LEFT JOIN content_type_mod node_node_data_field_moddesc_mod_ref_node_data_field_mod_title ON node_node_data_field_moddesc_mod_ref.vid = node_node_data_field_moddesc_mod_ref_node_data_field_mod_title.vid INNER JOIN users users ON node.uid = users.uid LEFT JOIN content_type_system node_node_data_field_moddl_system_ref_node_data_field_system_image ON node_node_data_field_moddl_system_ref.vid = node_node_data_field_moddl_system_ref_node_data_field_system_image.vid LEFT JOIN content_type_system node_node_data_field_moddesc_system_ref_node_data_field_system_image ON node_node_data_field_moddesc_system_ref.vid = node_node_data_field_moddesc_system_ref_node_data_field_system_image.vid WHERE ORDER BY node_changed DESC LIMIT 0, 1 in /srv/www/patches-scrolls.de/htdocs/sites/all/modules/views/includes/view.inc on line 807.

Your rating: None Average: 1 (1 vote)