Size of the 5% tiniest image from WLM 2016 in France

Fork of File size stats for Wiki Loves Monuments 2016 in France by Ash Crow

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

SQL

USE commonswiki_p;

SET @images_count = (SELECT COUNT(*)
FROM image, page, categorylinks
WHERE page.page_id=categorylinks.cl_from
    AND image.img_name = page.page_title
    AND categorylinks.cl_to = 'Images_from_Wiki_Loves_Monuments_2016_in_France'
);

#SET @percent_5 = (@images_count * 0.05);

PREPARE STMT FROM 'SELECT *
FROM image, page, categorylinks
WHERE page.page_id=categorylinks.cl_from
    AND image.img_name = page.page_title
    AND categorylinks.cl_to = 'Images_from_Wiki_Loves_Monuments_2016_in_France'
ORDER BY (image.img_width * image.img_height) ASC
LIMIT ?, 1
;';
EXECUTE STMT USING (@images_count * 0.05);

SQL

Checking query status...