SQL
AخA
USE wikidatawiki_p;
SELECT CONCAT('Q',term_entity_id,'') AS item,
term_language AS term_language,
term_text
FROM wb_terms, wikidatawiki_p.page as wdp
WHERE term_type = 'description'
and exists (select term_entity_id from wikidatawiki_p.pagelinks wdpl where wdpl.pl_from = wdp.page_id AND (wdpl.pl_title = 'Q6581072') )
AND term_text LIKE "German_footballer"
AND term_entity_type = 'item'
LIMIT 10;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.