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 , page_namespace, page_is_redirect, cl_to
         from page
         join categorylinks on page_id = cl_from
         join revision on page_id = rev_page
         having
             page_namespace = 0
         and page_is_redirect = 0
         and cl_to = Concat('بوابة_',@portalName,'/مقالات_متعلقة')
         and min(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...