Drupal 7 DBTNG JOIN example

gistfile1.aw

<?php
// Use a JOIN there are aliases.
$select = db_select('url_alias', 'a');
$select->join('node', 'n', 'SUBSTR(a.source, 6) = n.nid');
$pairs = $select->fields('a', array('source', 'alias'))
  ->orderBy('changed', 'DESC')
  ->condition('changed', $updated, '>=')
  ->execute()
  ->fetchAllKeyed();