2020 successful GA discussions and their contributors

Fork of 2020 successful GA discussions and their contributors by 4nn1l2

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

SQL

use fawiki_p;
select
  page_title,
  page_random,
  group_concat(distinct actor_name) as referee
from (page
      left join revision on rev_page = page_id)
      left join actor on actor_id = rev_actor
      and actor_name in (
    '4nn1l2'
  )
where
  page_title in (
    'گزیدن مقاله‌های خوب/بیات اصفهان'
  )
  and page_namespace = 4
group by
  page_title,
  page_random
order by page_random

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