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

SQL

SET @ime_kat_unos = 'Glazba po godinama';				-- promijeniti naziv kategorije po želji



SET @ime_kat = REPLACE(@ime_kat_unos, ' ', '_');
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;

SELECT DISTINCT c.cat_id, c.cat_pages,  page.page_title, page.page_len as 'page_len BEZ KUBURE I ČARAPA' , 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 NOT IN ('Kubura', 'Anfiets', 'Arraque', 'Cvicang', 
                     'Dvastaorla', 'Fleezer', 'Hergel', 'ImeldoMax', 
                     'Kartervaen', 'Kumordinar Žorž', 'Neadin', 'Radion', 
                     'Rikovers', 'Šedrvan', 'Stijenor NGC', 'Tobaccobox', 
                     'Tomec', 'Uršul', 'Verud', 'Zerukruhaivina', 'Demet',
                     'Gjiuh', 'Gretim', 'Jarebika', 'Leteći oleandar', 
                     'Malatrad', 'Orašnik', 'TekstViler', 'Vinko Ml.')
  and actor_name NOT LIKE "%Bot" 
limit 300;
SQL

Checking query status...
