SQL
AخA
USE commonswiki_p;
SELECT img_name, img_width*img_height/1000000 AS Mpx, gil_wiki AS usedIn, gil_page_namespace AS usedInNs-- , user_editcount
FROM image
JOIN imagelinks
ON img_name = il_to
AND il_from = 45961050 -- https://commons.wikimedia.org/?curid=45961050
AND img_minor_mime = png
LEFT JOIN globalimagelinks
ON img_name = gil_to;
-- JOIN user
-- ON img_user = user_id;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.