Untitled query #87906

SQL

SELECT 
    p.page_title,
    p.page_namespace,
    COALESCE(pv.views, 0) as pageviews
FROM page p
LEFT JOIN pagelinks pl ON pl.pl_from = p.page_id 
    AND pl.pl_namespace = 0 
    AND pl.pl_title = 'Wikidata'
LEFT JOIN (
    SELECT 
        page_title,
        SUM(view_count) as views
    FROM pageviews_articles
    WHERE project = 'en.wikipedia'
    AND timestamp >= DATE_SUB(NOW(), INTERVAL 30 DAY)
    GROUP BY page_title
) pv ON pv.page_title = p.page_title
WHERE p.page_namespace = 0  -- Main namespace only
AND pl.pl_title IS NULL  -- No link to Wikidata
AND p.page_is_redirect = 0  -- Exclude redirects
ORDER BY pageviews DESC
LIMIT 1000;
SQL

Checking query status...
