Untitled query #72491

This query is marked as a draft This query has been published by PTiwary (WMF).

SQL

-- Get all the text of all the revision for a page. page_id = 73328122
USE enwiki;
SELECT * FROM text t
                INNER JOIN 
                (SELECT SUBSTRING(content_address, 4, 100) content_addr FROM content c 
                      INNER JOIN
                      (SELECT slot_content_id FROM slots s 
                          INNER JOIN revision r ON s.slot_revision_id = r.rev_id
                          WHERE r.rev_page = 73328122) sr ON sr.slot_content_id = c.content_id) ca ON ca.content_addr = t.old_id;

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.

SQL

Checking query status...