All double redirects (shwiki)

SQL

SELECT
  p1.page_title AS "Prvo preusmerenje",
  p2.page_title AS "Drugo preusmerenje",
  p3.page_title AS "Ciljna stranica"
FROM
  page AS p1
JOIN
  redirect AS r1 ON p1.page_id = r1.rd_from
JOIN
  page AS p2 ON r1.rd_title = p2.page_title AND r1.rd_namespace = p2.page_namespace
JOIN
  redirect AS r2 ON p2.page_id = r2.rd_from
JOIN
  page AS p3 ON r2.rd_title = p3.page_title AND r2.rd_namespace = p3.page_namespace
WHERE
  p1.page_namespace = 0
  AND p2.page_namespace = 0
  AND p3.page_namespace = 0
  AND p1.page_is_redirect = 1
  AND p2.page_is_redirect = 1
  AND p3.page_is_redirect = 0
ORDER BY
  p1.page_title;
SQL

Checking query status...
