SQL
AخA
use commonswiki_p;
SELECT
img_timestamp,
img_name IN (SELECT DISTINCT gil_to FROM globalimagelinks),
user.user_name as name,
user_registration
FROM (SELECT
cl_to,
cl_from
FROM categorylinks
WHERE cl_to = "Foreground_cereals" AND cl_type = 'file') cats
INNER JOIN page ON cl_from = page_id
INNER JOIN image ON page_title = img_name
LEFT JOIN oldimage ON image.img_name = oldimage.oi_name AND oldimage.oi_timestamp = (SELECT MIN(o.oi_timestamp) FROM oldimage o WHERE o.oi_name = image.img_name)
LEFT JOIN user ON user.user_id = COALESCE(oldimage.oi_user, image.img_user)
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.