Untitled query #39675

SQL

SELECT CONCAT('[[', REPLACE(page_title, '_', ' '), ']]') AS "Artikel"
  FROM templatelinks, page AS P
 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%)%"
       )
   AND tl_from = P.page_id
   AND tl_title = 'Personendaten'
   AND tl_namespace = 10
 ORDER BY LOWER(CONVERT(SUBSTRING_INDEX(page_title, '(', -1) USING utf8mb4)) DESC, SUBSTRING_INDEX(page_title, '(', -1), page_title
SQL

Checking query status...
