(DRAFTING:) number of enwiki articles with Wikidata items

SQL

#SELECT COUNT(*)
#FROM (
#  SELECT page_title 
#  FROM enwiki_p.page
#  WHERE page_namespace = 0
#  AND page_is_redirect = 0) AS pagetitles
#JOIN (
#  SELECT DISTINCT ips_site_page
#  FROM wikidatawiki_p.wb_items_per_site
#  WHERE ips_site_id = 'enwiki') AS enwikisitelinks
#ON pagetitles.page_title = enwikisitelinks.ips_site_page;


#    CONCAT("https://en.wikipedia.org/wiki/", page_title) AS desktop_url,
#    CONCAT("https://en.m.wikipedia.org/wiki/", page_title) AS mobile_url,

SELECT COUNT(*)
FROM (
  SELECT
    page_id,
  	page_title
  FROM
    enwiki_p.page
  WHERE
    page_namespace = 0
  AND
    page_is_redirect = 0
  AND
    page_random >= 0.5
  AND
    page_random < 0.505
) AS page_titles
JOIN (
  SELECT
    pp_page,
    pp_page.wikibase_item
  FROM
  	enwiki_p.page_props
  WHERE
    wikibase_item IS NOT NULL
) AS pp_pages
ON
  page_titles.page_id = pp_pages.pp_page
ORDER BY
  RAND(3003431782)
LIMIT 100
SQL

Checking query status...
