Paste P8149

(An Untitled Masterwork)
ActivePublic
Actions

Authored by Addshore on Mar 4 2019, 5:03 PM.

Tags

None

Referenced Files

	F28325140: raw.txt
	Mar 4 2019, 5:03 PM

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