Test query - Quarry

SQL

use fawiki_p;
select distinct concat("[https://fa.wikipedia.org/wiki/ویژه:مشارکت‌ها/", actor_name, " ", actor_name, "]") as User, concat("[[بحث:", page_title, "]]") as Example, count(comment_text) as Counter
from actor
join revision
on rev_actor = actor_id
join comment
on rev_comment_id = comment_id
join page
on page_id = rev_page
where page_namespace = 1
and comment_text = "صفحه‌ای تازه حاوی «{{رتب}} {{بصب}}» ایجاد کرد"
group by actor_name
having Counter > 3
order by Counter desc;
SQL

Checking query status...
