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
Mohamed Ouda
.
Toggle Highlighting
SQL
use commonswiki_p; SELECT img_user_text AS uploader, COUNT(page_title) AS pictures FROM image, page, categorylinks WHERE page.page_id=categorylinks.cl_from AND image.img_name = page.page_title AND .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_without_categories" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_an_unknown_country" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Algeria" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Angola" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Benin" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Botswana" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Burkina_Faso" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Burundi" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Cameroon" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Cape_Verde" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_the_Central_African_Republic" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Chad" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_the_Comoros" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_the_Democratic_Republic_of_the_Congo" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_the_Republic_of_the_Congo" OR .categorylinks.cl_to = ":Images_from_Wiki_Loves_Africa_2017_in_Côte_d'Ivoire" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_the_Comoros" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_the_Comoros" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Burundi" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_the_Comoros" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_the_Comoros" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_the_Comoros" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Namibia" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Niger" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Nigeria" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Rwanda" OR .categorylinks.cl_to = "Images from Wiki Loves Africa 2017 in Senegal" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Sierra_Leone" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Somalia" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_South_Africa" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_South_Sudan" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Sudan" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Swaziland" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Tanzania" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Togo" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Tunisia" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Uganda" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Zambia" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Zimbabwe" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Mozambique" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Morocco" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Mauritius" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Mauritania" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Mali" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Mali" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Mali" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Malawi" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Madagascar" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Madagascar" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Libya" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Liberia" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Kenya" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Guinea-Bissau" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Guinea" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Guinea" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Guinea" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Ghana" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Gambia" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Ethiopia" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Equatorial_Guinea" OR .categorylinks.cl_to = "Images_from_Wiki_Loves_Africa_2017_in_Equatorial_Egypt" GROUP BY uploader ORDER BY pictures DESC;
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...