صفحات غير موجودة في ويكيبيديا العربية

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
INNER JOIN wb_items_per_site ips_en
  ON ips_en.ips_item_id = ips.ips_item_id
  AND ips_en.ips_site_id = 'enwiki'
LEFT JOIN wb_items_per_site ips_uk
  ON ips_uk.ips_item_id = ips.ips_item_id
  AND ips_uk.ips_site_id = 'arwiki'
JOIN page p
  ON p.page_title = CONCAT('Q', ips.ips_item_id)
  AND p.page_namespace = 0
WHERE ips.ips_site_id LIKE '%wiki'
  AND ips_uk.ips_item_id IS NULL
GROUP BY ips.ips_item_id
ORDER BY links DESC 
LIMIT 1000;

SQL

Checking query status...