Untitled query #63805

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

SQL

SELECT * 
FROM categorylinks
LEFT OUTER JOIN revision ON cl_from = rev_page 
RIGHT OUTER JOIN recentchanges ON rev_timestamp = rc_timestamp
WHERE cl_to = "Images_from_Wiki_Loves_Monuments_2018" AND cl_type = "file" AND rev_parent_id = 0 AND NOT rc_bot = 1
# WHERE rc_this_oldid = "501779215"

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