SQL
AخA
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_namespace = 10
AND page_title LIKE "Infobox%"
AND page_title NOT LIKE "%/%"
GROUP BY page_title
ORDER BY in_main, uses, page_is_redirect, 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.
All SQL code is licensed under CC0 License.