Commons signatures without built-in translation

Fork of Commons signatures without built-in translation by AntiCompositeNumber

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

SQL

SELECT CONCAT("[[User talk:", user_name, "]]") as `user`, up_value as `signature`, max(rev_timestamp) as `last edit`
FROM user_properties
JOIN `user` ON up_user = user_id
JOIN actor_revision ON up_user = actor_user
JOIN revision_userindex ON rev_actor = actor_id
WHERE
	up_property = "nickname"
    AND up_user IN (SELECT up_user
                    FROM user_properties
                    WHERE up_property = "fancysig" AND up_value = 1)
	AND up_value LIKE "%signature-talk%"
    AND up_value NOT LIKE "%alkpagelinktext%"
GROUP BY up_user
ORDER BY `last edit` DESC

SQL

Checking query status...