Untranslated redlinks (cswiki)

SQL

USE cswiki_p;
SELECT tl_title, COUNT(page_id) FROM page
JOIN templatelinks ON tl_from = page_id
WHERE page_namespace = 0
AND page_title LIKE '%\_(%)'
AND tl_namespace = 10
AND tl_title LIKE 'Infobox\_-\_%'
GROUP BY tl_title
ORDER BY COUNT(page_id) DESC;
/*
SELECT page_title, page_is_redirect, rev_timestamp, actor_name, comment_text
FROM page
JOIN revision ON rev_page = page_id
JOIN actor_revision ON actor_id = rev_actor
JOIN comment_revision ON comment_id = rev_comment_id
WHERE page_namespace = 10
AND page_title LIKE 'Infobox\_-%'
AND page_title NOT LIKE '%/doc'
AND page_title NOT LIKE '%/test'
AND rev_timestamp BETWEEN '20191120' AND '20200120'
ORDER BY rev_timestamp;
*/
SQL

Checking query status...
