#mautic #mysql Get most common page hits by specific segment users

top-hit-by-segment-users.sql

select count(page_hits.url) as count, page_hits.url
  from page_hits
    left join leads on page_hits.lead_id = leads.id
    left join lead_lists_leads on leads.id = lead_lists_leads.lead_id
    left join lead_lists on lead_lists.id = lead_lists_leads.leadlist_id
  where lead_lists.id = 31
  group by page_hits.url
  order by count desc
  limit 10;