2015年のjawikiにおける感謝ランキング（贈られた人数）

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

SQL

use jawiki_p;
select lli2.贈られた利用者, count(lli2.贈った利用者) as 感謝人数
from(
select distinct lli.log_title as 贈られた利用者, lli.log_user_text as 贈った利用者
from logging_logindex as lli
where lli.log_type = "thanks" and (lli.log_timestamp between 20141231150000 and 20151231145959)
) as lli2
group by lli2.贈られた利用者
order by count(lli2.贈った利用者) desc
limit 30

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