Users contributions in Wikimedia Commons

Fork of User Edits to Files in Commons under Specific Categories by Gnoeee

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

SQL

SELECT r1.rev_timestamp, actor_name, page_title, comment_text, page_id, cl.cl_to
FROM revision_userindex r1
JOIN actor_revision ON actor_id = r1.rev_actor
LEFT JOIN page ON page_id = r1.rev_page
LEFT JOIN comment_revision ON comment_id = r1.rev_comment_id
LEFT JOIN image img ON img.img_name = page.page_title # Join images table
LEFT JOIN categorylinks cl ON cl.cl_from = page.page_id # Join categorylinks table
WHERE actor_name IN ('Gnoeee')
AND r1.rev_timestamp > '20230320183100'
AND r1.rev_timestamp < '20230331183000'
AND cl.cl_to = 'NSS College of Engineering, Palakkad' # Filter by specific category
ORDER BY r1.rev_timestamp desc;

SQL

Checking query status...