Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Matěj Suchánek
.
Toggle Highlighting
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 LEFT JOIN wikidatawiki_p.wb_items_per_site ON ips_site_id = 'hywwiki' AND ips_site_page = REPLACE(log_title, '_', ' ') LEFT JOIN wikidatawiki_p.wb_terms ON term_language = 'hy' AND term_text IN (log_title, REPLACE(log_title, '_', ' ')) AND term_type IN ('alias', 'label') WHERE log_type = 'import' AND log_namespace = 0 AND ips_item_id IS NULL;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...