CXT edits with source wiki - Quarry

Fork of 'ContentTranslation' tagged articles [enwp] by TheresNoTime

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

Searches en.wp for pages with the 'contenttranslation' tag.
Compared to the forked query, this includes the page namespace and the source wiki of the edit.  (In almost all cases, that should be the same as its language code.)
It also excludes edits made after the (approximate) run-time of the forked query.

SQL

SELECT DISTINCT SUBSTRING_INDEX(SUBSTRING_INDEX(rev_comment, ':',  2), ':', -1) AS 'Source wiki',
	CONCAT('[[{{ns:', page_namespace, '}}:', page_title, ']]') AS 'Page'
FROM revision
JOIN change_tag
	ON ct_rev_id = rev_id
JOIN page
	ON page_id = rev_page
WHERE ct_tag = 'contenttranslation'
	AND rev_timestamp <= 20160727115600;

AخA
 
SELECT DISTINCT SUBSTRING_INDEX(SUBSTRING_INDEX(rev_comment, ':',  2), ':', -1) AS 'Source wiki',    CONCAT('[[{{ns:', page_namespace, '}}:', page_title, ']]') AS 'Page'FROM revisionJOIN change_tag    ON ct_rev_id = rev_idJOIN page    ON page_id = rev_pageWHERE ct_tag = 'contenttranslation'    AND rev_timestamp <= 20160727115600;

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 Stop Query

All SQL code is licensed under CC0 License.

Checking query status...