Untitled query #64747

SQL

SELECT CONCAT('Q', ips.ips_item_id) AS wikidata_item_id, COUNT(*) AS links, 
  CONCAT('<a href="http://en.wikipedia.org/wiki/', ips_en.ips_site_page, '">', ips_en.ips_site_page, '</a>') 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"
WHERE ips.ips_site_id LIKE '%wiki'
AND ips_en.ips_site_page NOT REGEXP '^(Category|Template|Module|MediaWiki|Help|Portal|Wikipedia)'
GROUP BY ips.ips_item_id
HAVING COUNT(CASE WHEN ips.ips_site_id = 'ukwiki' THEN 1 END) < 1 
AND COUNT(CASE WHEN ips.ips_site_id = 'enwiki' THEN 1 END) > 0

LIMIT 10;
SQL

Checking query status...
