Longest_VG_stubs

SQL

SELECT DISTINCT c.cat_id, c.cat_pages, page.page_title, page.page_len, a_rev.actor_name -- , 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 = 'Stub-Class_video_game_articles'
and page.page_namespace = 0
  and page.page_is_redirect = 0
  and r_ui.rev_parent_id = 0
order by page_len asc
limit 100;
SQL

Checking query status...
