Articles created by User:Shyamal

SQL

USE enwiki;
/* SELECT COUNT (p.page_id) FROM revision r, page p 
WHERE r.rev_parent_id = 0 
AND p.page_namespace = 0 
AND p.page_is_redirect = 0 
AND r.rev_page = p.page_id 
AND r.rev_actor = 4193345;
*/

SELECT CONCAT("# [[",p.page_title,"]]"), actor_name,/*r.rev_timestamp,*/ l.log_action, l.log_timestamp FROM revision r, page p, logging l, actor, user /*, categorylinks c, actor a, logging l */
WHERE user_name = actor_name
AND r.rev_parent_id = 0 
AND p.page_namespace = 0 
AND p.page_is_redirect = 0 
AND r.rev_page = p.page_id
AND l.log_actor = actor_id
AND log_action = "create" 
AND actor_id = 5798
#AND r.rev_actor = 44908
#ORDER BY p.page_title
SQL

Checking query status...
