中国語版は意外と頑張ってます

SQL

use jawiki_p;/*
select page_title, substring( pp_value from 2 ) as wikidata_id
from page_props
inner join page on pp_page = page_id and (pp_propname = "wikibase_item" and
                                          page_namespace = 0 and
                                          page_title regexp '\\-[0-9]{4}(年)?\\)$'
                                         )
  */
select *
from wikidatawiki_p.wb_items_per_site
inner join (
  select page_title, substring( pp_value from 2 ) as wikidata_id
  from page_props
  inner join page on pp_page = page_id and (pp_propname = "wikibase_item" and
                                          page_namespace = 0 and
                                          page_title regexp '\\-[0-9]{4}(年)?\\)$'
                                         )
) as a on wikidata_id = ips_item_id and ips_site_id = "enwiki"
SQL

Checking query status...
