Rotlinks mit "ähnlichem" Klammerlemma

SQL

SELECT article.page_title AS "Artikel", pl_title AS "Rotlink", similar.page_title AS "Ähnlicher Artikel"
  FROM page AS similar, page AS article,
       pagelinks LEFT JOIN templatelinks
                   ON tl_from = pl_from
                  AND tl_namespace = 10
                  AND tl_title = 'Begriffsklärung'
                 LEFT JOIN page AS rotlink
                   ON rotlink.page_namespace = pl_namespace
                  AND rotlink.page_title = pl_title
 WHERE tl_from IS NULL
   AND rotlink.page_id IS NULL
   AND pl_from_namespace = 0
   AND pl_namespace = 0
   AND pl_title LIKE "%\_(%"
   AND similar.page_namespace = 0
   AND similar.page_title LIKE CONCAT(SUBSTRING_INDEX(pl_title, "_(", 1), "\_(", LEFT(SUBSTRING_INDEX(pl_title, "_(", 2), 2), "%")
   AND article.page_id = pl_from
LIMIT 10
SQL

Checking query status...
