Fork of
Articles by size
by Huji
This query is marked as a draft
This query has been published
by Yamaha5.
SQL
AخA
use dewiki_p;select page_len_category, count(*) as freqfrom ( 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' )) tgroup 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.
All SQL code is licensed under CC0 License.