This is a small utility project to fix a problem that occurs when you do not immediately set up path alias patterns for content.

Making a module proved not worth the effort. Scroll down for the SQL query to run.

UPDATE: Let this attempt at a module serve as a testament to multiple problems with modern Drupal.