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 "%(%)%")

 GROUP BY title

 ORDER BY cnt DESC;

​