Untitled query #38992

SQL

USE dewiki_p;
SELECT pl.pl_title AS target, ps.page_title AS prim_source, plsp.page_title AS secn_souce
FROM pagelinks pl
INNER JOIN page pd ON (pd.page_title = pl.pl_title AND pd.page_namespace = pl.pl_namespace)
LEFT JOIN page ps ON (ps.page_id = pl.pl_from AND ps.page_namespace = pl.pl_namespace)
LEFT JOIN pagelinks pls ON (pls.pl_title = ps.page_title AND pls.pl_namespace = ps.page_namespace AND ps.page_is_redirect = 1)
LEFT JOIN page plsp ON (plsp.page_id = pls.pl_from AND plsp.page_namespace = pls.pl_namespace)
INNER JOIN page_props pp ON (pp.pp_page = pd.page_id AND pp.pp_propname = 'disambiguation')
WHERE pl.pl_namespace = 0
AND pl.pl_from_namespace = 0
AND pl.pl_title = "Indio"
SQL

Checking query status...
