Edit summary search - Quarry

Fork of Edit summary search by Tamzin

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

Fork for standing queries

SQL

SELECT actor_name AS user, count(actor_name) AS hits
FROM recentchanges
    INNER JOIN comment on rc_id = comment_id
    LEFT JOIN actor on rc_actor = actor_id
WHERE comment_text LIKE "%Fixed temporal range %"
GROUP BY actor_name
ORDER BY 2 DESC
LIMIT 1

AخA
 
SELECT actor_name AS user, count(actor_name) AS hitsFROM recentchanges    INNER JOIN comment on rc_id = comment_id    LEFT JOIN actor on rc_actor = actor_idWHERE comment_text LIKE "%Fixed temporal range %"GROUP BY actor_nameORDER BY 2 DESCLIMIT 1

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.

Checking query status...