Infoboxes in cswiki

SQL

SELECT page_title, COUNT(tl_from) AS uses, SUM(IF(tl_from_namespace = 0, 1, 0)) AS in_main, page_is_redirect,
IF(wd.cl_to IS NULL, 0, 1) AS uses_wikidata, IF(depr.cl_to IS NULL, 0, 1) AS deprecated, IF(merge.cl_to IS NULL, 0, 1) AS to_merge
FROM page
LEFT JOIN templatelinks ON tl_title = page_title AND tl_namespace = page_namespace
LEFT JOIN categorylinks AS wd ON wd.cl_to = "Wikipedie:Šablony_používající_údaje_z_Wikidat" AND wd.cl_from = page_id
LEFT JOIN categorylinks AS depr ON depr.cl_to = "Údržba:Zastaralé_šablony" AND depr.cl_from = page_id
LEFT JOIN categorylinks AS merge ON merge.cl_to = "Údržba:Šablony_ke_sloučení" AND merge.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...
