Untitled query #29550

SQL

use jawiki_p;
select wiki, local_article, local_avg_len, global_article, global_avg_len
from
(
  select "ja" as wiki, count(*) as local_article, avg(page_len) as local_avg_len
  from page
  where 
  not exists
  (
    select *
    from langlinks
    where page_id = ll_from
  ) and
  page_namespace = 0 and
  page_is_redirect = 0
) as a
inner join
(
  select "ja" as wiki, count(*) as global_article, avg(page_len) as global_avg_len
  from page
  where 
  exists
  (
    select *
    from langlinks
    where page_id = ll_from
  ) and
  page_namespace = 0 and
  page_is_redirect = 0
) as b on a.wiki = b.wiki
SQL

Checking query status...
