Untitled query #27619

This query is marked as a draft This query has been published by وهراني.

المقالات الجديدة مرتبطة ببوابة حسب السنة

SQL

SET @portalName = 'طب', @year=2018;

select page.page_title , page_id 
         from page
         join categorylinks on page_id = cl_from
         -- join revision on page_id = rev_page
         where
             page_namespace = 0
         and page_is_redirect = 0
         and cl_to = Concat('بوابة_',@portalName,'/مقالات_متعلقة')
         and page_id in (select rev_page from revision  where revision.rev_timestamp div 1e10 = @year )
         order by page_title

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...