Loading...   


mysql> SELECT COUNT(slotid) as slot_occurrence_count, slotid FROM inventory GROUP BY slotid;
+-----------------------+----------+
| slot_occurrence_count | slotid   |
+-----------------------+----------+
|                 20850 |        0 |
|                 16569 |        1 |
|                 17204 |        2 |
|                 15912 |        3 |
|                 15017 |        4 |
|                 15990 |        5 |
|                 15782 |        6 |
|                 18503 |        7 |
|                 16566 |        8 |
|                 16867 |        9 |
|                 15805 |       10 |
|                 17918 |       11 |
|                 18403 |       12 |
|                 28093 |       13 |
|                 17200 |       14 |
|                 15417 |       15 |
|                 13119 |       16 |
|                 17110 |       17 |
|                 16996 |       18 |
|                 18983 |       19 |
|                 16139 |       20 |
|                 22090 |       21 |
|                 29664 |       22 |
|                 28561 |       23 |
|                 27369 |       24 |
|                 27721 |       25 |
|                 29235 |       26 |
|                 27375 |       27 |
|                 25818 |       28 |
|                 26084 |       29 |
|                   333 |       30 |
|                 14603 |      251 |
|                 14081 |      252 |
|                 13235 |      253 |
|                 12504 |      254 |
|                 11886 |      255 |
|                 11213 |      256 |
|                 10725 |      257 |
|                 10228 |      258 |
|                  6494 |      259 |
|                  6291 |      260 |
|                 11185 |      261 |
|                 10273 |      262 |
|                  9722 |      263 |
|                  9109 |      264 |
|                  8616 |      265 |
|                  8100 |      266 |
|                  7778 |      267 |
|                  7350 |      268 |
|                  5931 |      269 |
|                  5704 |      270 |
|                  8013 |      271 |
|                  7301 |      272 |
|                  6794 |      273 |
|                  6324 |      274 |
|                  6008 |      275 |
|                  5602 |      276 |
|                  5491 |      277 |
|                  5214 |      278 |
|                  4375 |      279 |
|                  4229 |      280 |
|                  5864 |      281 |
|                  5287 |      282 |
|                  4935 |      283 |
|                  4505 |      284 |
|                  4442 |      285 |
|                  4124 |      286 |
|                  4168 |      287 |
|                  3946 |      288 |
|                  3420 |      289 |
|                  3282 |      290 |
|                 10954 |      291 |
|                  9755 |      292 |
|                  8782 |      293 |
|                  7748 |      294 |
|                  7201 |      295 |
|                  6612 |      296 |
|                  6429 |      297 |
|                  6033 |      298 |
|                  3067 |      299 |
|                  3041 |      300 |
|                  6365 |      301 |
|                  5556 |      302 |
|                  5183 |      303 |
|                  4681 |      304 |
|                  4557 |      305 |
|                  4216 |      306 |
|                  4361 |      307 |
|                  4189 |      308 |
|                  3709 |      309 |
|                  3635 |      310 |
|                  5979 |      311 |
|                  5345 |      312 |
|                  5089 |      313 |
|                  4670 |      314 |
|                  4741 |      315 |
|                  4329 |      316 |
|                  4569 |      317 |
|                  4455 |      318 |
|                  3516 |      319 |
|                  3555 |      320 |
|                  4276 |      321 |
|                  3906 |      322 |
|                  3733 |      323 |
|                  3492 |      324 |
|                  3629 |      325 |
|                  3410 |      326 |
|                  3686 |      327 |
|                  3646 |      328 |
|                  2724 |      329 |
|                  2688 |      330 |
|                     4 |      331 |
|                     3 |      332 |
|                     3 |      333 |
|                     3 |      334 |
|                     3 |      335 |
|                     3 |      336 |
|                     4 |      337 |
|                     4 |      338 |
|                     4 |      339 |
|                     3 |      340 |
|                  7563 |     2000 |
|                  6294 |     2001 |
|                  5678 |     2002 |
|                  5702 |     2003 |
|                  6765 |     2004 |
|                  5785 |     2005 |
|                  5255 |     2006 |
|                  5346 |     2007 |
|                  7098 |     2008 |
|                  6112 |     2009 |
|                  5636 |     2010 |
|                  5878 |     2011 |
|                  6636 |     2012 |
|                  5760 |     2013 |
|                  5503 |     2014 |
|                  5766 |     2015 |
|                  2845 |     2016 |
|                  2515 |     2017 |
|                  2416 |     2018 |
|                  2528 |     2019 |
|                  2684 |     2020 |
|                  2399 |     2021 |
|                  2381 |     2022 |
|                  2561 |     2023 |
|                  3338 |     2031 |
|                  3240 |     2032 |
|                  3172 |     2033 |
|                  3059 |     2034 |
|                  2923 |     2035 |
|                  2808 |     2036 |
|                  2715 |     2037 |
|                  2554 |     2038 |
|                  1654 |     2039 |
|                  1555 |     2040 |
|                  2191 |     2041 |
|                  2093 |     2042 |
|                  2041 |     2043 |
|                  1975 |     2044 |
|                  1863 |     2045 |
|                  1795 |     2046 |
|                  1758 |     2047 |
|                  1674 |     2048 |
|                  1115 |     2049 |
|                  1057 |     2050 |
|                  1716 |     2051 |
|                  1648 |     2052 |
|                  1599 |     2053 |
|                  1517 |     2054 |
|                  1495 |     2055 |
|                  1407 |     2056 |
|                  1399 |     2057 |
|                  1345 |     2058 |
|                   940 |     2059 |
|                   877 |     2060 |
|                  1784 |     2061 |
|                  1703 |     2062 |
|                  1636 |     2063 |
|                  1571 |     2064 |
|                  1525 |     2065 |
|                  1464 |     2066 |
|                  1409 |     2067 |
|                  1384 |     2068 |
|                   949 |     2069 |
|                   921 |     2070 |
|                  2289 |     2071 |
|                  2190 |     2072 |
|                  2099 |     2073 |
|                  1988 |     2074 |
|                  1901 |     2075 |
|                  1790 |     2076 |
|                  1745 |     2077 |
|                  1626 |     2078 |
|                  1070 |     2079 |
|                  1019 |     2080 |
|                  1501 |     2081 |
|                  1438 |     2082 |
|                  1403 |     2083 |
|                  1345 |     2084 |
|                  1271 |     2085 |
|                  1222 |     2086 |
|                  1216 |     2087 |
|                  1124 |     2088 |
|                   755 |     2089 |
|                   721 |     2090 |
|                  1342 |     2091 |
|                  1314 |     2092 |
|                  1255 |     2093 |
|                  1179 |     2094 |
|                  1136 |     2095 |
|                  1083 |     2096 |
|                  1089 |     2097 |
|                  1024 |     2098 |
|                   721 |     2099 |
|                   696 |     2100 |
|                  1477 |     2101 |
|                  1393 |     2102 |
|                  1348 |     2103 |
|                  1325 |     2104 |
|                  1284 |     2105 |
|                  1239 |     2106 |
|                  1244 |     2107 |
|                  1189 |     2108 |
|                   841 |     2109 |
|                   805 |     2110 |
|                  2316 |     2111 |
|                  2215 |     2112 |
|                  2142 |     2113 |
|                  2041 |     2114 |
|                  1942 |     2115 |
|                  1858 |     2116 |
|                  1827 |     2117 |
|                  1733 |     2118 |
|                  1123 |     2119 |
|                  1069 |     2120 |
|                  1589 |     2121 |
|                  1516 |     2122 |
|                  1457 |     2123 |
|                  1410 |     2124 |
|                  1313 |     2125 |
|                  1274 |     2126 |
|                  1236 |     2127 |
|                  1191 |     2128 |
|                   796 |     2129 |
|                   757 |     2130 |
|                  1383 |     2131 |
|                  1319 |     2132 |
|                  1287 |     2133 |
|                  1206 |     2134 |
|                  1128 |     2135 |
|                  1093 |     2136 |
|                  1093 |     2137 |
|                  1026 |     2138 |
|                   707 |     2139 |
|                   657 |     2140 |
|                  1663 |     2141 |
|                  1567 |     2142 |
|                  1533 |     2143 |
|                  1456 |     2144 |
|                  1428 |     2145 |
|                  1397 |     2146 |
|                  1365 |     2147 |
|                  1320 |     2148 |
|                   919 |     2149 |
|                   889 |     2150 |
|                  1989 |     2151 |
|                  1883 |     2152 |
|                  1812 |     2153 |
|                  1741 |     2154 |
|                  1618 |     2155 |
|                  1566 |     2156 |
|                  1521 |     2157 |
|                  1437 |     2158 |
|                   960 |     2159 |
|                   927 |     2160 |
|                  1418 |     2161 |
|                  1334 |     2162 |
|                  1286 |     2163 |
|                  1217 |     2164 |
|                  1178 |     2165 |
|                  1129 |     2166 |
|                  1069 |     2167 |
|                  1041 |     2168 |
|                   691 |     2169 |
|                   670 |     2170 |
|                  1358 |     2171 |
|                  1284 |     2172 |
|                  1251 |     2173 |
|                  1186 |     2174 |
|                  1151 |     2175 |
|                  1106 |     2176 |
|                  1088 |     2177 |
|                  1075 |     2178 |
|                   705 |     2179 |
|                   684 |     2180 |
|                  1748 |     2181 |
|                  1673 |     2182 |
|                  1647 |     2183 |
|                  1575 |     2184 |
|                  1507 |     2185 |
|                  1445 |     2186 |
|                  1449 |     2187 |
|                  1373 |     2188 |
|                  1013 |     2189 |
|                   960 |     2190 |
|                   931 |     2191 |
|                   884 |     2192 |
|                   839 |     2193 |
|                   799 |     2194 |
|                   758 |     2195 |
|                   714 |     2196 |
|                   683 |     2197 |
|                   650 |     2198 |
|                   393 |     2199 |
|                   379 |     2200 |
|                   705 |     2201 |
|                   656 |     2202 |
|                   621 |     2203 |
|                   614 |     2204 |
|                   560 |     2205 |
|                   530 |     2206 |
|                   510 |     2207 |
|                   474 |     2208 |
|                   296 |     2209 |
|                   283 |     2210 |
|                   677 |     2211 |
|                   634 |     2212 |
|                   610 |     2213 |
|                   582 |     2214 |
|                   552 |     2215 |
|                   534 |     2216 |
|                   539 |     2217 |
|                   511 |     2218 |
|                   313 |     2219 |
|                   303 |     2220 |
|                   754 |     2221 |
|                   719 |     2222 |
|                   690 |     2223 |
|                   669 |     2224 |
|                   634 |     2225 |
|                   589 |     2226 |
|                   607 |     2227 |
|                   574 |     2228 |
|                   374 |     2229 |
|                   362 |     2230 |
|                   852 |     2231 |
|                   811 |     2232 |
|                   763 |     2233 |
|                   723 |     2234 |
|                   660 |     2235 |
|                   653 |     2236 |
|                   624 |     2237 |
|                   601 |     2238 |
|                   360 |     2239 |
|                   353 |     2240 |
|                   655 |     2241 |
|                   623 |     2242 |
|                   601 |     2243 |
|                   540 |     2244 |
|                   520 |     2245 |
|                   493 |     2246 |
|                   454 |     2247 |
|                   444 |     2248 |
|                   265 |     2249 |
|                   264 |     2250 |
|                   679 |     2251 |
|                   634 |     2252 |
|                   602 |     2253 |
|                   584 |     2254 |
|                   546 |     2255 |
|                   516 |     2256 |
|                   511 |     2257 |
|                   492 |     2258 |
|                   294 |     2259 |
|                   294 |     2260 |
|                   815 |     2261 |
|                   801 |     2262 |
|                   766 |     2263 |
|                   725 |     2264 |
|                   667 |     2265 |
|                   650 |     2266 |
|                   627 |     2267 |
|                   609 |     2268 |
|                   392 |     2269 |
|                   374 |     2270 |
|                   123 |     8001 |
|                    94 |     8002 |
|                    63 |     8003 |
|                    55 |     8004 |
|                    43 |     8005 |
|                    38 |     8006 |
|                    34 |     8007 |
|                    30 |     8008 |
|                    20 |     8009 |
|                    16 |     8010 |
|                     9 |     8011 |
|                     8 |     8012 |
|                     8 |     8013 |
|                     7 |     8014 |
|                     5 |     8015 |
|                     5 |     8016 |
|                     4 |     8017 |
|                     4 |     8018 |
|                     3 |     8019 |
|                     3 |     8020 |
|                     3 |     8021 |
|                     1 |     8022 |
|                     1 |     8023 |
|                     1 |     8024 |
|                     1 |     8025 |
|                     1 |     8026 |
|                     1 |     8027 |
|                     1 |     8028 |
|                     1 |     8029 |
|                     1 |     8030 |
|                     1 |     8031 |
|                     1 |     8032 |
|                     1 |     8033 |
|                     1 |     8034 |
|                     1 |     8035 |
|                     1 |     8036 |
|                     1 |     8037 |
|                     1 |     8038 |
|                     1 |     8039 |
|                     1 |     8040 |
|                     1 |     8041 |
|                     1 |     8042 |
|                     1 |     8043 |
|                     1 |     8044 |
|                     1 |     8045 |
|                     1 |     8046 |
|                     1 |     8047 |
|                     1 |     8048 |
|                     1 |     8049 |
|                     1 |     8050 |
|                     1 |     8051 |
|                     1 |     8052 |
|                     1 |     8053 |
|                     1 |     8054 |
|                     1 |     8055 |
|                     1 |     8056 |
|                     1 |     8057 |
|                     1 |     8058 |
|                     1 |     9000 |
|                     1 |     9001 |
|                     1 |     9002 |
|                     1 |     9003 |
|                     1 |     9004 |
|                     1 |     9005 |
|                     1 |     9006 |
|                     1 |     9007 |
|                     1 |     9008 |
|                     1 |     9009 |
|                     1 |     9010 |
|                     1 |     9011 |
|                     1 |     9012 |
|                     1 |     9013 |
|                     1 |     9014 |
|                     1 |     9015 |
|                     1 |     9016 |
|                     1 |     9017 |
|                     1 |     9018 |
|                     1 |     9019 |
|                     1 |     9020 |
|                     1 |     9021 |
|                     1 |     9022 |
|                     1 |     9023 |
|                     1 |     9024 |
|                     1 |     9025 |
|                     1 |     9026 |
|                     1 |     9027 |
|                     1 |     9028 |
|                     1 |     9029 |
|                     1 |     9030 |
|                     1 |     9031 |
|                     1 |     9032 |
|                     1 |     9033 |
|                     1 |     9034 |
|                     1 |     9035 |
|                     1 |     9036 |
|                     1 |     9037 |
|                     1 |     9038 |
|                     1 |     9039 |
|                     1 |     9040 |
|                     1 |     9041 |
|                     1 |     9042 |
|                     1 |     9043 |
|                     1 |     9044 |
|                     1 |     9045 |
|                     1 |     9046 |
|                     1 |     9047 |
|                     1 |     9048 |
|                     1 |     9049 |
|                     1 |     9050 |
|                     1 |     9051 |
|                     1 |     9052 |
|                     1 |     9053 |
|                     1 |     9054 |
|                     1 |     9055 |
|                     1 |     9056 |
|                     1 |     9057 |
|                     1 |     9058 |
|                     1 |     9059 |
|                     1 |     9060 |
|                     1 |     9061 |
|                     1 |     9062 |
|                     1 |     9063 |
|                     1 |     9064 |
|                     1 |     9065 |
|                     1 |     9066 |
|                     1 |     9067 |
|                     1 |     9068 |
|                     1 |     9069 |
|                     1 |     9070 |
|                     1 |     9071 |
|                     1 |     9072 |
|                     1 |     9073 |
|                     1 |     9074 |
|                     1 |     9075 |
|                     1 |     9076 |
|                     1 |     9077 |
|                     1 |     9078 |
|                     1 |     9079 |
|                     1 |     9080 |
|                     1 |     9081 |
|                     1 |     9082 |
|                     1 |     9083 |
|                     1 |     9084 |
|                     1 |     9085 |
|                     1 |     9086 |
|                     1 |     9087 |
|                     1 |     9088 |
|                     1 |     9089 |
|                     1 |     9090 |
|                     1 |     9091 |
|                     1 |     9092 |
|                     1 |     9093 |
|                     1 |     9094 |
|                     1 |     9095 |
|                     1 |     9096 |
|                     1 |     9097 |
|                     1 |     9098 |
|                     1 |     9099 |
|                     1 |     9100 |
|                  5501 |     9999 |
|                     3 | 16777215 |
+-----------------------+----------+
546 rows in set

Raw Paste Data