use hewiki_p;

select concat('https://he.wikipedia.org/wiki/', case page_namespace when 1 then "Talk:" else "קטגוריה:" end, page_title) as address,

page_namespace, page_title, count(revision.rev_id) as revisions, count(distinct(actor_user)) as users from page inner join revision

join actor

on page.page_id = revision.rev_page

and rev_actor = actor_user

where page_len = 0

and not page_namespace in (2, 3, 8)

and not (page_namespace = 4 and page_title like "דיווח_על_תקלדות/%")

group by revision.rev_page

order by page_namespace

​