List of articles created by Ahonc in ukwiki

SQL

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

SQL

Checking query status...