(An Untitled Masterwork)
ActivePublic
Actions

Authored by Addshore on Sep 15 2021, 8:25 PM.

Tags

None

Referenced Files

	F34644256: raw-paste-data.txt
	Sep 15 2021, 8:25 PM

Subscribers

None

	CREATE TABLE addshore.wikidata_revision_en_terms as
	SELECT page_id, page_title, revision_id, get_json_object(revision_text, '$.labels.en.value') AS en_label, snapshot
	FROM wmf.mediawiki_wikitext_history
	WHERE snapshot = "2021-07"
	AND wiki_db = "wikidatawiki"
	AND page_namespace = 0

(An Untitled Masterwork)ActivePublicActions