Hewiki empty pages

SQL

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
SQL

Checking query status...
