This query is marked as a draft This query has been published by YoavR.

SQL

x
 
set @list = "המקבץ השבועי/שנהיה לראש ולא לזנב/דף משנה";
set @startdate = "2020-09-13";
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
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.

Checking query status...