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

SQL

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

use hrwiki_p;
SELECT DISTINCT c.cat_id, c.cat_pages, page.page_title, page.page_len   , count( distinct(cl.cl_from)) 
															-- 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"
  and actor_name NOT LIKE "%Bot" 
limit 300;


SELECT DISTINCT c.cat_id, c.cat_pages,  page.page_title, page.page_len as 'page_len BEZ KUBURE'   , count( distinct(cl.cl_from)) 
															-- 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"
  and actor_name NOT LIKE "%Bot" 
limit 300
SQL

Checking query status...
