SELECT node.nid AS nid,
   node.title AS node_title,
   node_revisions.body AS node_revisions_body,
   node_revisions.format AS node_revisions_format,
   files_node_data_field_pimage.filepath AS files_node_data_field_pimage_filepath,
   node_data_field_docs.field_docs_fid AS node_data_field_docs_field_docs_fid,
   node_data_field_docs.field_docs_list AS node_data_field_docs_field_docs_list,
   node_data_field_docs.field_docs_data AS node_data_field_docs_field_docs_data,
   node.type AS node_type,
   node.vid AS node_vid,
   node_data_field_pdf.field_pdf_fid AS node_data_field_pdf_field_pdf_fid,
   node_data_field_pdf.field_pdf_list AS node_data_field_pdf_field_pdf_list,
   node_data_field_pdf.field_pdf_data AS node_data_field_pdf_field_pdf_data,
   files_node_data_field_docs.filepath AS files_node_data_field_docs_filepath,
   DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL 3600 SECOND), '%Y%m%d%H') AS node_created_hour
 FROM z1_node node
 LEFT JOIN z1_content_field_pimage node_data_field_pimage ON node.vid = node_data_field_pimage.vid
 LEFT JOIN z1_files files_node_data_field_pimage ON node_data_field_pimage.field_pimage_fid = files_node_data_field_pimage.fid
 LEFT JOIN z1_content_type_pressrelease node_data_field_docs ON node.vid = node_data_field_docs.vid
 LEFT JOIN z1_files files_node_data_field_docs ON node_data_field_docs.field_docs_fid = files_node_data_field_docs.fid
 LEFT JOIN z1_content_type_pressrelease node_data_field_pdf ON node.vid = node_data_field_pdf.vid
 LEFT JOIN z1_files files_node_data_field_pdf ON node_data_field_pdf.field_pdf_fid = files_node_data_field_pdf.fid
 LEFT JOIN z1_node_revisions node_revisions ON node.vid = node_revisions.vid
 WHERE (node.status <> 0) AND (node.type in ('news')) AND (node.title = 'Vi har datorer!')
   ORDER BY node_created_hour DESC