قوالب معلومات

SQL

/*USE arwiki_p;

SELECT tl_title,
    count(tl_title)
FROM templatelinks
LEFT JOIN page ON page_namespace = 10
AND page_title not like "%/%"  -- no subtemplates
    AND page_title = tl_title
WHERE tl_from_namespace = 0
    AND tl_namespace = 10
    AND  EXISTS (
        SELECT NULL
        FROM categorylinks
        WHERE cl_from = page_id
      #      AND cl_to = 'قوالب_بلبنات_ص.م'
                 AND cl_to = 'قوالب_حساب_التواريخ'
        )
GROUP BY tl_title
ORDER BY count(tl_title) DESC limit 500
;
*/
USE arwiki_p;
SELECT page_title, COUNT(tl_from) AS uses, SUM(IF(tl_from_namespace = 0, 1, 0)) AS in_main, page_is_redirect
FROM page
LEFT JOIN templatelinks ON tl_title = page_title AND tl_namespace = page_namespace
#WHERE page_title LIKE "ص.م%" or  page_title LIKE "%معلومات%"
and page_namespace = 10

AND page_title not like "%/%" AND page_title not like "ص.م/%"
GROUP BY page_title
ORDER BY in_main, uses, page_is_redirect, page_title;
SQL

Checking query status...
