感想文字数トップ100の実行結果

→ このSQLをお気に入りに登録

SQLの説明

検索結果

uidsumcountavg
マルセル241331912419462.250000000000
asteryukari179492011751527.5914893617021277
7642115323372332657.0913379073756432
merunonia14473763653965.4136986301369863
amaginoboru14466705762511.5798611111111111
近親交配で孕ませ隊12839153503668.3285714285714286
houtengageki12734664332941.0300230946882217
oldreaves12601701478572.5850340136054422
shiratori10972296816135.720588235294
komaichi10301222933515.7747440273037543
Predawnvagabond10168103792682.8759894459102902
Lumis.Eterne9655824582108.2576419213973799
えび9372644911908.8879837067209776
xianxian9092655191751.9556840077071291
chiraurass8654211654088.812500000000
soulfeeler3168488804419292.727272727273
t28290661804605.9222222222222222
fee7848873912007.3836317135549872
painsal7699322290336.2148471615720524
sayura6986313472013.3458213256484150
gripe6739611624160.2530864197530864
huli-ria6590625711562.491228070175
cyokin10w6496652182980.1146788990825688
isumi5925704111441.7761557177615572
Planador579240747827.5675675675675676
bichiguso5706775231091.1606118546845124
latte5545233714987.108108108108
HARIBO5539382122612.9150943396226415
haremlove5337881084942.4814814814814815
tkkt5337391872854.2192513368983957
Accord43125121452492056.8072289156626506
Sek84834824123215075.375000000000
Atora4824091752756.6228571428571429
Medotsu4669043241441.0617283950617284
Weather　report4650183081509.7987012987012987
dov460004627419.4193548387096774
Peetaro4594531283589.4765625000000000
imota4593502082208.4134615384615385
vostok4587322002293.6600000000000000
OYOYO4517721153928.4521739130434783
eringi7854439340617202.2950819672131148
G-hunter4271863061396.0326797385620915
MGN425753630675.7984126984126984
boningen4214822052056.0097560975609756
GENKImorimori403774498240.2857142857142857
nezumo389090983970.3061224489795918
ぱぴぷ～ぺん3809192813604.250000000000
peaceful3807452171754.5852534562211982
kabugiko375500461814.5336225596529284
meroron3687582971241.6094276094276094
カラス3544421542301.5714285714285714
くるくす3527421153067.3217391304347826
野菜炒め3508122871222.3414634146341463
比翼れんり3452053251062.1692307692307692
sts02083344613597577.2412060301507538
morufa3434301741973.7356321839080460
MusthaveBGV&HSE3368271292611.0620155038759690
broadsnow3266542451333.2816326530612245
una08325820774231.4285714285714286
4D3249331552096.3419354838709677
oku_bswa3178101082942.6851851851851852
97913058361142682.7719298245614035
アナトール301136783860.7179487179487179
めいせい2958531891565.3597883597883598
4側294702329209.4375000000000000
SakuRambo_son2922982241304.9017857142857143
dr.tak290196330879.3818181818181818
minority287068340844.3176470588235294
lein27092835431212343.3305785123966942
kenken12312820811072636.2710280373831776
リオン2816241501877.4933333333333333
isoiso271016962823.0833333333333333
saphire2708191132396.6283185840707965
toto7122688331971364.6345177664974619
nanachan2682731282095.8828125000000000
kaza-hana267213793382.4430379746835443
残響262641279727.4444444444444444
gggrrr258973912845.8571428571428571
ACiD8926251869309815.1100323624595469
a103net2514871082328.5833333333333333
no-att2496081371821.9562043795620438
racernassy476248126653817.3230769230769231
ひきにく2415671082236.7314814814814815
KY2388691441658.8125000000000000
November132373772251055.0088888888888889
totetoteto236219703374.5571428571428571
kei10042360711981192.2777777777777778
minoru235014241975.1618257261410788
Tyrant233102375621.6053333333333333
violins2324861351722.1185185185185185
s0meok230651544271.3148148148148148
lievreman226825229990.5021834061135371
twilight222904404551.7425742574257426
bakabakamanko2227761151937.1826086956521739
downer221703972285.5979381443298969
trump2182402111034.3127962085308057
gon2179032061057.7815533980582524
scorpion_tail216398489442.5316973415132924
plantagenet213116912341.9340659340659341
ogrefantome2126481741222.1149425287356322

実行したSQL

      SELECT uid, SUM(LENGTH(memo)), COUNT(*), AVG(LENGTH(memo))
  FROM userreview WHERE memo IS NOT NULL
GROUP BY uid ORDER BY SUM(LENGTH(memo)) DESC LIMIT 100
表紙へ
　ひろいん
　egamescape @ gmail.com