List of articles created by Ahonc in ukwiki

SQL

USE ukwiki_p;
SELECT @rownum := @rownum + 1 AS 'No.', pagename, date
FROM (
SELECT 
	
	CONCAT('[[', page_title, ']]') as pagename, 
    CONCAT(
      '{{dts|',MONTH(rev_timestamp) , '|',
	  MONTH(rev_timestamp), '|',
      DAY(rev_timestamp),"}}"     
      ) AS date
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,
(SELECT @rownum := 0) r

SQL

Checking query status...