SQL to extract views for a URL?

I am trying to take a 3.14 Matomo database and extract visits of a URL, via SQL.

I’ve looked at the SQL triggered by an API call but nowhere does it seem to reference the URL.

Our API calls are not responding.