Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Stefan2
.
Toggle Highlighting
SQL
USE commonswiki_p; SELECT img_name AS Name, img_timestamp AS Uploaddate, 'Not deleted' AS DeletionStatus, '' AS DeletionDate, '' AS DeletionReason FROM image WHERE img_timestamp > 20160301000000 AND img_timestamp < 20160301240000 AND img_description = 'Cross-wiki upload from pt.wikipedia.org' UNION ALL SELECT oi_name AS Name, oi_timestamp AS Uploaddate, 'Overwritten' AS DeletionStatus, '' AS DeletionDate, '' AS DeletionReason FROM oldimage WHERE oi_timestamp > 20160301000000 AND oi_timestamp < 20160301240000 AND oi_description = 'Cross-wiki upload from pt.wikipedia.org' UNION ALL SELECT fa_name AS Name, fa_timestamp AS Uploaddate, 'Deleted' AS DeletionStatus, fa_deleted_timestamp AS DeletionDate, fa_deleted_reason AS DeletionReason FROM filearchive WHERE fa_timestamp > 20160301000000 AND fa_timestamp < 20160301240000 AND fa_description = 'Cross-wiki upload from pt.wikipedia.org'
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
.
Checking query status...
