Untitled query #56835

SELECT ips_site_page
FROM wb_items_per_site
join page on ips_item_id=substr(page_title,2)*1
JOIN pagelinks AS wdpl on wdpl.pl_from = page_id
WHERE ips_site_id IN ('lvwiki')
 AND page_namespace=0 AND wdpl.pl_namespace = 120 AND wdpl.pl_title = 'P8286'


SELECT ips_site_page
from page
JOIN pagelinks AS wdpl on page_namespace=0 AND page_is_redirect=0 and wdpl.pl_from = page_id
join wb_items_per_site on ips_item_id=substr(page_title,2)*1 and ips_site_id IN ('lvwiki')
WHERE wdpl.pl_namespace = 120 AND wdpl.pl_title = 'P8286'

SQL

select * from wikidatawiki_p.page wdp
JOIN wikidatawiki_p.pagelinks AS wdpl
  ON wdpl.pl_from = wdp.page_id AND wdpl.pl_namespace = 120 AND wdpl.pl_title = 'P8286'
WHERE wp.page_namespace = 0

SQL

Checking query status...