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

SQL

use hrwiki_p;
SELECT c.cat_id, c.cat_pages, page.page_len, DISTINCT page.page_title  -- , 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 = "Arhitektura_po_godinama"	-- promijeniti naziv kategorije po želji
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...