Small talkpages from category (hrwiki)

SQL

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



SET @ime_kat = REPLACE(@ime_kat_unos, ' ', '_');
use hrwiki_p;
SELECT CONCAT('* [[Razgovor:',page.page_title,']] - ', page.page_len, ' bajtova <br/>'), count(page.page_title)  -- , count( distinct(cl.cl_from)) 
														-- staviti "--(razmak)" ispred ", count..." za popis umjesto broja
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
inner join revision_userindex as r_ui on r_ui.rev_page = page.page_id
inner join actor_revision as a_rev on r_ui.rev_actor = a_rev.actor_id
where c.cat_title = @ime_kat
 and page.page_namespace = 1
 -- and page.page_is_new = 1
 and page.page_len < 50
  -- and page.page_is_redirect = 0
  and actor_name = "SpeedyBot"
order by page.page_title ASC
group by page.page_title
limit 300;
SQL

Checking query status...
