Articles by size

This query is marked as a draft This query has been published by Huji.
SQL

use enwiki_p;
select
  page_len_category,
  count(*) as freq
from (
  select
    case
      when page_len < 1024 then 1
      when page_len >= 1024 and page_len < 2048 then 2
      when page_len >= 2048 and page_len < 3072 then 3
      when page_len >= 3072 and page_len < 4096 then 4
      when page_len >= 4096 and page_len < 5120 then 5
      when page_len >= 5120 and page_len < 6144 then 6
      when page_len >= 6144 and page_len < 7168 then 7
      when page_len >= 7168 and page_len < 8192 then 8
      when page_len >= 8192 and page_len < 9216 then 9
      when page_len >= 9216 and page_len < 10240 then 10
      when page_len >= 10240 and page_len < 11264 then 11
      when page_len >= 11264 and page_len < 12288 then 12
      when page_len >= 12288 and page_len < 13312 then 13
      when page_len >= 13312 and page_len < 14336 then 14
      when page_len >= 14336 and page_len < 15360 then 15
      when page_len >= 15360 and page_len < 16384 then 16
      when page_len >= 16384 and page_len < 17408 then 17
      when page_len >= 17408 and page_len < 18432 then 18
      when page_len >= 18432 and page_len < 19456 then 19
      when page_len >= 19456 and page_len < 20480 then 20
      when page_len >= 20480 and page_len < 21504 then 21
      when page_len >= 21504 and page_len < 22528 then 22
      when page_len >= 22528 and page_len < 23552 then 23
      when page_len >= 23552 and page_len < 24576 then 24
      when page_len >= 24576 and page_len < 25600 then 25
      when page_len >= 25600 and page_len < 26624 then 26
      when page_len >= 26624 and page_len < 27648 then 27
      when page_len >= 27648 and page_len < 28672 then 28
      when page_len >= 28672 and page_len < 29696 then 29
      when page_len >= 29696 and page_len < 30720 then 30
      when page_len >= 30720 and page_len < 31744 then 31
      when page_len >= 31744 and page_len < 32768 then 32
      when page_len >= 32768 and page_len < 33792 then 33
      when page_len >= 33792 and page_len < 34816 then 34
      when page_len >= 34816 and page_len < 35840 then 35
      when page_len >= 35840 and page_len < 36864 then 36
      when page_len >= 36864 and page_len < 37888 then 37
      when page_len >= 37888 and page_len < 38912 then 38
      when page_len >= 38912 and page_len < 39936 then 39
      when page_len >= 39936 and page_len < 40960 then 40
      when page_len >= 40960 and page_len < 41984 then 41
      when page_len >= 41984 and page_len < 43008 then 42
      when page_len >= 43008 and page_len < 44032 then 43
      when page_len >= 44032 and page_len < 45056 then 44
      when page_len >= 45056 and page_len < 46080 then 45
      when page_len >= 46080 and page_len < 47104 then 46
      when page_len >= 47104 and page_len < 48128 then 47
      when page_len >= 48128 and page_len < 49152 then 48
      when page_len >= 49152 and page_len < 50176 then 49
      when page_len >= 50176 and page_len < 51200 then 50
      when page_len >= 51200 and page_len < 52224 then 51
      when page_len >= 52224 and page_len < 53248 then 52
      when page_len >= 53248 and page_len < 54272 then 53
      when page_len >= 54272 and page_len < 55296 then 54
      when page_len >= 55296 and page_len < 56320 then 55
      when page_len >= 56320 and page_len < 57344 then 56
      when page_len >= 57344 and page_len < 58368 then 57
      when page_len >= 58368 and page_len < 59392 then 58
      when page_len >= 59392 and page_len < 60416 then 59
      when page_len >= 60416 and page_len < 61440 then 60
      when page_len >= 61440 and page_len < 62464 then 61
      when page_len >= 62464 and page_len < 63488 then 62
      when page_len >= 63488 and page_len < 64512 then 63
      when page_len >= 64512 and page_len < 65536 then 64
      when page_len >= 65536 and page_len < 66560 then 65
      when page_len >= 66560 and page_len < 67584 then 66
      when page_len >= 67584 and page_len < 68608 then 67
      when page_len >= 68608 and page_len < 69632 then 68
      when page_len >= 69632 and page_len < 70656 then 69
      when page_len >= 70656 and page_len < 71680 then 70
      when page_len >= 71680 and page_len < 72704 then 71
      when page_len >= 72704 and page_len < 73728 then 72
      when page_len >= 73728 and page_len < 74752 then 73
      when page_len >= 74752 and page_len < 75776 then 74
      when page_len >= 75776 and page_len < 76800 then 75
      when page_len >= 76800 and page_len < 77824 then 76
      when page_len >= 77824 and page_len < 78848 then 77
      when page_len >= 78848 and page_len < 79872 then 78
      when page_len >= 79872 and page_len < 80896 then 79
      when page_len >= 80896 and page_len < 81920 then 80
      when page_len >= 81920 and page_len < 82944 then 81
      when page_len >= 82944 and page_len < 83968 then 82
      when page_len >= 83968 and page_len < 84992 then 83
      when page_len >= 84992 and page_len < 86016 then 84
      when page_len >= 86016 and page_len < 87040 then 85
      when page_len >= 87040 and page_len < 88064 then 86
      when page_len >= 88064 and page_len < 89088 then 87
      when page_len >= 89088 and page_len < 90112 then 88
      when page_len >= 90112 and page_len < 91136 then 89
      when page_len >= 91136 and page_len < 92160 then 90
      when page_len >= 92160 and page_len < 93184 then 91
      when page_len >= 93184 and page_len < 94208 then 92
      when page_len >= 94208 and page_len < 95232 then 93
      when page_len >= 95232 and page_len < 96256 then 94
      when page_len >= 96256 and page_len < 97280 then 95
      when page_len >= 97280 and page_len < 98304 then 96
      when page_len >= 98304 and page_len < 99328 then 97
      when page_len >= 99328 and page_len < 100352 then 98
      when page_len >= 100352 and page_len < 101376 then 99
      when page_len >= 102400 and page_len < 103424 then 100
      when page_len >= 103424 and page_len < 104448 then 101
      when page_len >= 104448 and page_len < 105472 then 102
      when page_len >= 105472 and page_len < 106496 then 103
      when page_len >= 106496 and page_len < 107520 then 104
      when page_len >= 107520 and page_len < 108544 then 105
      when page_len >= 108544 and page_len < 109568 then 106
      when page_len >= 109568 and page_len < 110592 then 107
      when page_len >= 110592 and page_len < 111616 then 108
      when page_len >= 111616 and page_len < 112640 then 109
      when page_len >= 112640 and page_len < 113664 then 110
      when page_len >= 113664 and page_len < 114688 then 111
      when page_len >= 114688 and page_len < 115712 then 112
      when page_len >= 115712 and page_len < 116736 then 113
      when page_len >= 116736 and page_len < 117760 then 114
      when page_len >= 117760 and page_len < 118784 then 115
      when page_len >= 118784 and page_len < 119808 then 116
      when page_len >= 119808 and page_len < 120832 then 117
      when page_len >= 120832 and page_len < 121856 then 118
      when page_len >= 121856 and page_len < 122880 then 119
      when page_len >= 122880 and page_len < 123904 then 120
      when page_len >= 123904 and page_len < 124928 then 121
      when page_len >= 124928 and page_len < 125952 then 122
      when page_len >= 125952 and page_len < 126976 then 123
      when page_len >= 126976 and page_len < 128000 then 124
      when page_len >= 128000 and page_len < 129024 then 125
      when page_len >= 129024 and page_len < 130048 then 126
      when page_len >= 130048 and page_len < 131072 then 127
      when page_len >= 131072 and page_len < 132096 then 128
      when page_len >= 132096 and page_len < 133120 then 129
      when page_len >= 133120 and page_len < 134144 then 130
      when page_len >= 134144 and page_len < 135168 then 131
      when page_len >= 135168 and page_len < 136192 then 132
      when page_len >= 136192 and page_len < 137216 then 133
      when page_len >= 137216 and page_len < 138240 then 134
      when page_len >= 138240 and page_len < 139264 then 135
      when page_len >= 139264 and page_len < 140288 then 136
      when page_len >= 140288 and page_len < 141312 then 137
      when page_len >= 141312 and page_len < 142336 then 138
      when page_len >= 142336 and page_len < 143360 then 139
      when page_len >= 143360 and page_len < 144384 then 140
      when page_len >= 144384 and page_len < 145408 then 141
      when page_len >= 145408 and page_len < 146432 then 142
      when page_len >= 146432 and page_len < 147456 then 143
      when page_len >= 147456 and page_len < 148480 then 144
      when page_len >= 148480 and page_len < 149504 then 145
      when page_len >= 149504 and page_len < 150528 then 146
      when page_len >= 150528 and page_len < 151552 then 147
      when page_len >= 151552 and page_len < 152576 then 148
      when page_len >= 152576 and page_len < 153600 then 149
      when page_len >= 153600 and page_len < 154624 then 150
      when page_len >= 154624 and page_len < 155648 then 151
      when page_len >= 155648 and page_len < 156672 then 152
      when page_len >= 156672 and page_len < 157696 then 153
      when page_len >= 157696 and page_len < 158720 then 154
      when page_len >= 158720 and page_len < 159744 then 155
      when page_len >= 159744 and page_len < 160768 then 156
      when page_len >= 160768 and page_len < 161792 then 157
      when page_len >= 161792 and page_len < 162816 then 158
      when page_len >= 162816 and page_len < 163840 then 159
      when page_len >= 163840 and page_len < 164864 then 160
      when page_len >= 164864 and page_len < 165888 then 161
      when page_len >= 165888 and page_len < 166912 then 162
      when page_len >= 166912 and page_len < 167936 then 163
      when page_len >= 167936 and page_len < 168960 then 164
      when page_len >= 168960 and page_len < 169984 then 165
      when page_len >= 169984 and page_len < 171008 then 166
      when page_len >= 171008 and page_len < 172032 then 167
      when page_len >= 172032 and page_len < 173056 then 168
      when page_len >= 173056 and page_len < 174080 then 169
      when page_len >= 174080 and page_len < 175104 then 170
      when page_len >= 175104 and page_len < 176128 then 171
      when page_len >= 176128 and page_len < 177152 then 172
      when page_len >= 177152 and page_len < 178176 then 173
      when page_len >= 178176 and page_len < 179200 then 174
      when page_len >= 179200 and page_len < 180224 then 175
      when page_len >= 180224 and page_len < 181248 then 176
      when page_len >= 181248 and page_len < 182272 then 177
      when page_len >= 182272 and page_len < 183296 then 178
      when page_len >= 183296 and page_len < 184320 then 179
      when page_len >= 184320 and page_len < 185344 then 180
      when page_len >= 185344 and page_len < 186368 then 181
      when page_len >= 186368 and page_len < 187392 then 182
      when page_len >= 187392 and page_len < 188416 then 183
      when page_len >= 188416 and page_len < 189440 then 184
      when page_len >= 189440 and page_len < 190464 then 185
      when page_len >= 190464 and page_len < 191488 then 186
      when page_len >= 191488 and page_len < 192512 then 187
      when page_len >= 192512 and page_len < 193536 then 188
      when page_len >= 193536 and page_len < 194560 then 189
      when page_len >= 194560 and page_len < 195584 then 190
      when page_len >= 195584 and page_len < 196608 then 191
      when page_len >= 196608 and page_len < 197632 then 192
      when page_len >= 197632 and page_len < 198656 then 193
      when page_len >= 198656 and page_len < 199680 then 194
      when page_len >= 199680 and page_len < 200704 then 195
      when page_len >= 200704 and page_len < 201728 then 196
      when page_len >= 201728 and page_len < 202752 then 197
      when page_len >= 202752 and page_len < 203776 then 198
      when page_len >= 203776 and page_len < 204800 then 199
      else 200
    end as page_len_category
  from page
  where
    page_namespace = 0
    and page_is_redirect = 0
    and page_id not in (
      select pp_page
      from page_props
      where pp_propname = 'disambiguation'
    )
) t
group by page_len_category
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...
