gistfile1.txt

SELECT
  node_field_revision.changed AS node_field_revision_changed,
  node_field_revision.title AS node_field_revision_title,
  max(node_revision.vid) AS maxnode_revisionvid,
  max(node_revision.revision_timestamp) AS maxnode_revisionrevision_timestamp,
  MIN(node_field_revision.vid) AS vid
FROM {node_field_revision} node_field_revision 
INNER JOIN {node_revision} node_revision ON node_field_revision.vid = node_revision.vid 
GROUP BY 
  node_revision.vid, 
  max(node_revision.vid), 
  max(node_revision.revision_timestamp), 
  node_field_revision_changed, 
  node_field_revision_title 
LIMIT 10 
OFFSET 0