Untitled query #35292

[407430, 0, 'Andreja_Pumpura_iela_(Rīga)', '', 0, 0, 0.525951103821, '20190216132850', '20190216134503', 2949619, 3322, 'wikitext', None, 407430, 'commons', 'Category:', 407430, 'wikibase_item', 'Q58465332', None, 58378067, 0, 'Q58465332', '', 0, 0, 0.406059733427, '20190305185402', '20190305185402', 875112233, 3350, 'wikibase-item', None, None, None, None, None, None]

SQL

use lvwiki_p;
SELECT *,
    (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 wp.page_title="Andreja_Pumpura_iela_(Rīga)"
AND iwl_prefix='commons' and iwl_title like "Category:%"
AND wdpl.pl_from IS NULL

SQL

Checking query status...