قوالب تصفح دوريات رياضية

SQL

 use enwiki_p;
 #
 select distinct *
 from langlinks
 inner join page cat on cat.page_namespace = 14
 inner join page temp on cat.page_namespace = 10
 where ll_from = cat.page_id
 and cat.page_title = like "%seasons"
 and cat.page_title = temp.page_title
 and ll_lang = "ar"
 and temp.page_id not in (select ll_from from langlinks where ll_lang = "ar" and pl_from = ll_from)
 /*and ll_title in (select arwiki_p.page.page_title from arwiki_p.page inner join arwiki_p.categorylinks on arwiki_p.page.page_id = 
                 arwiki_p.categorylinks.cl_from where arwiki_p.categorylinks.cl_to = "جميع_المقالات_اليتيمة"
                 and ll_title = arwiki_p.page.page_title) */
 #group by pl_from 
 #order by count(pl_title) desc
 limit 100;
SQL

Checking query status...
