SQL
AخA
use eswiki_p;
select rc_id, rc_timestamp, rc_user, rc_user_text, rc_namespace, rc_title
, abs(rc_old_len - rc_new_len) size, rc_comment, rc_this_oldid, :desafio as desafio
from eswiki_p.recentchanges
where rc_id > 0 and
rc_namespace in (0, 104) and
LOWER(CONVERT(rc_comment USING utf8)) like '%mistral%' and
-- rc_timestamp between :max and :end and
rc_user > 5 and
rc_new = 0 and
rc_bot = 0
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.