Untitled query #13590

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

SQL

USE commonswiki_p;

DROP TABLE temp_fc1 IF EXISTS;
CREATE TEMPORARY TABLE temp_fc1 
  (rev_user_text varbinary(255), rev_page int(8), rev_timestamp varbinary(14))
  SELECT
  rev_user_text, rev_page, rev_timestamp
  FROM
  revisions
  WHERE
  rev_page IN
  	(
      SELECT cl_from FROM categorylinks
      WHERE cl_to='Featured_pictures_on_Wikimedia_Commons'
    )
;
SELECT COUNT(*) FROM temp_fc1;

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