WikiProjects for an article (sans sorting)

SQL

SELECT 
  CONCAT("[[", p.page_title, "]]") AS page_title,
  CONCAT("[[Talk:", p.page_title, "]]") AS talk_title,
  -- lt.lt_title,
  -- COUNT(p2.page_id)
  -- group_concat( DISTINCT lt.lt_title ORDER BY COUNT(p2.page_id) DESC SEPARATOR '}} {{' LIMIT 20) wikiprojects
  CONCAT("{{", group_concat( DISTINCT lt.lt_title SEPARATOR '}} {{' LIMIT 10) , "}}") wikiprojects
  
FROM
  page AS p,
  page AS p2,
  pagelinks AS pl,
  templatelinks AS tl,
  linktarget AS lt
 where 
  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 = 0
  AND pl.pl_from_namespace = 0

  AND p2.page_title = pl.pl_title
  AND p2.page_id = tl_from
  AND tl.tl_target_id = lt.lt_id
  AND tl.tl_from_namespace = 1
  AND lt.lt_namespace = 10
  AND lt.lt_title LIKE 'WikiProject\_%'
  AND NOT lt.lt_title LIKE '%/class'
  AND NOT lt.lt_title LIKE '%/importance'
  AND NOT lt.lt_title LIKE '%/styles.css'
  AND NOT lt.lt_title LIKE '%/portalbox'
  AND NOT lt.lt_title LIKE 'WikiProject\__anner\__hell'

  -- GROUP BY lt.lt_title
  -- ORDER BY COUNT(p2.page_id) DESC

LIMIT
  50
SQL

Checking query status...
