Non-empty categories marked as redirect with template on huwiki

Fork of Empty categories not marked as redirect with template on huwiki by FoBe

This query is marked as a draft This query has been published by FoBe.

SQL

# cl_to: Stores the name (excluding namespace prefix) of the desired category. Spaces are replaced by underscores (_)
USE huwiki_p;
SELECT distinct CONCAT('[https://hu.wikipedia.org/w/index.php?title=Kategória:',cat_title,'&redirect=no ',cat_title,']') AS cat_title, cat_id, page_id
FROM category
inner join page
on page.page_title = category.cat_title
WHERE EXISTS ( select 1 from categorylinks where cl_from = page_id and cl_to = 'Kategóriaátirányítások' )
AND cat_pages != 0 # non-empty category

SQL

Checking query status...