Daily Uploads @ WLE 2015

SQL

use commonswiki_p;

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 < 20150801000000
 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_Earth_2015_in_Algeria','Images_from_Wiki_Loves_Earth_2015_in_Andorra_&_Catalan_areas','Images_from_Wiki_Loves_Earth_2015_in_Austria','Images_from_Wiki_Loves_Earth_2015_in_Azerbaijan','Images_from_Wiki_Loves_Earth_2015_in_Brazil','Images_from_Wiki_Loves_Earth_2015_in_Estonia','Images_from_Wiki_Loves_Earth_2015_in_France','Images_from_Wiki_Loves_Earth_2015_in_Germany','Images_from_Wiki_Loves_Earth_2015_in_Iraq','Images_from_Wiki_Loves_Earth_2015_in_Lebanon','Images_from_Wiki_Loves_Earth_2015_in_Macedonia','Images_from_Wiki_Loves_Earth_2015_in_Morocco','Images_from_Wiki_Loves_Earth_2015_in_Nepal','Images_from_Wiki_Loves_Earth_2015_in_Pakistan','Images_from_Wiki_Loves_Earth_2015_in_Palestine','Images_from_Wiki_Loves_Earth_2015_in_Poland','Images_from_Wiki_Loves_Earth_2015_in_Portugal','Images_from_Wiki_Loves_Earth_2015_in_Russia','Images_from_Wiki_Loves_Earth_2015_in_Spain','Images_from_Wiki_Loves_Earth_2015_in_Switzerland','Images_from_Wiki_Loves_Earth_2015_in_Syria','Images_from_Wiki_Loves_Earth_2015_in_Thailand','Images_from_Wiki_Loves_Earth_2015_in_Tunisia','Images_from_Wiki_Loves_Earth_2015_in_Ukraine','Images_from_Wiki_Loves_Earth_2015_in_Uruguay','Images_from_Wiki_Loves_Earth_2015_in_Serbia','Images_from_Wiki_Loves_Earth_2015_in_Hungary','Images_from_Wiki_Loves_Earth_2015_in_Australia','Images_from_Wiki_Loves_Earth_2015_in_Jordan') AND page_title NOT LIKE '%\_-\_%'

)
 GROUP BY país, hora
SQL

Checking query status...
