SQL
x
set @user = "King G.A";
use hewiki_p;
select page_title, rev_timestamp 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 rev_actor = 8263
order by rev_timestamp
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.