Untitled query #4162

SQL

USE wikidatawiki_p;


-- SELECT * from revision
-- WHERE rev_comment LIKE '%Now%Music%N.Z.%'
-- LIMIT 1000;

-- SELECT * from recentchanges
-- WHERE rc_comment LIKE '%Now%Music%N.Z.%'
-- LIMIT 1000;

USE enwiki_p;

-- show tables;
-- SELECT * from page limit 5;
-- SELECT * from revision limit 5;
-- SELECT * from page_props limit 5;
-- SELECT * from archive limit 5;



SELECT tl_title, page1.page_title, page2.page_is_redirect, ips_item_id, ips_site_id, ips_site_page
FROM templatelinks
	JOIN page AS page1 ON page1.page_namespace = 0 AND page1.page_id = tl_from
	JOIN page AS page2 ON page2.page_namespace = 10 AND page2.page_title = tl_title

left join wikidatawiki_p.wb_items_per_site on ips_site_page=replace(page1.page_title, '_', ' ')
WHERE tl_from_namespace = 0 AND tl_namespace = 10
AND tl_title = "Infobox_settlement"

and ips_item_id is null
;
SQL

Checking query status...
