Untitled query #39675

SQL

SELECT CONCAT('[[', REPLACE(P.page_title, '_', ' '), ']]') AS "Artikel",
       GROUP_CONCAT(CONCAT('[[', REPLACE(L.page_title, '_', ' '), ']]') SEPARATOR ' • ') AS "Lemmaverwandte"
  FROM templatelinks, linktarget, 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(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(P.page_title, '_Sen.', 1), '_sen.', 1), '_Jun.', 1), '_jun.', 1), '_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."
        OR P.page_title LIKE "%Sen."
        OR P.page_title LIKE "%sen."
        OR P.page_title LIKE "%Jun."
        OR P.page_title LIKE "%jun."
       )
   AND tl_from = P.page_id
   AND lt_id = tl_target_id
   AND lt_title = 'Personendaten'
   AND lt_namespace = 10
 GROUP by P.page_title
 ORDER BY LOWER(CONVERT(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(P.page_title, '_Sen.', -1), '_sen.', -1), '_Jun.', -1), '_jun.', -1), '_Sr.', -1), '_sr.', -1), '_Jr.', -1), '_jr.', -1), '(', -1) USING utf8mb4)), SUBSTRING_INDEX(P.page_title, '(', -1), P.page_title
SQL

Checking query status...
