IPRangeByCountry-02

mysql> select CountryCode, CountryName, COUNT(*) as RangeCount from IPRangeByCountry group by CountryCode order by CountryName ASC, FromInt ASC;
+-------------+----------------------------------------------+------------+
| CountryCode | CountryName                                  | RangeCount |
+-------------+----------------------------------------------+------------+
| AF          | Afghanistan                                  |        262 |
| AX          | Aland Islands                                |        145 |
| AL          | Albania                                      |        187 |
| DZ          | Algeria                                      |         72 |
| AS          | American Samoa                               |         35 |
| AD          | Andorra                                      |         24 |
| AO          | Angola                                       |        129 |
| AI          | Anguilla                                     |         19 |
| A1          | Anonymous Proxy       <== HWG..              |         75 |
| AQ          | Antarctica                                   |         30 |
| AG          | Antigua and Barbuda                          |        112 |
| AR          | Argentina                                    |        779 |
| AM          | Armenia                                      |         97 |
| AW          | Aruba                                        |         27 |
| AP          | Asia/Pacific Region                          |        202 |
| AU          | Australia                                    |       3086 |
| AT          | Austria                                      |       1798 |
| AZ          | Azerbaijan                                   |         76 |
| BS          | Bahamas                                      |         51 |
| BH          | Bahrain                                      |         95 |
| BD          | Bangladesh                                   |        362 |
| BB          | Barbados                                     |         88 |
| BY          | Belarus                                      |         99 |
| BE          | Belgium                                      |       4272 |
| BZ          | Belize                                       |        102 |
| BJ          | Benin                                        |         36 |
| BM          | Bermuda                                      |         82 |
| BT          | Bhutan                                       |         10 |
| BO          | Bolivia                                      |         79 |
| BA          | Bosnia and Herzegovina                       |        160 |
| BW          | Botswana                                     |         36 |
| BV          | Bouvet Island                                |         16 |
| BR          | Brazil                                       |        648 |
| IO          | British Indian Ocean Territory               |          9 |
| BN          | Brunei Darussalam                            |         19 |
| BG          | Bulgaria                                     |        567 |
| BF          | Burkina Faso                                 |         31 |
| BI          | Burundi                                      |         20 |
| KH          | Cambodia                                     |         91 |
| CM          | Cameroon                                     |         69 |
| CA          | Canada                                       |       8057 |
| CV          | Cape Verde                                   |         12 |
| KY          | Cayman Islands                               |         32 |
| CF          | Central African Republic                     |         15 |
| TD          | Chad                                         |         29 |
| CL          | Chile                                        |        427 |
| CN          | China                                        |       1608 |
| CX          | Christmas Island                             |          1 |
| CC          | Cocos (Keeling) Islands                      |          1 |
| CO          | Colombia                                     |        500 |
| KM          | Comoros                                      |          6 |
| CG          | Congo                                        |         41 |
| CD          | Congo, The Democratic Republic of the        |        202 |
| CK          | Cook Islands                                 |          6 |
| CR          | Costa Rica                                   |        138 |
| CI          | Cote D'Ivoire                                |         53 |
| HR          | Croatia                                      |        218 |
| CU          | Cuba                                         |         19 |
| CY          | Cyprus                                       |        311 |
| CZ          | Czech Republic                               |       1088 |
| DK          | Denmark                                      |       1239 |
| DJ          | Djibouti                                     |          9 |
| DM          | Dominica                                     |         25 |
| DO          | Dominican Republic                           |        102 |
| EC          | Ecuador                                      |        204 |
| EG          | Egypt                                        |        272 |
| SV          | El Salvador                                  |         91 |
| GQ          | Equatorial Guinea                            |         24 |
| ER          | Eritrea                                      |         14 |
| EE          | Estonia                                      |        234 |
| ET          | Ethiopia                                     |         16 |
| EU          | Europe                                       |       3221 |
| FK          | Falkland Islands (Malvinas)                  |          5 |
| FO          | Faroe Islands                                |         16 |
| FJ          | Fiji                                         |         24 |
| FI          | Finland                                      |       1165 |
| FR          | France                                       |       8085 |
| GF          | French Guiana                                |         16 |
| PF          | French Polynesia                             |         13 |
| TF          | French Southern Territories                  |          1 |
| GA          | Gabon                                        |         49 |
| GM          | Gambia                                       |         11 |
| GE          | Georgia                                      |        129 |
| DE          | Germany                                      |      12737 |
| GH          | Ghana                                        |        147 |
| GI          | Gibraltar                                    |         71 |
| GR          | Greece                                       |        632 |
| GL          | Greenland                                    |         13 |
| GD          | Grenada                                      |         33 |
| GP          | Guadeloupe                                   |         52 |
| GU          | Guam                                         |         39 |
| GT          | Guatemala                                    |         97 |
| GG          | Guernsey                                     |         93 |
| GN          | Guinea                                       |         56 |
| GW          | Guinea-Bissau                                |          5 |
| GY          | Guyana                                       |         13 |
| HT          | Haiti                                        |         36 |
| VA          | Holy See (Vatican City State)                |         24 |
| HN          | Honduras                                     |        102 |
| HK          | Hong Kong                                    |       1190 |
| HU          | Hungary                                      |        587 |
| IS          | Iceland                                      |        109 |
| IN          | India                                        |       1822 |
| ID          | Indonesia                                    |        877 |
| IR          | Iran, Islamic Republic of                    |        439 |
| IQ          | Iraq                                         |        582 |
| IE          | Ireland                                      |       1428 |
| IM          | Isle of Man                                  |        131 |
| IL          | Israel                                       |        776 |
| IT          | Italy                                        |       3569 |
| JM          | Jamaica                                      |         92 |
| JP          | Japan                                        |       1873 |
| JE          | Jersey                                       |        157 |
| JO          | Jordan                                       |        115 |
| KZ          | Kazakhstan                                   |        217 |
| KE          | Kenya                                        |        177 |
| KI          | Kiribati                                     |          3 |
| KP          | Korea, Democratic People's Republic of       |          4 |
| KR          | Korea, Republic of                           |        703 |
| KW          | Kuwait                                       |        190 |
| KG          | Kyrgyzstan                                   |         55 |
| LA          | Lao People's Democratic Republic             |         17 |
| LV          | Latvia                                       |        347 |
| LB          | Lebanon                                      |        241 |
| LS          | Lesotho                                      |         15 |
| LR          | Liberia                                      |         85 |
| LY          | Libyan Arab Jamahiriya                       |        118 |
| LI          | Liechtenstein                                |         89 |
| LT          | Lithuania                                    |        520 |
| LU          | Luxembourg                                   |        410 |
| MO          | Macau                                        |         31 |
| MK          | Macedonia                                    |         99 |
| MG          | Madagascar                                   |         24 |
| MW          | Malawi                                       |         48 |
| MY          | Malaysia                                     |        550 |
| MV          | Maldives                                     |         22 |
| ML          | Mali                                         |         24 |
| MT          | Malta                                        |        136 |
| MH          | Marshall Islands                             |          9 |
| MQ          | Martinique                                   |         39 |
| MR          | Mauritania                                   |         25 |
| MU          | Mauritius                                    |         51 |
| YT          | Mayotte                                      |          4 |
| MX          | Mexico                                       |        620 |
| FM          | Micronesia, Federated States of              |          8 |
| MD          | Moldova, Republic of                         |        148 |
| MC          | Monaco                                       |         46 |
| MN          | Mongolia                                     |         61 |
| ME          | Montenegro                                   |         67 |
| MS          | Montserrat                                   |         16 |
| MA          | Morocco                                      |        126 |
| MZ          | Mozambique                                   |         49 |
| MM          | Myanmar                                      |         10 |
| NA          | Namibia                                      |        178 |
| NR          | Nauru                                        |          3 |
| NP          | Nepal                                        |         73 |
| NL          | Netherlands                                  |       8150 |
| AN          | Netherlands Antilles                         |         90 |
| NC          | New Caledonia                                |         35 |
| NZ          | New Zealand                                  |        693 |
| NI          | Nicaragua                                    |         80 |
| NE          | Niger                                        |         44 |
| NG          | Nigeria                                      |       1023 |
| NU          | Niue                                         |          3 |
| NF          | Norfolk Island                               |          4 |
| MP          | Northern Mariana Islands                     |          7 |
| NO          | Norway                                       |       1269 |
| OM          | Oman                                         |         37 |
| PK          | Pakistan                                     |        303 |
| PW          | Palau                                        |          4 |
| PS          | Palestinian Territory, Occupied              |         59 |
| PA          | Panama                                       |        197 |
| PG          | Papua New Guinea                             |         26 |
| PY          | Paraguay                                     |         47 |
| PE          | Peru                                         |        150 |
| PH          | Philippines                                  |        496 |
| PN          | Pitcairn Islands                             |          1 |
| PL          | Poland                                       |       4076 |
| PT          | Portugal                                     |        864 |
| PR          | Puerto Rico                                  |        868 |
| QA          | Qatar                                        |         48 |
| RE          | Reunion                                      |          7 |
| RO          | Romania                                      |       1201 |
| RU          | Russian Federation                           |       5065 |
| RW          | Rwanda                                       |         18 |
| SH          | Saint Helena                                 |          1 |
| KN          | Saint Kitts and Nevis                        |         61 |
| LC          | Saint Lucia                                  |         29 |
| MF          | Saint Martin                                 |          7 |
| PM          | Saint Pierre and Miquelon                    |          4 |
| VC          | Saint Vincent and the Grenadines             |         29 |
| WS          | Samoa                                        |         24 |
| SM          | San Marino                                   |         24 |
| ST          | Sao Tome and Principe                        |          5 |
| A2          | Satellite Provider                           |       1757 |
| SA          | Saudi Arabia                                 |        435 |
| SN          | Senegal                                      |         25 |
| RS          | Serbia                                       |        402 |
| SC          | Seychelles                                   |         67 |
| SL          | Sierra Leone                                 |         52 |
| SG          | Singapore                                    |        983 |
| SK          | Slovakia                                     |        405 |
| SI          | Slovenia                                     |        479 |
| SB          | Solomon Islands                              |          5 |
| SO          | Somalia                                      |         52 |
| ZA          | South Africa                                 |        661 |
| GS          | South Georgia and the South Sandwich Islands |          1 |
| ES          | Spain                                        |       3703 |
| LK          | Sri Lanka                                    |         90 |
| SD          | Sudan                                        |         80 |
| SR          | Suriname                                     |         34 |
| SJ          | Svalbard and Jan Mayen                       |          3 |
| SZ          | Swaziland                                    |         27 |
| SE          | Sweden                                       |       2634 |
| CH          | Switzerland                                  |       2874 |
| SY          | Syrian Arab Republic                         |         64 |
| TW          | Taiwan                                       |        487 |
| TJ          | Tajikistan                                   |         31 |
| TZ          | Tanzania, United Republic of                 |        161 |
| TH          | Thailand                                     |        421 |
| TL          | Timor-Leste                                  |          5 |
| TG          | Togo                                         |         20 |
| TK          | Tokelau                                      |         13 |
| TO          | Tonga                                        |          5 |
| TT          | Trinidad and Tobago                          |         39 |
| TN          | Tunisia                                      |         23 |
| TR          | Turkey                                       |        846 |
| TM          | Turkmenistan                                 |         12 |
| TC          | Turks and Caicos Islands                     |         14 |
| TV          | Tuvalu                                       |          2 |
| UG          | Uganda                                       |         97 |
| UA          | Ukraine                                      |       2675 |
| AE          | United Arab Emirates                         |        353 |
| GB          | United Kingdom                               |      14718 |
| US          | United States                                |      22371 |
| UM          | United States Minor Outlying Islands         |         10 |
| UY          | Uruguay                                      |         88 |
| UZ          | Uzbekistan                                   |         63 |
| VU          | Vanuatu                                      |          8 |
| VE          | Venezuela                                    |        266 |
| VN          | Vietnam                                      |        202 |
| VG          | Virgin Islands, British                      |        105 |
| VI          | Virgin Islands, U.S.                         |        136 |
| WF          | Wallis and Futuna                            |          2 |
| EH          | Western Sahara                               |          2 |
| YE          | Yemen                                        |         24 |
| ZM          | Zambia                                       |         73 |
| ZW          | Zimbabwe                                     |         89 |
+-------------+----------------------------------------------+------------+
248 rows in set (0.16 sec)

