Untitled query #58514

find suspected edits that may have been caused by מיזוג הפניות לערכים מורחבים run from checkty

SQL

select 
	p.page_title, 
    revs.rev_id, 
    'https//he.wikipedia.org/w/index.php?diff=' + cast(revs.rev_id as varchar(20)) as link, 
    revs.rev_timestamp, 
    parent.rev_len - revs.rev_len as removed 
from revision revs
	join revision parent on revs.rev_parent_id = parent.rev_id
	join comment comm on revs.rev_comment_id = comm.comment_id 
	join page p on p.page_id = revs.rev_page
where comm.comment_text like '%מיזוג הפניות לערכים מורחבים%'
	and parent.rev_len > revs.rev_len
	and parent.rev_len - revs.rev_len > 400
order by removed desc

SQL

Checking query status...