Pages transcluding one page but not another

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

SQL

USE enwiktionary_p;
SELECT
  rev_page   AS page_id,
  revisions,
  editors,
  timestamp,
  (SELECT rev_len FROM test LIMIT 1)
FROM (
  SELECT
    rev_page,
    MAX(rev_timestamp) AS timestamp,
    COUNT(*) AS revisions,
    COUNT(DISTINCT rev_actor) AS editors
  FROM revision
  GROUP BY rev_page
  ORDER BY rev_timestamp
) test
JOIN page on rev_page = page_id
limit 10;

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...