SQL
AخA
SELECT null as rc_id,
rev.rev_timestamp as rc_timestamp,
rev.rev_user AS rc_user,
rev.rev_user_text AS rc_user_text,
page.page_namespace AS rc_namespace,
page.page_title AS rc_title,
rev.rev_comment AS rc_comment,
rev.rev_minor_edit AS rc_minor,
null AS rc_bot,
(CASE WHEN rev.rev_parent_id = 0
THEN 1
ELSE 0) AS rc_new,
rev.rev_page AS rc_cur_id,
rev.rev_id AS rc_this_oldid,
rev.rev_parent_id AS rc_last_oldid,
null AS rc_type,
null AS rc_source,
null AS rc_patrolled,
null AS rc_ip,
prev_rev.rev_len AS rc_old_len,
rev.rev_len AS rc_new_len,
rev.rev_deleted AS rc_deleted,
null AS rc_logid,
null AS rc_log_type,
null AS rc_log_action,
null AS rc_params
FROM svwiki_p.revision AS rev
JOIN svwiki_p.page
ON page.page_id = rev.rev_page
JOIN svwiki_p.revision AS prev_rev
ON prev_rev.rev_id = rev.rev_parent_id
WHERE rev.rev_timestamp > DATE_SUB(UTC_TIMESTAMP(), INTERVAL 90 DAY)
AND rev.rev_comment REGEXP '(^|[[:blank:]]|\\.|\\!|\\/)[##][[:alnum:]]+[[:>:]]'
ORDER BY rev.rev_timestamp DESC
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.