Untitled query #35662

SQL

USE hywwiki_p;
/*
SELECT log_title, page_title#, term_full_entity_id
FROM logging
JOIN page ON page_id = log_page
LEFT JOIN page_props ON pp_page = log_page AND pp_propname = 'wikibase_item'
#LEFT JOIN wikidatawiki_p.wb_terms
#	ON term_language = 'hy' AND term_text = REPLACE(page_title, '_', ' ') AND term_type IN ('alias', 'label')
#LEFT JOIN wikidatawiki_p.wb_items_per_site
#	ON ips_site_id = 'hywwiki' AND ips_item_id = REPLACE(term_full_entity_id, 'Q', '')
WHERE log_type = 'import' AND log_namespace = 0
AND pp_value IS NULL;
/*/
SELECT hyw.page_title, ips_item_id#, term_full_entity_id
FROM logging
JOIN page AS hyw ON hyw.page_id = log_page
LEFT JOIN page_props ON pp_page = log_page AND pp_propname = 'wikibase_item'
CROSS JOIN hywiki_p.page AS hy
JOIN wikidatawiki_p.wb_items_per_site AS ips1
	ON ips_site_id = 'hywiki' AND ips_site_page = REPLACE(hy.page_title, '_', ' ')
WHERE log_type = 'import' AND log_namespace = 0
AND log_title LIKE '%_(արեւմտահայերէն)'
AND hy.page_namespace = 0
AND hy.page_title = REPLACE(hyw.page_title, '_(արեւմտահայերէն)', '')
AND pp_value IS NULL
AND NOT EXISTS (
  SELECT 1 FROM wikidatawiki_p.wb_items_per_site AS ips2 WHERE ips2.ips_site_id = 'hywwiki' AND ips2.ips_item_id = ips1.ips_item_id
);
#*/
SQL

Checking query status...
