ru artists not in enWP

SQL

USE ruwiki_p;
SELECT page_title, page_len, rd_title, COUNT(*) as edits
FROM page
JOIN templatelinks t1 ON t1.tl_from = page_id
and t1.tl_namespace = 10 AND t1.tl_title in ("Музыкант", "Музыкальный_коллектив")
join revision ON rev_page = page_id
JOIN redirect ON rev_page = rd_from
WHERE page_namespace = 0 AND page_is_redirect = 0
AND page_id not in (select ll_from from langlinks where ll_lang="en")
GROUP BY page_title
HAVING COUNT(*) > 40;
/*old version
FROM page
JOIN templatelinks t1 ON t1.tl_from = page_id
WHERE page_is_redirect = 0 and page_namespace = 0
and t1.tl_namespace = 10 AND t1.tl_title in ("Музыкант", "Музыкальный_коллектив")
AND page_id not in (select ll_from from langlinks where ll_lang="en")
group BY page_title
ORDER BY page_len desc
*/
SQL

Checking query status...
