Talkpages with no content (hrwiki)

SQL

SET @ime_kat_unos = 'SZR sa ručnim zaglavljem';				-- promijeniti naziv kategorije po želji


SET @ime_kat = REPLACE(@ime_kat_unos, ' ', '_');
-- SELECT DISTINCT c.cat_id, c.cat_pages, page.page_title, page.page_len  -- , count( distinct(cl.cl_from)) 
														-- staviti "--(razmak)" ispred ", count..." za popis umjesto broja

SELECT DISTINCT CONCAT("# [[Razgovor:", page.page_title, "]]")
from category as c
inner join categorylinks as cl on c.cat_title = cl.cl_to
inner join page on cl.cl_from = page.page_id
where c.cat_title = @ime_kat
  and page.page_namespace = 1
--  and page.page_is_new = 0
  and page.page_is_redirect = 0
  and page.page_len < 30
order by page.page_title asc
SQL

Checking query status...
