List of articles created by Ahonc in ukwiki

SQL

USE ukwiki_p;
(SELECT @rownum := 0) r, SELECT @rownum := @rownum + 1 AS 'No.', page_id, pagename, page_len, date
FROM (
SELECT 
	CONCAT('[[', page_title, ']]') as pagename, 
    CONCAT(
      '{{dts|',YEAR(rev_timestamp) , '|',
	  MONTH(rev_timestamp), '|',
      DAY(rev_timestamp),"}}"     
      ) AS date, page_id, rev_id, page_len
FROM page
JOIN revision
	ON rev_page = page_id AND rev_parent_id = 0  AND
    rev_user_text = 'Ahonc'
JOIN (SELECT DISTINCT pl_from FROM pagelinks) pl
  	  ON pl_from = page_id
WHERE 
	page_namespace = 0 AND page_is_redirect = 0
  ORDER BY rev_timestamp ASC) t

ORDER BY rev_id ASC

SQL

Checking query status...