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
HenriqueCrang
.
Toggle Highlighting
SQL
SELECT SUBSTR(cl_to, 38) país, UNIX_TIMESTAMP(SUBSTR(img_timestamp, 1, 8)) dia, SUBSTR(img_timestamp, 1, 10) hora, COUNT(*) upload FROM categorylinks INNER JOIN page ON cl_from = page_id INNER JOIN image ON page_title = img_name AND img_timestamp > 20150831000000 WHERE cl_type = 'file' AND cl_to IN (SELECT page_title FROM page WHERE page_namespace = 14 AND page_title IN ('Images_from_Wiki_Loves_Monuments_2015_in_Albania_&_Kosovo','Images_from_Wiki_Loves_Monuments_2015_in_Algeria','Images_from_Wiki_Loves_Monuments_2015_in_Armenia_&_Nagorno-Karabakh','Images_from_Wiki_Loves_Monuments_2015_in_Karabakh','Images_from_Wiki_Loves_Monuments_2015_in_Austria','Images_from_Wiki_Loves_Monuments_2015_in_Azerbaijan','Images_from_Wiki_Loves_Monuments_2015_in_Brazil','Images_from_Wiki_Loves_Monuments_2015_in_Bulgaria','Images_from_Wiki_Loves_Monuments_2015_in_Egypt','Images_from_Wiki_Loves_Monuments_2015_in_Estonia','Images_from_Wiki_Loves_Monuments_2015_in_France','Images_from_Wiki_Loves_Monuments_2015_in_Germany','Images_from_Wiki_Loves_Monuments_2015_in_Iran','Images_from_Wiki_Loves_Monuments_2015_in_Ireland','Images_from_Wiki_Loves_Monuments_2015_in_Israel','Images_from_Wiki_Loves_Monuments_2015_in_Italy','Images_from_Wiki_Loves_Monuments_2015_in_Latvia','Images_from_Wiki_Loves_Monuments_2015_in_Macedonia','Images_from_Wiki_Loves_Monuments_2015_in_Malaysia','Images_from_Wiki_Loves_Monuments_2015_in_Mexico','Images_from_Wiki_Loves_Monuments_2015_in_Nepal','Images_from_Wiki_Loves_Monuments_2015_in_the_Netherlands','Images_from_Wiki_Loves_Monuments_2015_in_Norway','Images_from_Wiki_Loves_Monuments_2015_in_Pakistan','Images_from_Wiki_Loves_Monuments_2015_in_Palestine','Images_from_Wiki_Loves_Monuments_2015_in_Romania','Images_from_Wiki_Loves_Monuments_2015_in_Russia','Images_from_Wiki_Loves_Monuments_2015_in_Slovakia','Images_from_Wiki_Loves_Monuments_2015_in_South_Africa','Images_from_Wiki_Loves_Monuments_2015_in_Spain','Images_from_Wiki_Loves_Monuments_2015_in_Sweden','Images_from_Wiki_Loves_Monuments_2015_in_Thailand','Images_from_Wiki_Loves_Monuments_2015_in_Tunisia','Images_from_Wiki_Loves_Monuments_2015_in_Ukraine') AND page_title NOT LIKE '%\_-\_%' ) GROUP BY país, hora;
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...