ErogameScapeアクティブユーザー一覧(500以上降順）90日以内の更新者の実行結果

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

SQLの説明

検索結果

uidtokuten_counttourokubi_mintourokubi_max
asteryukari44362018-03-07 04:26:31.718688+092025-12-27 03:02:27.820514+09
7642126992004-12-28 22:54:48.025152+092025-12-21 09:00:11.892032+09
narue224492008-05-30 10:10:33.402413+092025-11-07 12:16:48.301157+09
painsal22902014-01-26 19:01:14.610323+092025-11-09 11:56:46.028647+09
yyyy18052013-04-02 05:22:14.096491+092025-12-28 21:28:19.650973+09
Ryuke15582005-11-04 03:38:30.539227+092025-11-09 21:03:11.545526+09
キッファ15282012-02-13 19:41:23.074233+092025-12-13 13:03:15.162437+09
sadon13202022-06-02 21:30:39.896728+092025-12-09 09:51:20.570751+09
ウメサンド12132009-11-03 22:46:57.195331+092025-12-04 16:52:17.095722+09
sera_11772013-05-09 21:50:21.283318+092025-10-17 22:42:34.586034+09
kure333611172021-11-30 13:00:48.88083+092025-12-20 14:28:37.793288+09
kurage10972005-11-02 02:02:10.014006+092025-11-03 07:33:42.828647+09
Atora10872005-12-07 05:31:34.499972+092025-12-13 20:20:11.074315+09
skzk_u_chan10642019-03-07 16:43:12.635729+092025-12-09 01:47:13.603575+09
oyaimin10482019-03-13 01:45:47.497619+092025-12-25 19:44:24.512612+09
めいせい10042011-10-21 22:55:26.471057+092025-11-03 12:34:47.470492+09
Toki10002022-05-03 07:01:05.557347+092025-10-07 20:12:58.588236+09
（光）エロゲの罪9982014-12-29 01:30:37.078385+092025-11-17 23:53:02.543613+09
shun-shun9942018-07-08 15:40:26.567044+092025-12-24 00:19:21.775832+09
shiki21259282022-06-21 10:20:58.247487+092025-10-04 14:32:29.294111+09
merunonia8772014-10-03 23:27:43.073716+092025-12-24 23:52:38.999459+09
lifefinish8752014-10-25 22:05:34.937807+092025-11-28 19:43:36.968001+09
eroger_t8252016-08-12 03:06:41.073719+092025-10-13 20:25:03.610574+09
kaito0078192014-11-25 14:58:16.858176+092025-12-13 14:12:52.899577+09
riko_misaki7922025-12-19 05:58:50.570406+092025-12-19 05:58:50.570406+09
sts020837262005-11-25 22:18:31.653956+092025-12-23 00:47:33.27983+09
MGN7132011-06-19 23:07:30.059563+092025-11-30 22:01:19.06664+09
qntdbhjutg4766792022-04-06 15:23:05.044835+092025-12-28 20:41:30.870615+09
fired-fish6512006-02-13 17:20:37.301831+092025-11-24 02:55:33.091936+09
moai4566442020-05-30 19:04:02.209349+092025-12-20 00:49:46.942727+09
morningstar49896142010-10-01 06:08:13.162769+092025-11-16 21:27:25.01809+09
November136082018-09-01 20:26:01.343389+092025-11-28 22:26:04.136028+09
adatidaikazokumk25562018-04-09 08:42:23.935952+092025-12-22 02:05:31.0618+09
ろーとす5382012-02-04 01:53:02.052475+092025-12-11 23:00:33.474041+09
lievreman5292014-09-28 18:00:41.742597+092025-10-28 23:10:38.49931+09
sin11275212022-04-18 01:21:54.771502+092025-12-03 21:03:02.976858+09
fee5032002-12-31 19:54:53.479006+092025-12-05 04:37:32.310359+09

実行したSQL

      SELECT uid, tokuten_count, tourokubi_min, tourokubi_max
FROM userreview_toukei_table
WHERE tourokubi_max >= current_date - 90
AND tokuten_count >= 500
ORDER BY tokuten_count DESC
表紙へ
　ひろいん
　egamescape @ gmail.com