SQL
AخA
SELECT CONCAT("Q",ips_item_id), "Len", CONCAT('"',ips_site_page,'"')
FROM wb_items_per_site
WHERE ips_site_id='enwiki'
AND NOT EXISTS (
SELECT wbit_item_id FROM wbt_item_terms
INNER JOIN wbt_term_in_lang
ON wbtl_id = wbit_term_in_lang_id
INNER JOIN wbt_text_in_lang
ON wbxl_id = wbtl_text_in_lang_id
WHERE wbit_item_id = ips_item_id
AND wbxl_language = "en"
AND wbtl_type_id = 1
)
LIMIT 45000
;
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.