Untitled query #40142

SQL

select t0.ips_site_page, qid from wikidatawiki_p.wb_items_per_site as t0
join (SELECT iwl_title AS qid
  FROM metawiki_p.iwlinks
  LEFT JOIN wikidatawiki_p.wb_items_per_site as t1 ON t1.ips_item_id = TRIM('Q' FROM iwl_title) AND t1.ips_site_id = 'hewiki'
  LEFT JOIN hewiki_p.page ON page_title = REPLACE(t1.ips_site_page, ' ', '_') AND page_namespace = 0
      WHERE iwl_from = 141462 AND iwl_prefix = 'd' AND COALESCE(page_is_redirect, 1) = 1 ) t3
on TRIM('Q' FROM qid) = t0.ips_item_id
where t0.ips_site_id = 'enwiki'
SQL

Checking query status...
