Articles per day

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

SQL

  SELECT
      page.page_title AS Title,
      concat("https://ru.wikipedia.org/wiki/", page.page_title) as URL
  FROM page, revision
  WHERE
      revision.rev_timestamp > 20211031000000  AND -- > 31.10.2021
      revision.rev_timestamp < 20211101000000  AND -- < 01.11.2021
      page.page_namespace = 0 AND  page.page_is_redirect = 0 AND
      revision.rev_page = page.page_id AND revision.rev_parent_id = 0
  ;

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