WLM Bangladesh 2016

Fork of WLM Bangladesh 2016 by Rkapoor1

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

Wiki loves monuments 2016 in Bangladesh Users and Uploads. 
Last update: Sept. 6, 2016
https://commons.wikimedia.org/wiki/COM:WLMBD2016

SQL

USE commonswiki_p;
SELECT 
 DISTINCT img_user_text AS user,
 gender,
 COUNT(img_user_text) AS uploads
FROM page
JOIN categorylinks
 ON cl_from = page_id
LEFT JOIN image
 ON page_title = img_name
LEFT JOIN
(
SELECT 
 up_value AS gender,
 up_user AS genderuser 
 FROM user_properties
WHERE up_property = "gender"
) AS gendertable 
   ON genderuser = img_user
WHERE cl_to = 'Images_from_Wiki_Loves_Monuments_2016_in_Bangladesh'
GROUP BY img_user_text
;

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