DrupalBin

SELECT node.nid AS nid,

   node.title AS node_title,

   node_data_field_pubmed_id.field_pubmed_id_value AS node_data_field_pubmed_id_field_pubmed_id_value,

   node.type AS node_type,

   node.vid A