SQL
x
set @list = "המקבץ השבועי/דצמבר/דף משנה2";
set @startdate = "2017-12-10";
set @summer = -2;
#------------------------------------------------
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(page_title) from pagelinks join page
on page_title = pl_title
join revision
on rev_page = page_id
where pl_from in
(select page_id from page
where page_title = replace(@list, " ", "_")
and page_namespace = 4)
and page_namespace = 0
and timediff(@newstopdate, rev_timestamp) > 0
and timediff(@newstartdate, rev_timestamp) < 0
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.