cristiroma/drupal-query.sql

Created February 9, 2026 11:44

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/cristiroma/b59f1a73dfead635fec708dc26be4585.js"></script>
Save cristiroma/b59f1a73dfead635fec708dc26be4585 to your computer and use it in GitHub Desktop.

Download ZIP

Drupal extract node URLs using SQL Query

Raw

drupal-query.sql

SELECT CONCAT('https://example.org', b.alias) AS url FROM node a INNER JOIN path_alias b ON CONCAT('/node/', a.nid) = b.path GROUP BY url;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment