Untitled query #67876

SQL

set group_concat_max_len = 100000;
use jawiki_p;
select
rev_user_text as "利用者名", 
count( tpg.page_title ) as "新着入り回数", 
group_concat( if( rev_len > 3000, concat( "[[", tpg.page_title, "]]" ), concat( "※[[", tpg.page_title, "]]" ) ) separator ', ' ) as "新着記事一覧"
from pagelinks
inner join page as fpg on pl_from = fpg.page_id and fpg.page_namespace = 4
inner join page as tpg on pl_title = tpg.page_title and tpg.page_namespace = 0
inner join revision on tpg.page_id = rev_page and rev_parent_id = 0
where
  pl_from_namespace = 4 and
  pl_namespace = 0 and
  fpg.page_title regexp '月間新記事賞\/[0-9]{4}年[0-9]{1,2}月'
group by rev_user_text
order by count( tpg.page_title ) desc
SQL

Checking query status...
