Page MenuHomePhabricator
Paste P8150

(An Untitled Masterwork)
ActivePublic

Authored by Addshore on Mar 4 2019, 5:04 PM.
Tags
None
Referenced Files
F28325143: raw.txt
Mar 4 2019, 5:04 PM
Subscribers
None
SELECT term_full_entity_id, term_type, term_language, term_text
FROM wb_terms
WHERE term_entity_type = 'item'
AND term_type = 'label'
AND ( term_full_entity_id = 'Q64' OR term_full_entity_id = 'Q1234' OR term_full_entity_id = 'Q999' OR term_full_entity_id = 'Q1000000' )
AND ( term_language = 'en' OR term_language = 'de' );
SELECT wb_page_to_entity.entity_id as entityId, wb_entity_term_type.type as type, wb_term_search_langs.language as language, wb_term_search_strings.term_text as text
FROM wb_page_to_entity
INNER JOIN page ON wb_page_to_entity.page_id = page.page_id
INNER JOIN wb_entity_terms_2 ON wb_page_to_entity.page_id = wb_entity_terms_2.page_id
INNER JOIN wb_term_search_langstringtype ON wb_entity_terms_2.langstringtype = wb_term_search_langstringtype.id
INNER JOIN wb_term_search_langstring ON wb_term_search_langstringtype.langstring = wb_term_search_langstring.id
INNER JOIN wb_term_search_langs ON wb_term_search_langstring.term_language = wb_term_search_langs.id
INNER JOIN wb_entity_term_type ON wb_term_search_langstringtype.type = wb_entity_term_type.id
INNER JOIN wb_term_search_strings ON wb_term_search_langstring.term_text = wb_term_search_strings.id
WHERE page.page_namespace = 0
AND wb_entity_term_type.type = 'label'
AND wb_page_to_entity.entity_id IN ( term_full_entity_id = 'Q64' OR term_full_entity_id = 'Q1234' OR term_full_entity_id = 'Q999' OR term_full_entity_id = 'Q1000000' )
AND ( wb_term_search_langs.language = 'en' OR wb_term_search_langs.language = 'de' );