set @list = "המקבץ השבועי/אוקטובר-2/דף משנה2";

set @startdate = "2019-09-29";

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

​