all sound logo votes

Fork of new-to-commons sound logo voters by AntiCompositeNumber

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

SQL

SELECT rev_id, rev_timestamp, actor_name, comment_text, TIMESTAMPDIFF(DAY, user_registration, NOW()) AS `user_age`, user_editcount
FROM revision_userindex
JOIN actor_revision ON rev_actor = actor_id
JOIN `user` ON actor_user = user_id
JOIN comment_revision ON rev_comment_id = comment_id
WHERE
	rev_page = (
		SELECT page_id
		FROM page
		WHERE page_namespace = 4
        AND page_title = "Sound_Logo_Vote/Votes"
    )
    AND rev_timestamp > 20221206000000
    AND comment_text = "Voting using the vote gadget"
ORDER BY rev_timestamp DESC

SQL

Checking query status...