WikiProjects for an article (sans sorting)

SQL

SELECT 
  CONCAT("[[", p.page_title, "]]") AS page_title,
  CONCAT("[[Talk:", p.page_title, "]]") AS talk_title,
  p2.page_title,
  linktarget.lt_title
FROM
  page AS p,
  page AS p2,
  pagelinks AS pl
  templatelinks AS tl,
  linktarget AS lt,

 where 
  -- the page under study
  p.page_title = "OnGreen"
  AND p.page_namespace = 0
  AND p.page_is_redirect = 0
  AND p.page_id = pl.pl_from
  
  AND pl.pl_namespace = 1
  AND pl.pl_from_namespace = 0
  AND p2.page_title = pl.pl_title
  
  AND p2.page_id = tl_from
  AND templatelinks.tl_target_id = linktarget.lt_id
  AND templatelinks.tl_from_namespace = 0
  AND linktarget.lt_namespace = 10
  AND linktarget.lt_title LIKE "WikiProject_%"

LIMIT
  10
SQL

Checking query status...
