select

  CONCAT("Draft:", log_title),

  actor_name,

  log_timestamp,

  rev_timestamp

from

  logging

  join page on page_id = log_page

  join revision_userindex on page_latest = rev_id

  join actor_revision on rev_actor = actor_id

  join user_groups on actor_user = ug_user

where

  log_type = "create"

  and log_action = "create"

  and log_namespace = 118

  and page_namespace = 118

  and page_is_redirect = 0

  and ug_group = "bot"

limit

  500;