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 /*rrevision r,*/ page p, logging l, actor, user /*, categorylinks c, actor a, logging l */
WHERE user_name = actor_name
/* 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_page = p.page_id
AND  l.log_action = "approve-i"
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...
