Map Drupal 7 node and url_alias tables

MapD7NodeUrlAlias.php

<?php

/**
* The alias table entries are prefixed with the actual path
 * /node/nid
*/

function return_node_titles_and_aliases() {
  $results = db_query("
  SELECT
    n.nid, n.title,
    a.source, a.alias
  FROM {node} n
  LEFT JOIN {url_alias} a
    ON CONCAT('node/', nid) = source
  ")->fetchAll();
  foreach ($results as $result) {
    dpm($result);
  }
}