article creations for a given user

SQL

SELECT CONCAT("* [[", REPLACE(article.page_title, '_', ' '), "]]") AS article, page_len
FROM page AS article
INNER JOIN revision_userindex ON rev_page = article.page_id
WHERE rev_user_text = 'Johnbod'
AND rev_parent_id = 0
AND article.page_namespace = 0
AND article.page_is_redirect = 0
AND article.page_title NOT IN (
  SELECT page_title FROM page  INNER JOIN templatelinks ON page_id = tl_from 
  INNER JOIN revision_userindex ON rev_page = page_id 
  WHERE rev_user_text = 'Johnbod' 
  AND rev_parent_id = 0 AND page_namespace = 0 
  AND tl_namespace = 10 AND page_is_redirect = 0 
  AND LOWER(tl_title)  IN  ('disambig', 'disambiguation', 'hndis')
)
ORDER BY page_len ASC;
SQL

Checking query status...
