Untitled query #85850

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

SQL

select distinct
  p1.page_namespace,
  p1.page_title
from
  categorylinks cl
  left join page p1 on cl.cl_from = p1.page_id
  left join imagelinks il on p1.page_title = il.il_to
  left join page p2 on il.il_from = p2.page_id
  left join recentchanges rc on rc.rc_title = p2.page_title and rc.rc_namespace = p2.page_namespace
where
  cl.cl_to = '所有非自由媒體'
  and cl.cl_type = 'file'
  and p1.page_namespace = 6
  and rc.rc_bot = 0
  and rc.rc_type in (0, 1)
  and 20240827073107 <= rc.rc_timestamp;

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