Untitled query #48676

SQL

set @list = "המקבץ השבועי/יצחק/דף משנה";
set @startdate = "2020-09-20";
set @summer = -3;

#------------------------------------------------

use hewiki_p;
set @newstartdate = date_add(concat(@startdate, " 00:00:00"), interval @summer hour);
set @newstopdate  = date_add(@newstartdate, interval 8 day);
select distinct(concat('* [[{{subst:GENDER:', actor_name, '|משתמש|משתמשת}}:', actor_name, ']]')) from pagelinks join page
on page_title = pl_title
join revision
on rev_page = page_id
join actor
on rev_actor = actor_id
where pl_from in
(select page_id from page
 where page_title = replace(@list, " ", "_")
 and page_namespace = 4)
and page_namespace = 0
and actor_user > 0
and rev_parent_id = 0
and timediff(@newstopdate, rev_timestamp) > 0
and timediff(@newstartdate, rev_timestamp) < 0
order by actor_name;
select distinct(concat('* [[{{subst:GENDER:', actor_name, '|משתמש|משתמשת}}:', actor_name, ']]')) from pagelinks join page
on page_title = pl_title
join revision
on rev_page = page_id
join actor
on rev_actor = actor_id
where pl_from in
(select page_id from page
 where page_title = replace(@list, " ", "_")
 and page_namespace = 4)
and page_namespace = 0
and actor_user > 0
and not exists
(select * from user_groups
 where actor_user = ug_user
 and ug_group = "bot")
and timediff(@newstopdate, rev_timestamp) > 0
and timediff(@newstartdate, rev_timestamp) < 0
and not exists
(select * from revision
where rev_page = page_id
and actor_user > 0
and rev_parent_id = 0
and (substring(rev_timestamp, 1, 4) = "2016" and
     ((substring(rev_timestamp, 5, 5) = "04302" and
       substring(rev_timestamp, 10, 1) in ("1", "2", "3")) or
      (substring(rev_timestamp, 5, 3) = "050" and
       substring(rev_timestamp, 8, 1) in ("1", "2", "3", "4", "5", "6")) or
      (substring(rev_timestamp, 5, 4) = "0507" and
       (substring(rev_timestamp, 9, 1) in ("0", "1") or
        substring(rev_timestamp, 9, 2) = "20")))))
order by actor_name
SQL

Checking query status...
