Untitled query #87793

SQL

SELECT
    p.page_id,
    p.page_title,
    SUM(pv.view_count) AS total_views
FROM
    categorylinks AS cl
JOIN
    page AS p ON cl.cl_from = p.page_id
JOIN
    pageviews_hourly AS pv ON p.page_title = pv.page_title
WHERE
    cl.cl_to = "Wikipedia_articles_that_are_too_technical"
    AND pv.project = "en.wikipedia"
    AND pv.agent_type = "user"
    AND pv.access_method = "all-access"
    AND pv.timestamp BETWEEN "2020100100" AND "2023103123"  -- Change this to your desired date range
GROUP BY
    p.page_id
ORDER BY
    total_views DESC
LIMIT 50;
SQL

Checking query status...
