Untitled query #76674

This query is marked as a draft This query has been published by Jean-Frédéric.

SQL

SELECT
 img_name,
 img_actor,
 actor_name,
 SUBSTR(MD5(img_name), 1, 2),
 img_width,
 img_height,
 (img_width * img_height) pixels,
 img_size,
 img_timestamp
 FROM categorylinks
 INNER JOIN page ON cl_from = page_id
 INNER JOIN image ON page_title = img_name
 INNER JOIN actor ON actor.actor_id = image.img_actor
 WHERE cl_to = 'Images_from_Wiki_Loves_Monuments_2023_in_India' AND cl_type = 'file' AND img_major_mime = 'image' AND actor_name = 'Vis M'
 ORDER BY pixels DESC
 LIMIT 201

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...