Missing data in Behaviours and Page Titles

Matomo: 4.15
MySQL version: 8.0.32
PHP version: 8.2.1
Running in Windows 2019


Some urls are not searchable even though they were displayed in the live users
The data exists in the database but can not be found through the UI.
The same queries with an id work as it should with many other ids but won’t for some :

How can this be fixed please ?

Thank you !

Hi @Vincent_Tison
id_action_url_ref is the previous page URL. Use id_action_url instead.

Hi @heurteph-ei !
Thanks for the correction
I had to add an index on id_action_url otherwise the query would timeout.