Untitled query #86831

SQL

-- change the following values per your needs:
set @pattern = '/* בקשת הרשאות */';  -- string to look for in edit comment
set @lookback_days = 300; -- days in the past to start searching from. to search "all history" use ridiculously large value - e.g. 40000 which is more than 100 years
set @namespace = 4; -- namespace number. to search all namespaces set next param, @all_namespaces to 1 - in this case, this variable is ignored
    				-- to search on more than one namespace but less then all, write a more sophisticated query.
set @all_namespaces = 0;

-- do not change the code below, unless you know what you are doing
set @first_date = now() - interval @lookback_days day;
set @first_timestamp = date_format(@first_date, '%Y%m%d%h%i%s');
declare @one int = 1

select concat('[[', replace(p.page_title, '_', ' '), ']]') as 'ערך', 
	Date(r.rev_timestamp) as 'תאריך',
    a.actor_name as 'עורך',
    @one *  r.rev_len - (select r2.rev_len from revision r2 where r2.rev_id = r.rev_parent_id) as 'גודל',
	concat('[[Special:diff/', r.rev_id, ']]') as 'הבדל', 
    if (exists(select 1 from change_tag ct where ct.ct_rev_id = r.rev_id and ct.ct_tag_id in (241, 234)), 'כן', 'לא') as 'שוחזרה',
    c.comment_text as 'תקציר'
from revision r 
join page p on r.rev_page = p.page_id
join actor a on r.rev_actor = a.actor_id
join comment c on r.rev_comment_id = c.comment_id

where (@all_namespaces = 1 or p.page_namespace = @namespace)
		and r.rev_timestamp > @first_timestamp
 		and instr(c.comment_text, @pattern) > 0
        and not exists(select 1 from logging where log_page = p.page_id and log_timestamp = r.rev_timestamp)
order by r.rev_timestamp desc
SQL

Checking query status...
