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

Fork of Get all #1lib1ref edits from enwiki's recentchanges table by EpochFail

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

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

SQL

USE enwiki_p;
SELECT * FROM recentchanges WHERE rc_type IN (0, 1) AND LOWER(CONVERT(rc_comment USING utf8)) LIKE "%1lib1ref%" AND LOWER(CONVERT(rc_comment USING utf8))NOT  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.

SQL

Checking query status...