Untitled query #66657

SQL

/*SELECT CONCAT("Q", ips_item_id) AS item, ips_site_page AS page, 

FROM (SELECT * FROM wb_items_per_site WHERE ips_site_id = "trwiki")

CONCAT('Q', wbit_item_id) AS Pr, CONCAT('* [[',page_title,']]') AS sayfa, CONCAT('* [[:',il_to,']]') AS dosya 
FROM page JOIN langlinks ON ll_from = page_id JOIN imagelinks ON il_from = page_id
WHERE ll_lang = "tr"
AND page_namespace = 120
limit 100;
*/

# https://doc.wikimedia.org/Wikibase/master/php/md_docs_storage_terms.html

SELECT
  CONCAT('Q', wbit_item_id) AS item_id, CONCAT('* [[:',il_to,']]') AS file
FROM wbt_item_terms
LEFT JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id
LEFT JOIN wbt_type ON wbtl_type_id = wby_id
LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
LEFT JOIN wbt_text ON wbxl_text_id = wbx_id
JOIN page JOIN langlinks ON ll_from = page_id JOIN imagelinks ON il_from = page_id
WHERE ll_lang = "tr"
WHERE wbxl_language = "tr"
AND term_entity_type = "item"
limit 100;
SQL

Checking query status...
