trwiki:Articles created by bots

SQL

USE trwiki_p;
/*SELECT CONCAT('# [[', page_title ,']]') AS page_title, rev_timestamp, actor_name, ug_group, page_len
FROM page, revision_userindex, user_groups, actor_revision
WHERE rev_page = page_id
AND actor_id = rev_actor
AND ug_user = rev_actor
AND rev_parent_id = 0
AND page_namespace = 0
AND page_is_redirect = 0
AND ug_group LIKE '%bot%'
ORDER BY rev_timestamp;*/

SELECT CONCAT(page_title) AS page,
       CONCAT('[[Special:Diff/',rev_id,']]') AS diff,
       DATE_FORMAT(rev_timestamp, '%Y-%m-%d %H:%i:%s') AS timestamp,
       actor_name,
       comment_text
FROM revision_userindex
  JOIN actor_revision ON rev_actor = actor_id
  JOIN page ON page_id = rev_page
  JOIN comment_revision ON rev_comment_id = comment_id
  JOIN user_groups ON ug_user = rev_actor AND ug_group LIKE '%bot%'
WHERE
  page_namespace = 0
  AND page_is_redirect = 0
  AND rev_parent_id = 0
  LIMIT 1000;
SQL

Checking query status...
