أكثر القوالب استخدام

SQL

/*USE arwiki_p;

SELECT tl_title,
    count(tl_title)
FROM templatelinks
LEFT JOIN page ON page_namespace = 10
    AND page_title = tl_title
WHERE tl_from_namespace = 0
    AND tl_namespace = 10
    AND not EXISTS (
        SELECT NULL
        FROM categorylinks
        WHERE cl_from = page_id
            AND cl_to = 'قوالب_بذور'
        )
GROUP BY tl_title
ORDER BY count(tl_title) DESC limit 500
;*/

USE arwiki_p;

SELECT tl_title,
    count(tl_title)
FROM templatelinks
LEFT JOIN page ON page_namespace = 10
    AND page_title = tl_title
WHERE tl_from_namespace = 0
AND pl_from =2779830

    AND tl_namespace = 10
GROUP BY tl_title
ORDER BY count(tl_title) DESC limit 50
;
SQL

Checking query status...
