Rotlinks auf Fußballer nach Anzahl Verlinkungen

Fork of Rotlinks auf Landesrat nach Anzahl Verlinkungen by Atamari

This query is marked as a draft This query has been published by Atamari.

SQL

USE dewiki_p;
SELECT COUNT(*) as cnt, CONCAT('[[', REPLACE(pl_title, '_', ' '), ']]') as title
  FROM pagelinks LEFT JOIN page ON pl_title = page_title AND pl_namespace = page_namespace
 WHERE page_id IS NULL
   AND pl_namespace = 0
   AND pl_from_namespace = 0
   AND (pl_title LIKE "%(Fußballer)%" OR "%(Fußballspieler)%" )
   OR (pl_title LIKE "%(Fussballer)%" OR "%(Fussballerspieler)%")
   OR (pl_title LIKE "%(Golfer)%" OR pl_title LIKE "%(Golfspieler)%")
   OR (pl_title LIKE "%(Handballer)%" OR pl_title LIKE "%(Handballspieler)%")
 GROUP BY title
 ORDER BY cnt DESC;

SQL

Checking query status...