set @user = "King G.A";

use hewiki_p;

select replace(page_title, "_", " ") as "ערך", rev_timestamp as "תאריך" from page as c join revision

on page_id = rev_page

where page_title in

(select page_title from page as a join categorylinks

 on cl_from = a.page_id

 where cl_to = "ויקיפדיה:_ערכים_שמתקיים_לגביהם_דיון_חשיבות_אנציקלופדית")

and rev_actor in

(select actor_id from actor

 where actor_name = @user)

and page_namespace = 1

and datediff(now(), rev_timestamp) <= 8

order by rev_timestamp desc

​