Articles created by User:Shyamal

SQL

SELECT @rownum1 := @rownum1 + 1 AS 'No.', page_id, pagename, page_len, date FROM (
SELECT @rownum := @rownum + 1 AS 'No.', page_id, rev_id, date, page_len, pagename
FROM (
SELECT 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    
JOIN actor ON rev_actor = actor_id AND actor_name = 'Shyamal'
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) tt,
(SELECT @rownum1 := 0) r
ORDER BY rev_id ASC
SQL

Checking query status...
