Untitled query #87647

SQL

SELECT
    eng.page_title AS en_title,
    eng.page_views AS views
FROM
    enwiki.page AS eng
JOIN
    (SELECT page_id, SUM(view_count) AS page_views
     FROM enwiki.pageviews
     WHERE timestamp >= DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 30 DAY), '%Y%m%d%H%i')
     GROUP BY page_id
     ORDER BY page_views DESC
     LIMIT 100) AS top_views ON eng.page_id = top_views.page_id
LEFT JOIN
    arwiki.page AS ar ON ar.page_title = eng.page_title AND ar.page_namespace = 0
WHERE
    eng.page_namespace = 0
    AND ar.page_id IS NULL
ORDER BY
    views DESC
LIMIT 100;
SQL

Checking query status...
