Untitled query #39675

SQL

SELECT CONCAT('[[', REPLACE(P.page_title, '_', ' '), ']]') AS "Artikel",
       GROUP_CONCAT(CONCAT('[[', REPLACE(L.page_title, '_', ' '), ']]') SEPARATOR ' • ') AS "Lemmaverwandte"
  FROM templatelinks, page AS P LEFT JOIN page as L
                                  ON L.page_namespace = P.page_namespace
                                 AND L.page_title LIKE CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(P.page_title, '_Sr.', 1), '_sr.', 1), '_Jr.', 1), '_jr.', 1), '(', 1), '%')
                                 AND L.page_title != P.page_title
 WHERE P.page_namespace = 0
   AND P.page_is_redirect = 0
   AND (P.page_title LIKE "%(%Senior%)%"
        OR P.page_title LIKE "%(%senior%)%"
        OR P.page_title LIKE "%(%Junior%)%"
        OR P.page_title LIKE "%(%junior%)%"
        OR P.page_title LIKE "%Sr."
        OR P.page_title LIKE "%sr."
        OR P.page_title LIKE "%Jr."
        OR P.page_title LIKE "%jr."
       )
   AND tl_from = P.page_id
   AND tl_title = 'Personendaten'
   AND tl_namespace = 10
 GROUP by P.page_title
 ORDER BY LOWER(CONVERT(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(P.page_title, '_Sr.', -1), '_sr.', -1), '_Jr.', -1), '_jr.', -1), '(', -1) USING utf8mb4)), SUBSTRING_INDEX(P.page_title, '(', -1), P.page_title
SQL

Checking query status...
