How to select piwik_log_link_visit_action.idaction_name and piwik_log_link_visit_action.idaction_url which both points to log_visit_action.idaction

General questions
1

how to select piwik_log_link_visit_action.idaction_name and piwik_log_link_visit_action.idaction_url which both point to log_visit_action.idaction

2

Hi,

In case you are trying to export data from Piwik to create your own reports, I really recommend you to use the API instead of parsing the Database:
https://demo.piwik.org/index.php?module=API&action=listAllAPI&idSite=3&period=day&date=yesterday