Editing Eurovision Wiki:Village pump (technical) (section)

== Searching edit summaries ==

Is there a way to search for edit summaries (e.g., all edit summaries in the mainspace during the last month)?  I'd like to have a list of diffs in which the edit summary mentions [[WP:ONUS]] (the shortcut). [[User:WhatamIdoing|WhatamIdoing]] ([[User talk:WhatamIdoing|talk]]) 03:15, 10 March 2026 (UTC)
:No easy or fast way.  [[quarry:query/102943]].  A [[quarry:query/102942|similar search]] in all namespaces is fairly badly polluted by instances of "REVISIONUSER". —[[User:Cryptic|Cryptic]] 03:35, 10 March 2026 (UTC)
::Maybe <code>REPLACE(comment_text, <nowiki>'REVISIONUSER', '') LIKE '%ONUS%'</nowiki></code>. [[User:Legoktm|Legoktm]] ([[User talk:Legoktm|talk]]) 01:47, 11 March 2026 (UTC)
:::comment_text RLIKE '\\bONUS\\b' would've done it, but the query took close to ten minutes the first time - the copy on Quarry only seems fast because it was cached - so it didn't seem worth running again. —[[User:Cryptic|Cryptic]] 02:11, 11 March 2026 (UTC)
::::If you're into command-line stuff, there is a denormalized dump of every edit, broken down by month.  See [[:wikitech:Data Platform/Data Lake/Edits/MediaWiki history]].  It's not trivial to get your head around the data organization, and you need a cloud account to access, but it's good for things like this.  I ran <code>bzgrep ONUS 2026-02.enwiki.2026-0*</code> which took a little under 5 minutes and found 1169 lines.  If you want, I could email you a copy. [[User:RoySmith|RoySmith]] [[User Talk:RoySmith|(talk)]] 12:05, 11 March 2026 (UTC)
:::::If "a copy" means a human-readable text file, then I'd be very happy to have that in e-mail. [[User:WhatamIdoing|WhatamIdoing]] ([[User talk:WhatamIdoing|talk]]) 04:36, 14 March 2026 (UTC)
::::::Thanks.  In case anyone's curious, after removing false positives (mostly REVISI<u>ONUS</u>ER, but also words like ''bonus'') and discussions where we are talking about [[WP:ONUS]] but not invoking it, there were ~353 uses left (during the first two months of this year). [[User:WhatamIdoing|WhatamIdoing]] ([[User talk:WhatamIdoing|talk]]) 22:37, 15 March 2026 (UTC)