An SQL query to URL to all published web pages (nodes) in a Drupal installation from url_alias

drupal-8-generate-site-urls.sql

select concat('http://your.website.url/', c.langcode, c.alias) url from node a 
	inner join node_field_data b on a.nid = b.nid 
	inner join url_alias c on CONCAT('/node/', a.nid) = c.source AND c.langcode = 'en'
	where b.status = 1 group by a.nid

UNION
select concat('http://your.website.url/', c.langcode, c.alias) url from node a 
	inner join node_field_data b on a.nid = b.nid 
	inner join url_alias c on CONCAT('/node/', a.nid) = c.source AND c.langcode = 'fr'
	where b.status = 1 group by a.nid

UNION
select concat('http://your.website.url/', c.langcode, c.alias) url from node a 
	inner join node_field_data b on a.nid = b.nid 
	inner join url_alias c on CONCAT('/node/', a.nid) = c.source AND c.langcode = 'es'
	where b.status = 1 group by a.nid

ORDER BY url;