This query is marked as a draft This query has been published by Tohaomg.

SQL

AخA
 
SELECT lang, COUNT(1) as articles_count
FROM
(
    SELECT R.rev_id, 
        replace(replace(replace(replace(
            substring(replace(replace(C.comment_text, "«", ""), '"', ''), 70, 10), 
        ":Special", ""), ":Specia", ""), ":Spe", ""), ":", "") AS lang
    FROM ukwiki_p.revision R
    JOIN ukwiki_p.change_tag T ON R.rev_id=T.ct_rev_id
    JOIN ukwiki_p.comment C ON R.rev_comment_id=C.comment_id
    WHERE R.rev_parent_id=0
     AND (T.ct_tag_id=1 OR T.ct_tag_id=125)
    GROUP BY R.rev_id
) article_creations
GROUP BY lang
ORDER BY articles_count DESC
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...