SQL
AخA
SELECT CONCAT('http://www.wikidata.org/entity/Q', wbt_item_terms.wbit_item_id) as p
FROM wbt_item_terms
JOIN wbt_term_in_lang ON wbt_item_terms.wbit_term_in_lang_id = wbt_term_in_lang.wbtl_id
AND wbt_term_in_lang.wbtl_type_id = 2 # 1- label; 2- description; 3- alias
JOIN wbt_text_in_lang ON wbt_term_in_lang.wbtl_text_in_lang_id = wbt_text_in_lang.wbxl_id
AND wbt_text_in_lang.wbxl_language = 'en' # <lang>
JOIN wbt_text ON wbt_text_in_lang.wbxl_text_id = wbt_text.wbx_id
AND wbt_text.wbx_text = 'Wikimedia project page'
LIMIT 10000;
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.