Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P8149
(An Untitled Masterwork)
Active
Public
Actions
Authored by
Addshore
on Mar 4 2019, 5:03 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F28325140: raw.txt
Mar 4 2019, 5:03 PM
2019-03-04 17:03:24 (UTC+0)
Subscribers
None
SELECT term_full_entity_id FROM wb_terms
WHERE term_text = 'Berlin'
AND term_entity_type = 'item'
AND (term_type = 'label' OR term_type = 'alias')
AND term_language = 'en';
SELECT wb_page_to_entity.entity_id AS entity_id
FROM wb_term_search_strings
INNER JOIN wb_term_search_langstring ON wb_term_search_langstring.term_text = wb_term_search_strings.id
INNER JOIN wb_term_search_langs ON wb_term_search_langstring.term_language = wb_term_search_langs.id
INNER JOIN wb_term_search_langstringtype ON wb_term_search_langstringtype.langstring = wb_term_search_langstring.id
INNER JOIN wb_entity_term_type ON wb_term_search_langstringtype.type = wb_entity_term_type.id
INNER JOIN wb_entity_terms_2 ON wb_entity_terms_2.langstringtype = wb_term_search_langstringtype.id
INNER JOIN page ON wb_entity_terms_2.page_id = page.page_id
INNER JOIN wb_page_to_entity ON wb_entity_terms_2.page_id = wb_page_to_entity.page_id
WHERE wb_term_search_strings.term_text = 'Berlin'
AND page.page_namespace = 0
AND (wb_term_search_langs.language = 'en')
AND (wb_entity_term_type.type = 'label' OR wb_entity_term_type.type = 'alias');
Event Timeline
Addshore
created this paste.
Mar 4 2019, 5:03 PM
2019-03-04 17:03:24 (UTC+0)
Log In to Comment