Untitled query #48646

SQL

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

Checking query status...
