Untitled query #66869

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

SQL

 select user_name
   from mediawikiwiki.user
  where user_id in
        (select distinct rev_user_id
           from flowdb.flow_workflow
                    inner join
                flowdb.flow_tree_node       on workflow_id = tree_ancestor_id
                    inner join
                flowdb.flow_tree_revision   on tree_descendant_id = tree_rev_descendant_id
                    inner join
                flowdb.flow_revision        on tree_rev_id = rev_id
          where workflow_wiki='mediawikiwiki'
            and workflow_page_id in
                (select page_id
                   from mediawikiwiki.page
                  where page_namespace = 0
                    and page_title like 'Abc'
                )
        )
;

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...