jawikiで編集した利用者の人数

SQL

use jawiki_p;
select
count( case when user_editcount = 0 then 1 else null end ) as "0",
count( case when user_editcount >= 1 then 1 else null end ) as "1",
count( case when user_editcount >= 2 then 1 else null end ) as "2",
count( case when user_editcount >= 3 then 1 else null end ) as "3",
count( case when user_editcount >= 4 then 1 else null end ) as "4",
count( case when user_editcount >= 5 then 1 else null end ) as "5",

count( case when user_editcount >= 10 then 1 else null end ) as "10",
count( case when user_editcount >= 20 then 1 else null end ) as "20",
count( case when user_editcount >= 30 then 1 else null end ) as "30",
count( case when user_editcount >= 40 then 1 else null end ) as "40",
count( case when user_editcount >= 50 then 1 else null end ) as "50",

count( case when user_editcount >= 100 then 1 else null end ) as "100",
count( case when user_editcount >= 200 then 1 else null end ) as "200",
count( case when user_editcount >= 300 then 1 else null end ) as "300",
count( case when user_editcount >= 400 then 1 else null end ) as "400",
count( case when user_editcount >= 500 then 1 else null end ) as "500",

count( case when user_editcount >= 1000 then 1 else null end ) as "1000",
count( case when user_editcount >= 2000 then 1 else null end ) as "2000",
count( case when user_editcount >= 3000 then 1 else null end ) as "3000",
count( case when user_editcount >= 4000 then 1 else null end ) as "4000",
count( case when user_editcount >= 5000 then 1 else null end ) as "5000",

count( case when user_editcount >= 10000 then 1 else null end ) as "10000",
count( case when user_editcount >= 20000 then 1 else null end ) as "20000",
count( case when user_editcount >= 30000 then 1 else null end ) as "30000",
count( case when user_editcount >= 40000 then 1 else null end ) as "40000",
count( case when user_editcount >= 50000 then 1 else null end ) as "50000"

from user
SQL

Checking query status...
