Is there a SQL means of listing all pages linked to active events? I need the content_id of the event and the page url_name_ to build an appropriate invitation email hyperlink.
I can see all active events with the following: SELECT * FROM sf_events WHERE status = 2
I can see the various pages here: SELECT * FROM sf_page_node
I can't seem to find the relationship between the two tables. Can anyone please help? SQL would be the best solution for me. However, I'm open to an API approach.