Untitled query #77823

SQL

SELECT
  p.page_title,
  pl.pl_title,
  r.rev_len
FROM
  page AS p
  LEFT JOIN pagelinks AS pl ON (pl.pl_from = p.page_id)
  LEFT OUTER JOIN page AS lp ON (lp.page_title = pl.pl_title)
  LEFT OUTER JOIN revision AS r ON (r.rev_id = lp.page_latest)
WHERE
  p.page_title='Main_Page'
  AND p.page_namespace=0
  limit 100
;





#select A.TrimPage , A.rev_timestamp, page.page_id from
#(SELECT  TRIM("Articles_for_deletion/" from page_title) as TrimPage, rev_timestamp
#FROM page join revision 
#on page.page_id = revision.rev_page
#WHERE page_title LIKE '%Articles_for_deletion%'
#AND page_namespace = 4
#and rev_parent_id=0
#) as A join page on page.page_title = A.TrimPage
SQL

Checking query status...
