Image resolutions statistics for WLE Ukraine 2019

SQL

SELECT (case
 when (I.img_width*I.img_height >= 8000000) then '>= 8 Mpx'
 when (I.img_width*I.img_height >= 6000000 AND I.img_width*I.img_height < 8000000) then '6 - 8 Mpx'
 when (I.img_width*I.img_height <  6000000) then '< 6 Mpx'
 end) AS image_group, COUNT(1) AS images
FROM commonswiki_p.page P
 JOIN commonswiki_p.categorylinks CL ON CL.cl_from = P.page_id
 JOIN commonswiki_p.image I ON I.img_name = P.page_title
WHERE P.page_namespace = 6
 AND CL.cl_to = "Images_from_Wiki_Loves_Earth_2019_in_Ukraine"

SQL

Checking query status...