Anzahl Sprachversionen in Artikeln einer Kategorie

SQL

USE dewiki_p;
SELECT page_title, CONCAT('Q', De.ips_item_id) AS "Wikidata Item", count(Other.ips_site_id) AS "Anzahl Sprachen"
  FROM page, categorylinks,
       wikidatawiki_p.wb_items_per_site AS De, wikidatawiki_p.wb_items_per_site AS Other
 WHERE cl_to = REPLACE('Fußballspieler (FC Bayern München)', ' ', '_')
   AND cl_from = page_id
   AND page_namespace = 0
   AND De.ips_site_page = REPLACE(page_title, '_', ' ')
   AND De.ips_site_id = 'dewiki'
   AND De.ips_item_id = Other.ips_item_id
 GROUP BY Other.ips_item_id
 ORDER BY `Anzahl Sprachen` DESC

SQL

Checking query status...