Untitled query #64747

SQL

SELECT CONCAT('Q', ips.ips_item_id) AS wikidata_item_id, COUNT(*) AS links, ips_en.ips_site_page AS enwiki_article
FROM wb_items_per_site ips
JOIN wb_items_per_site ips_en ON ips_en.ips_item_id = ips.ips_item_id AND ips_en.ips_site_id = "enwiki"
JOIN page p ON p.page_title = ips.ips_site_page AND p.page_namespace = 0
WHERE ips.ips_site_id LIKE '%wiki'
AND NOT EXISTS (
    SELECT 1
    FROM wb_items_per_site ips_uk
    WHERE ips_uk.ips_item_id = ips.ips_item_id AND ips_uk.ips_site_id = 'ukwiki'
)
AND EXISTS (
    SELECT 1
    FROM wb_items_per_site ips_en
    WHERE ips_en.ips_item_id = ips.ips_item_id AND ips_en.ips_site_id = 'enwiki'
)
GROUP BY ips.ips_item_id
ORDER BY links DESC 
LIMIT 100;
SQL

Checking query status...
