Get all #1lib1ref edits from enwiki's recentchanges table

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

Uses case normalization to match all variants of #1lib1ref in rc_comment of edits that appear in the recentchanges table.

USE enwiki_p;
SELECT * FROM recentchanges WHERE rc_type IN (0, 1) AND LOWER(CONVERT(rc_comment USING utf8)) LIKE "%#1lib1ref%";

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.