Which languages are the most translated from, in Ukrainian Wikipedia

SQL

SELECT lang, COUNT(1) as articles_count, GROUP_CONCAT(page_title) as page_titles, GROUP_CONCAT(comment_text) as comment_texts
FROM
(
	SELECT R.rev_id, P.page_title, C.comment_text, substring(C.comment_text, 72, 2) 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
JOIN ukwiki_p.page P ON R.rev_page=P.page_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
WHERE lang="u:" OR lang="cs"
GROUP BY lang
ORDER BY articles_count DESC

SQL

Checking query status...