zhwiki: List unpatrolled new page (use logging)

Fork of zhwiki: List unpatrolled new page by Steven Sun

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

SQL

SELECT rc_timestamp, rc_title, CONCAT("[[", rc_title, "]]"), rc_cur_id
FROM recentchanges
WHERE rc_namespace = 0
# AND rc_patrolled = 0
AND rc_timestamp > 20220623000000
AND rc_timestamp < 20220624000000
AND rc_type = 1
AND rc_cur_id NOT IN (
  SELECT log_page
  FROM logging_logindex
  WHERE log_page = rc_cur_id
  AND logging_logindex.log_type = "patrol"
)

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