Untitled query #35662

SQL

/*
USE wikidatawiki_p;
SELECT page_title, comment_text FROM revision_userindex AS r1
JOIN page ON rev_page = page_id
JOIN `comment` ON comment_id = rev_comment_id
LEFT JOIN wb_items_per_site ON ips_item_id = REPLACE(page_title, 'Q', '')
WHERE rev_user_text = 'MatSuBot'
AND rev_timestamp > '20190505'
AND page_is_redirect = 0
AND ips_site_id IS NULL
AND NOT EXISTS (
  SELECT * FROM revision_userindex AS r2
  WHERE r1.rev_page = r2.rev_page AND r2.rev_id > r1.rev_id
) ORDER BY rev_id;*/
USE hywwiki_p;
SELECT log_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 term_full_entity_id IS NOT NULL AND 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
AND term_full_entity_id IS NOT NULL
AND ips_item_id IS NULL;
SQL

Checking query status...
