Get list of url aliases which ends with -0 -1 -2 or -3 #drupal7

duplicate_aliases.php

<?php
  $items = array();
      $query = db_select('node', 'n');
      $query->join('url_alias', 'ua', "ua.source = CONCAT('node/', n.nid)");
      $query->fields('ua', array('source'))
      ->fields('n', array('title'))
      ->condition(
        db_or()
          ->condition('ua.alias', '%' . db_like('-0'), 'LIKE')
          ->condition('ua.alias', '%' . db_like('-1'), 'LIKE')
          ->condition('ua.alias', '%' . db_like('-2'), 'LIKE')
          ->condition('ua.alias', '%' . db_like('-3'), 'LIKE')
        )
      ->condition('n.type', 'article');
      $nodes = $query->execute()->fetchAll();
      foreach ($nodes as $node) {
        $items[] = '<li>'.l( $node->title, $node->source ).'</li>';
      }

    //dsm($items);
    $output = '<ul>'.implode('', $items).'</ul>';
    print $output;
?>