Schlüssel für Vorlage Treccani.it

SQL

USE dewiki_p;
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(el_to, '(', -1), ')', 1) AS Hintendran, COUNT(*) AS Anzahl
  FROM externallinks
 WHERE el_to LIKE "http://www.treccani.it/enciclopedia/_%(%)%"
    OR el_to LIKE "https://www.treccani.it/enciclopedia/_%(%)%"
    OR el_to LIKE "//www.treccani.it/enciclopedia/_%(%)%"
 GROUP by Hintendran
 ORDER BY Anzahl DESC;

/* Zweite Query wo - und _ in der Url gleich behandelt werden */
SELECT REPLACE(SUBSTRING_INDEX(SUBSTRING_INDEX(el_to, '(', -1), ')', 1), '_', '-') AS Hintendran_2, COUNT(*) AS Anzahl
  FROM externallinks
 WHERE el_to LIKE "http://www.treccani.it/enciclopedia/_%(%)%"
    OR el_to LIKE "https://www.treccani.it/enciclopedia/_%(%)%"
    OR el_to LIKE "//www.treccani.it/enciclopedia/_%(%)%"
 GROUP by Hintendran
 ORDER BY Anzahl DESC
SQL

Checking query status...
