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

SQL

SET @ime_kat_unos = 'Kemija 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)) 
														-- 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 = 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)) 
															-- 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 = 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)) 
															-- 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 = 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...
