I am building a report outside of Drupal that pulls data from a Drupal 8 database. The report shows titles of different nodes and I want to link those titles to the web page for that content. This is working fine if I use the standard /node/X path, but I would like to use the URL alias. I don't want the url alias of the node itself (which I did find thanks to this Which mysql tables contain the URL Alias path data? post). Our content is related to groups, so I want to use the URL alias that is created as part of the group entity relation.
At first I checked the url_alias table, using this query to look for the node id in the source field, but I didn't find the alias set up for that node :
select u.alias from url_alias u where u.source LIKE '%4806%'
Then I tried to check the group tables. I only find 5 tables starting with group in the MySQL schema, and I didn't find the URL alias for the entity reference in any of them:
Does anyone know where that URL alias from the group relation is stored in the MySQL schema?