I’m looking for a way to list the page titles/urls that Piwik currently associates with a site.
I know there isn’t anything that ties urls/pages to sites in the ‘log_action’ table. The next best thing I could think of would be selecting distinct values from the ‘log_visit’ table of ‘visit_exit_idaction_url’ and ‘visit_entry_idaction_url’, then matching them up with their urls from the ‘log_action’ table. The problem is there might be rare cases that a page has never been an entry or exit page and therefore would not be listed.
I don’t need any extra data, just a page title/url list of associated pages. If anyone has any advice, or thoughts on my solution, please let me know.