enwikiのFA記事のjawikiにおける現状一覧

SQL

use jawiki_p;
select * 
from page
join page_props as ja_pp on page_id = pp_page and (pp_propname = "wikibase_item")
join (
  select
    pp_value,
    page_title as enwiki_pagename,
    page_len as enwiki_pagelen,
    count(*) as langs
  from wikidatawiki_p.wb_items_per_site
  join (
    select page_id, page_title, page_len, pp_value, ubstring( pp_value, 2) as wikidatalink
    from enwiki_p.categorylinks
    join enwiki_p.page_props on cl_from = pp_page
    join enwiki_p.page on cl_from = page_id
    where
      cl_to = "Featured_articles" and
      pp_propname = "wikibase_item"
    limit 10) as enwiki_FAs on wikidatalink = ips_item_id
  group by ips_item_id, page_title, page_len, pp_value
) as enwp_FA_&_wd on ja_pp.pp_value = pp_value
SQL

Checking query status...
