Wikidata - given names - 'disambiguation' in description

This query is marked as a draft This query has been published by Jura1.

SQL

# find "disambiguation" in descriptions of items linked from a given page
use wikidatawiki_p; 
SELECT page_title AS item, term_type, term_language, term_text, 
page_title AS item1, CONCAT('D', term_language) AS Desc1, '""' AS Str1,
CURRENT_DATE
FROM pagelinks, page, wb_entity_per_page, wb_terms
WHERE pl_from = 21293912  # page https://www.wikidata.org/wiki/User:Jura1/first_names/items_%28P31:_ok,_label:_tbd%29
AND pl_namespace = 0
AND pl_title = page_title
AND page_id = epp_page_id
AND epp_entity_id = term_entity_id
AND term_entity_type = 'item'
AND term_type = 'description'       # description, alias
AND (
   term_text LIKE '%disambigua%'
OR term_text LIKE '%Wiki%'
OR term_text LIKE '%page%'
OR term_text LIKE '%desambigua%'
OR term_text LIKE '%homonym%' 
OR term_text LIKE '%homónimo%'
OR term_text LIKE '%aðgreiningarsíða%'
OR term_text LIKE '%apartigilo%'
OR term_text LIKE '%doorverwijspagina%'
OR term_text LIKE '%egyértelműsítő%'
OR term_text LIKE '%grensida%'
OR term_text LIKE '%nyahkekaburan%'
OR term_text LIKE '%Minangkabau%'
OR term_text LIKE '%Oriya%'
OR term_text LIKE '%ágina%'
OR term_text LIKE '%rozcestník%'
OR term_text LIKE '%rozlišovacia stránka%'
OR term_text LIKE '%mehrdüdig Begreep%'
OR term_text LIKE '%strona ujednoznaczniająca%'
OR term_text LIKE '%täsmennyssivu%'
OR term_text LIKE '%Begriffsklärungsseite%'
OR term_text LIKE '%fleirtydingsside%'
OR term_text LIKE '%flertydigside%'
OR term_text LIKE '%pekerside%'
OR term_text LIKE '%σελίδα αποσαφήνισης%'
OR term_text LIKE '%појаснителна страница%'
OR term_text LIKE '%страница значений%'
OR term_text LIKE '%דף פירושונים%'
OR term_text LIKE '%پەڕەی ڕوونکردنەوەی ویکیمیدیا%'
OR term_text LIKE '%یک صفحهٔ ابهام‌زدایی ویکی‌مدیا%'
OR term_text LIKE '%बहुविकल्पी पृष्ठ%'
OR term_text LIKE '%উইকিমিডিয়া দ্ব্যর্থতা নিরসন পাতা%'
OR term_text LIKE '%સ્પષ્ટતા પાનું%'
OR term_text LIKE '%ବହୁବିକଳ୍ପ ପୃଷ୍ଠା%'
OR term_text LIKE '%მრავალმნიშვნელოვანი%'
OR term_text LIKE '%ウィキメディアの曖昧さ回避ページ%'
OR term_text LIKE '%위키미디어 동음이의어 문서%'
OR term_text LIKE '%維基媒體消歧義頁%'
OR term_text LIKE '%维基媒体消歧义页%'
OR term_text LIKE '%维基媒体消歧义页%'
OR term_text LIKE '%维基百科消歧义页%'
OR term_text LIKE '%پەڕەی ڕوونکردنەوەی ویکیپیدیا%'     
OR term_text LIKE '%উইকিপিডিয়া দ্ব্যর্থতা নিরসন পাতা%'     
OR term_text LIKE '%维基百科消歧义页%'
OR term_text LIKE '%维基百科消歧义页%'
OR term_text LIKE '%維基百科消歧義頁%'      
  )

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.

SQL

Checking query status...