СВФУ имени М.К. Аммосова
user warning: Column 'nid' in field list is ambiguous
query: SELECT nid,
files_node_data_field_video_file_node_data_field_image_file.field_image_file_fid AS files_node_data_field_video_file_node_data_field_image_file_field_image_file_fid,
files_node_data_field_video_file_node_data_field_image_file.field_image_file_list AS files_node_data_field_video_file_node_data_field_image_file_field_image_file_list,
files_node_data_field_video_file_node_data_field_image_file.field_image_file_data AS files_node_data_field_video_file_node_data_field_image_file_field_image_file_data,
language,
files_node_data_field_video_file_node_data_field_image_file.delta AS files_node_data_field_video_file_node_data_field_image_file_delta,
type,
vid,
node.title AS node_title,
node.language AS node_language,
files_node_data_field_video_file_node_data_field_video_image.field_video_image_fid AS files_node_data_field_video_file_node_data_field_video_image_field_video_image_fid,
files_node_data_field_video_file_node_data_field_video_image.field_video_image_list AS files_node_data_field_video_file_node_data_field_video_image_field_video_image_list,
files_node_data_field_video_file_node_data_field_video_image.field_video_image_data AS files_node_data_field_video_file_node_data_field_video_image_field_video_image_data,
node.created AS node_created
FROM archive_node node
LEFT JOIN archive_content_field_video_file node_data_field_video_file ON node.vid = node_data_field_video_file.vid
LEFT JOIN archive_files files_node_data_field_video_file ON node_data_field_video_file.field_video_file_fid = files_node_data_field_video_file.fid
LEFT JOIN archive_content_field_image_file node_data_field_image_file ON node.vid = node_data_field_image_file.vid
LEFT JOIN archive_files files_node_data_field_image_file ON node_data_field_image_file.field_image_file_fid = files_node_data_field_image_file.fid
LEFT JOIN archive_content_field_image_file files_node_data_field_video_file_node_data_field_image_file ON files_node_data_field_video_file.fid = files_node_data_field_video_file_node_data_field_image_file.field_image_file_fid
LEFT JOIN archive_content_type_video files_node_data_field_video_file_node_data_field_video_image ON files_node_data_field_video_file.fid = files_node_data_field_video_file_node_data_field_video_image.field_video_image_fid
WHERE (node.status <> 0) AND (node.type in ('image'))
ORDER BY node_created DESC
LIMIT 0, 4 in /home/iolonkho/public_html/archive/sites/all/modules/views/includes/view.inc on line 771.
admin вт, 10/25/2011 - 18:10
admin вт, 10/25/2011 - 18:10
admin вт, 10/25/2011 - 18:07
admin вт, 10/25/2011 - 18:06