Infoboxes in cswiki

SQL

USE cswiki_p;
SELECT page_title, COUNT(tl_from) AS uses, SUM(IF(tl_from_namespace = 0, 1, 0)) AS in_main, page_is_redirect, IF(cl_to IS NULL, 0, 1) AS uses_wikidata
FROM page
LEFT JOIN templatelinks ON tl_title = page_title AND tl_namespace = page_namespace
LEFT JOIN categorylinks ON cl_to = "Wikipedie:Šablony_používající_údaje_z_Wikidat" AND cl_from = page_id
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;
SQL

Checking query status...
