Untitled query #52842

This query is marked as a draft This query has been published by Huji.

SQL

select
  user_azb.user_name,
  user_azb.user_editcount,
  actor.actor_id,
  logging_userindex.log_timestamp,
  user_azb.*
from azbwiki_p.user user_azb
join fawiki_p.user user_fa
  on user_azb.user_name = user_fa.user_name
join fawiki_p.actor
  on user_fa.user_id = actor.actor_user
join fawiki_p.logging_userindex
  on log_actor = actor_id
  and log_type = 'newusers'
  and log_action = 'autocreate'
where
  user_azb.user_name = 'Sulduzlu.Hadi'
  and user_azb.user_editcount > 1
  and log_timestamp > '20210101000000'

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...