mysql> select * from IPRangeByCountry where CountryCode = 'A1';+-----------------+-----------------+------------+------------+-------------+-----------------+--------+
| FromIP          | ToIP            | FromInt    | ToInt      | CountryCode | CountryName     | _id    |
+-----------------+-----------------+------------+------------+-------------+-----------------+--------+
| 64.55.144.0     | 64.55.147.255   | 1077383168 | 1077384191 | A1          | Anonymous Proxy |  17888 |
| 64.62.138.0     | 64.62.138.127   | 1077840384 | 1077840511 | A1          | Anonymous Proxy |  17925 |
| 64.62.153.160   | 64.62.153.167   | 1077844384 | 1077844391 | A1          | Anonymous Proxy |  17933 |
| 64.71.160.32    | 64.71.160.39    | 1078435872 | 1078435879 | A1          | Anonymous Proxy |  18974 |
| 64.71.191.24    | 64.71.191.31    | 1078443800 | 1078443807 | A1          | Anonymous Proxy |  18993 |
| 64.237.34.128   | 64.237.34.143   | 1089282688 | 1089282703 | A1          | Anonymous Proxy |  20477 |
| 64.237.45.64    | 64.237.45.79    | 1089285440 | 1089285455 | A1          | Anonymous Proxy |  20480 |
| 65.49.2.0       | 65.49.2.255     | 1093730816 | 1093731071 | A1          | Anonymous Proxy |  21040 |
| 65.49.14.0      | 65.49.14.255    | 1093733888 | 1093734143 | A1          | Anonymous Proxy |  21042 |
| 66.38.243.0     | 66.38.243.255   | 1109848832 | 1109849087 | A1          | Anonymous Proxy |  22268 |
| 66.55.156.80    | 66.55.156.95    | 1110940752 | 1110940767 | A1          | Anonymous Proxy |  22467 |
| 66.220.6.224    | 66.220.6.231    | 1121715936 | 1121715943 | A1          | Anonymous Proxy |  24698 |
| 67.15.183.0     | 67.15.183.127   | 1125103360 | 1125103487 | A1          | Anonymous Proxy |  24942 |
| 69.65.43.238    | 69.65.43.238    | 1161898990 | 1161898990 | A1          | Anonymous Proxy |  28804 |
| 69.65.51.64     | 69.65.51.95     | 1161900864 | 1161900895 | A1          | Anonymous Proxy |  28806 |
| 69.65.51.224    | 69.65.51.255    | 1161901024 | 1161901055 | A1          | Anonymous Proxy |  28808 |
| 69.80.96.0      | 69.80.111.255   | 1162895360 | 1162899455 | A1          | Anonymous Proxy |  28904 |
| 72.52.66.8      | 72.52.66.15     | 1211384328 | 1211384335 | A1          | Anonymous Proxy |  31998 |
| 72.52.81.0      | 72.52.81.127    | 1211388160 | 1211388287 | A1          | Anonymous Proxy |  32002 |
| 74.115.0.0      | 74.115.7.255    | 1249050624 | 1249052671 | A1          | Anonymous Proxy |  32335 |
| 74.115.160.0    | 74.115.163.255  | 1249091584 | 1249092607 | A1          | Anonymous Proxy |  32339 |
| 80.67.14.0      | 80.67.15.255    | 1346571776 | 1346572287 | A1          | Anonymous Proxy |  37296 |
| 99.192.198.0    | 99.192.198.255  | 1673577984 | 1673578239 | A1          | Anonymous Proxy |  63114 |
| 128.241.40.0    | 128.241.47.255  | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  67665 |
| 128.241.104.0   | 128.241.111.255 | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  67667 |
| 130.94.91.128   | 130.94.91.255   | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  67834 |
| 130.94.105.128  | 130.94.105.255  | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  67836 |
| 130.94.106.224  | 130.94.106.255  | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  67838 |
| 130.94.107.128  | 130.94.107.255  | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  67840 |
| 130.94.121.32   | 130.94.121.39   | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  67842 |
| 130.94.121.168  | 130.94.121.175  | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  67844 |
| 130.94.121.240  | 130.94.121.247  | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  67846 |
| 130.94.123.160  | 130.94.123.191  | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  67848 |
| 130.94.133.0    | 130.94.133.127  | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  67850 |
| 130.94.134.0    | 130.94.134.255  | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  67852 |
| 168.143.114.0   | 168.143.114.255 | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  72370 |
| 168.143.117.128 | 168.143.117.255 | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  72372 |
| 168.143.120.0   | 168.143.120.127 | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  72374 |
| 168.143.123.64  | 168.143.123.127 | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  72376 |
| 168.143.185.176 | 168.143.185.191 | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  72378 |
| 168.143.185.208 | 168.143.185.223 | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  72380 |
| 173.0.0.0       | 173.0.15.255    | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  72564 |
| 173.245.84.0    | 173.245.85.255  | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  73380 |
| 176.31.59.140   | 176.31.59.143   | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  75509 |
| 176.31.219.84   | 176.31.219.87   | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  76841 |
| 178.33.145.76   | 178.33.145.79   | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  80909 |
| 178.33.213.212  | 178.33.213.215  | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  81524 |
| 178.73.192.0    | 178.73.195.255  | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  81691 |
| 178.73.198.0    | 178.73.198.63   | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  81693 |
| 178.73.204.0    | 178.73.211.255  | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  81695 |
| 188.126.72.0    | 188.126.95.255  | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  84051 |
| 192.204.64.0    | 192.204.79.255  | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  89313 |
| 193.104.113.0   | 193.104.113.255 | 2147483647 | 2147483647 | A1          | Anonymous Proxy |  91670 |
| 198.65.160.0    | 198.65.160.255  | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 118951 |
| 198.65.164.0    | 198.65.164.127  | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 118953 |
| 198.65.165.0    | 198.65.165.127  | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 118955 |
| 198.65.166.192  | 198.65.166.255  | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 118957 |
| 198.65.167.192  | 198.65.167.223  | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 118959 |
| 198.172.201.0   | 198.172.202.255 | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 119171 |
| 198.172.203.128 | 198.172.204.255 | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 119173 |
| 198.172.206.0   | 198.172.207.127 | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 119175 |
| 199.48.240.0    | 199.48.247.255  | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 119673 |
| 199.255.208.0   | 199.255.215.255 | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 120442 |
| 205.212.72.0    | 205.212.79.255  | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 128900 |
| 207.67.145.128  | 207.67.146.255  | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 131939 |
| 207.67.148.0    | 207.67.149.255  | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 131941 |
| 207.67.151.0    | 207.67.151.255  | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 131943 |
| 207.195.240.0   | 207.195.255.255 | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 132579 |
| 209.59.32.0     | 209.59.63.255   | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 135549 |
| 209.107.204.0   | 209.107.204.255 | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 136630 |
| 209.107.217.0   | 209.107.217.255 | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 136632 |
| 209.212.145.201 | 209.212.145.201 | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 137690 |
| 209.222.3.0     | 209.222.3.31    | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 137728 |
| 213.254.213.32  | 213.254.213.63  | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 150143 |
| 217.15.160.0    | 217.15.175.255  | 2147483647 | 2147483647 | A1          | Anonymous Proxy | 154793 |
+-----------------+-----------------+------------+------------+-------------+-----------------+--------+
75 rows in set (0.06 sec)