Untitled query #7765

SQL

use lvwiki_p;
SELECT
  pl_namespace AS namespace,
  pl_title AS title,
  EXISTS (
    SELECT 1 FROM pagelinks
    WHERE pl_from=pp_page AND pl_namespace=page.page_namespace AND pl_title=page.page_title
  ) AS linksback,
  NULL as tl_title,
  rd_namespace,
  rd_title

FROM page
JOIN pagelinks       ON pl_from = page.page_id
JOIN page AS pl      ON pl.page_namespace = pl_namespace AND pl.page_title = pl_title
#JOIN s51892_toolserverdb_p.namespacename    ON ns_id = pl_namespace AND ns_is_favorite = 1 AND dbname = (SELECT DATABASE())
LEFT JOIN redirect   ON rd_from = pl.page_id
LEFT JOIN page AS rd ON rd.page_namespace = rd_namespace AND rd.page_title = rd_title
JOIN page_props      ON pp_page = IFNULL(rd.page_id, pl.page_id) 

WHERE #page.page_namespace=0# AND page.page_title=?
#AND 
pp_propname="disambiguation"
GROUP BY pl.page_id
limit 1000
SQL

Checking query status...
