Untitled query #1276

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
FROM pagelinks, page, wb_entity_per_page, wb_terms
WHERE pl_from = 21293912  # page [[d:User:Jura1/3]], see https://www.wikidata.org/w/index.php?title=User:Jura1/3&action=info
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 '%aðgreiningarsíða%'
OR term_text LIKE '%পারিবারিক নাম%'
OR term_text LIKE '%cognom%'
OR term_text LIKE '%příjmení%'
OR term_text LIKE '%efternavn%'
OR term_text LIKE '%Familienname%'
OR term_text LIKE '%επώνυμο%'
OR term_text LIKE '%family name%'
OR term_text LIKE '%apellido%'
OR term_text LIKE '%abizen%'
OR term_text LIKE '%نام خانوادگی%'
OR term_text LIKE '%sukunimi%'
OR term_text LIKE '%nom de famille%'
OR term_text LIKE '%apelido%'
OR term_text LIKE '%અટક%'
OR term_text LIKE '%שם משפחה%'
OR term_text LIKE '%nama asli%'
OR term_text LIKE '%eftirnafn%'
OR term_text LIKE '%cognome%'
OR term_text LIKE '%姓%'
OR term_text LIKE '%성씨%'
OR term_text LIKE '%namo asli%'
OR term_text LIKE '%презиме%'
OR term_text LIKE '%etternavn%'
OR term_text LIKE '%Familiennaam%'
OR term_text LIKE '%familienaam%'
OR term_text LIKE '%etternamn%'
OR term_text LIKE '%nazwisko%'
OR term_text LIKE '%nume de familie%'
OR term_text LIKE '%priezvisko%'
OR term_text LIKE '%priimek%'
OR term_text LIKE '%姓氏%'
OR term_text LIKE '%surname%'
   
  )
SQL

Checking query status...
