This query is marked as a draft This query has been published by Mr. Ibrahem.

SQL

x
 
use arwiki_p;
select min(revision.rev_timestamp) as ts,page.page_title,page_namespace,page_id,page_is_redirect
from revision join page on rev_page = page_id
group by
rev_page having  min(revision.rev_timestamp) >= 20191100000000 and min(revision.rev_timestamp) <= 20191231235959
and page_namespace = 0
and page_is_redirect = 0
and page_id in (select cl_from from categorylinks  where cl_to ='بوابة_اليمن/مقالات_متعلقة')
order by ts DESC
limit 0,5;
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.

Checking query status...