قوالب تصفح بها اكبر عدد من المقالات العربية

SQL

USE enwiki_p;

SELECT DISTINCT 
    p2.page_title, 
    COUNT(pagelinks.pl_title) AS link_count
FROM 
    pagelinks
INNER JOIN page AS p1 ON p1.page_title = pagelinks.pl_title
INNER JOIN page AS p2 ON p2.page_id = pagelinks.pl_from
INNER JOIN langlinks ON langlinks.ll_from = p1.page_id
WHERE 
    pagelinks.pl_from_namespace = 10
    AND p1.page_namespace = 0
    AND pagelinks.pl_namespace = 0
    AND langlinks.ll_lang = 'ar'
    AND NOT EXISTS (
        SELECT 1
        FROM langlinks
        WHERE ll_lang = 'ar' AND ll_from = pagelinks.pl_from
    )
    AND p2.page_id IN (
        SELECT tl_from
        FROM templatelinks
        WHERE tl_title = 'Navbox'
    )
    AND p2.page_id IN (
        SELECT cl_from
        FROM categorylinks
        WHERE cl_to = 'Video_game_navigational_boxes_by_company'
    )
GROUP BY 
    p2.page_title
ORDER BY 
    link_count DESC
LIMIT 30;

SQL

Checking query status...