article creations for a given user

SQL

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

Checking query status...
