Untitled query #69272

SQL

SELECT wp.page_id as pageID, wp.page_title as pageTitle, iwl_title as category, pp.pp_value as WDitem
 
  --  (select ips_site_page from wikidatawiki_p.wb_items_per_site where ips_site_id="commonswiki" and ips_item_id=SUBSTR(pp.pp_value,2)) as categ
FROM page AS wp
JOIN iwlinks ON iwl_from = wp.page_id
LEFT JOIN page_props AS pp
  ON pp.pp_page = wp.page_id AND pp.pp_propname = 'wikibase_item'
-- LEFT JOIN wikidatawiki_p.page AS wdp
--  ON wdp.page_title = pp.pp_value AND wdp.page_namespace = 0
-- LEFT JOIN wikidatawiki_p.pagelinks AS wdpl
--   ON wdpl.pl_from = wdp.page_id AND wdpl.pl_namespace = 120 AND wdpl.pl_title = 'P373'
WHERE wp.page_namespace = 0
AND iwl_prefix='commons' and iwl_title like "Category:%"
-- AND wdpl.pl_from IS NULL
SQL

Checking query status...
