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.