Image resolutions statistics for WLE Ukraine 2019

SQL

SELECT (case
 when (I.img_width*I.img_height >= 6000000) then '>= 6 Mpx'
 when (I.img_width*I.img_height >= 5500000 AND I.img_width*I.img_height < 6000000) then '5.5 - 6 Mpx'
 when (I.img_width*I.img_height >= 5000000 AND I.img_width*I.img_height < 5500000) then '5 - 5.5 Mpx'
 when (I.img_width*I.img_height >= 4500000 AND I.img_width*I.img_height < 5000000) then '4.5 - 5 Mpx'
 when (I.img_width*I.img_height >= 4000000 AND I.img_width*I.img_height < 4500000) then '4 - 4.5 Mpx'
 when (I.img_width*I.img_height >= 3500000 AND I.img_width*I.img_height < 4000000) then '3.5 - 4 Mpx'
 when (I.img_width*I.img_height >= 3000000 AND I.img_width*I.img_height < 3500000) then '3 - 3.5 Mpx'
 when (I.img_width*I.img_height >= 2500000 AND I.img_width*I.img_height < 3000000) then '2.5 - 3 Mpx'
 when (I.img_width*I.img_height >= 2000000 AND I.img_width*I.img_height < 2500000) then '2 - 2.5 Mpx'
 when (I.img_width*I.img_height >= 1500000 AND I.img_width*I.img_height < 2000000) then '1.5 - 2 Mpx'
 when (I.img_width*I.img_height >= 1000000 AND I.img_width*I.img_height < 1500000) then '1 - 1.5 Mpx'
 when (I.img_width*I.img_height >=  500000 AND I.img_width*I.img_height < 1000000) then '0.5 - 1 Mpx'
 when (I.img_width*I.img_height <   500000) then '< 0.5 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...
