Articles in a specific category with only initial revision (hrwiki)

SQL

SET @ime_kat = 'Kiparstvo_po_godinama';			-- promijeniti naziv kategorije po želji

use hrwiki_p;
SELECT DISTINCT c.cat_id, c.cat_pages, cl.cl_from,  page.page_title, page.page_len   -- , count( distinct(page.page_title)) 
															-- otkomentirati ', count...' za broj umjesto popisa
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 = 0
  and page.page_is_new = 0
  and page.page_is_redirect = 0
  -- and actor_name != "Kubura"
limit 300;


SELECT c.cat_id, c.cat_pages, cl.cl_from,  page.page_title, page.page_len as 'page_len BEZ KUBURE'   , count( distinct(page.page_title))
															-- otkomentirati za broj umjesto popisa
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	-- naziv kategorije
and page.page_namespace = 0
  and page.page_is_new = 0
  and page.page_is_redirect = 0
  and actor_name != "Kubura"
limit 300
SQL

Checking query status...
