User talk:MiszaBot/LolSummaries

Query for reference (what the bot produces, ie before manual removal of false positives):

SELECT
  left(log_timestamp,8)
, user_name
, ns_name
, log_title
, log_comment

FROM enwiki_p.logging
JOIN enwiki_p.user ON user_id = log_user
JOIN toolserver.namespace ON dbname = 'enwiki_p' and ns_id = log_namespace
WHERE log_comment REGEXP '[[:<:]](haz|srz)[[:>:]]|[[:<:]](o ?hai|lul|lol)|(kthx|srsly|no ?wai)|(bai|wut)[[:>:]]'
and not log_comment like '%content was:%'
and not log_namespace in (2,3)
AND log_type = 'delete' AND log_action = 'delete'
AND log_timestamp >= '20080101000000'

ORDER BY log_timestamp desc

Running time: several minutes on enwiki_p. Миша 13 19:02, 6 April 2009 (UTC)[reply]