Image resolutions statistics for WLE Ukraine 2019

SQL

SELECT (case
 when ( (I.img_width*I.img_height) >= 30000000) then '_28-inf Mpx'
 when ( (I.img_width*I.img_height) >= 24000000 AND (I.img_width*I.img_height) < 28000000) then '_24 - 28 Mpx'
 when ( (I.img_width*I.img_height) >= 20000000 AND (I.img_width*I.img_height) < 24000000) then '_20 - 24 Mpx'
 when ( (I.img_width*I.img_height) >= 18000000 AND (I.img_width*I.img_height) < 20000000) then '_18 - 20 Mpx'
 when ( (I.img_width*I.img_height) >= 16000000 AND (I.img_width*I.img_height) < 18000000) then '_16 - 18 Mpx'
 when ( (I.img_width*I.img_height) >= 14000000 AND (I.img_width*I.img_height) < 16000000) then '_14 - 16 Mpx'
 when ( (I.img_width*I.img_height) >= 12000000 AND (I.img_width*I.img_height) < 14000000) then '_12 - 14 Mpx'
 when ( (I.img_width*I.img_height) >= 10000000 AND (I.img_width*I.img_height) < 12000000) then '_10 - 12 Mpx'
 when ( (I.img_width*I.img_height) >=  9000000 AND (I.img_width*I.img_height) < 10000000) then '9 - 10 Mpx'
 when ( (I.img_width*I.img_height) >=  8000000 AND (I.img_width*I.img_height) <  9000000) then '8 - 9 Mpx'
 when ( (I.img_width*I.img_height) >=  7000000 AND (I.img_width*I.img_height) <  8000000) then '7 - 8 Mpx'
 when ( (I.img_width*I.img_height) >=  6000000 AND (I.img_width*I.img_height) <  7000000) then '6 - 7 Mpx'
 when ( (I.img_width*I.img_height) >=  5000000 AND (I.img_width*I.img_height) <  6000000) then '5 - 6 Mpx'
 when ( (I.img_width*I.img_height) >=  4000000 AND (I.img_width*I.img_height) <  5000000) then '4 - 5 Mpx'
 when ( (I.img_width*I.img_height) >=  3000000 AND (I.img_width*I.img_height) <  4000000) then '3 - 4 Mpx'
 when ( (I.img_width*I.img_height) >=  2000000 AND (I.img_width*I.img_height) <  3000000) then '2 - 3 Mpx'
 when ( (I.img_width*I.img_height) >=  1000000 AND (I.img_width*I.img_height) <  2000000) then '1 - 2 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 - 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"
GROUP BY image_group
SQL

Checking query status...
