number of errors=0
number of warnings=79
Group=ckgGrpElevation
Group=ckgGrpWP
select geoname.geonameid,title,geoname.countrycode,rank,geoname.altitude,gtopo30,srtm3,astergdem,geoname.featurecode,feature,alternatename.name as link,case when rank>92 then 'ERR' else 'WRN' end as ERRWRN from wp_match,geoname,alternatename where geoname.geonameid=alternatename.geonameid and alternatename.namelocale='link' and alternatename.name like '%en.wikipedia%' and wp_match.geonameid=geoname.geonameid and geoname.featurecode in ('PK','MT','VLC') and geoname.countrycode not in ('AQ') and geoname.altitude is null and rank>50 order by rank desc,wp_match.relevance
[{key=CA,number=38}, {key=AU,number=10}, {key=AR,number=4}, {key=AT,number=2}, {key=BA,number=2}, {key=CL,number=2}, {key=CN,number=2}, {key=AF,number=1}, {key=BG,number=1}, {key=BR,number=1}, {key=CY,number=1}, {key=FI,number=1}, {key=FK,number=1}, {key=GR,number=1}, {key=GS,number=1}, {key=IL,number=1}, {key=IR,number=1}, {key=IS,number=1}, {key=IT,number=1}, {key=KE,number=1}, {key=MK,number=1}, {key=MW,number=1}, {key=NZ,number=1}, {key=VE,number=1}, {key=XK,number=1}, {key=ZA,number=1}]
geonameid title countrycode rank altitude gtopo30 srtm3 astergdem featurecode feature link errwrn 5969861 Hamilton Mountain CA 92 null 212 208 200 MT null https://en.wikipedia.org/wiki/Hamilton_Mountain WRN 6159201 Sumas Mountain (British Columbia) CA 90 null 297 240 243 MT mountain https://en.wikipedia.org/wiki/Sumas_Mountain_%28British_Columbia%29 WRN 3198088 Klek BA 90 null 661 736 742 MT null https://en.wikipedia.org/wiki/Klek_(mountain) WRN 261705 Ithomi, Messenia GR 89 null 778 785 804 MT null https://en.wikipedia.org/wiki/Ithome WRN 642952 Pallastunturi FI 89 null 730 -32768 744 MT mountain https://en.wikipedia.org/wiki/Pallastunturi WRN 2773556 Kreischberg AT 89 null 1849 1764 1770 MT null https://en.wikipedia.org/wiki/Kreischberg WRN 6168123 Tower of London Range CA 88 null 1881 1851 1821 MT null https://en.wikipedia.org/wiki/Tower_of_London_Range WRN 3832915 Vicuña Pampa AR 86 null 3279 3326 3306 VLC null https://en.wikipedia.org/wiki/Vicu%C3%B1a_Pampa WRN 2069246 Mount Jackson AU 86 null 609 605 600 MT null https://en.wikipedia.org/wiki/Mount_Jackson,_Western_Australia WRN 1795548 Sheshan Hill CN 85 null 6 4 7 MT null https://en.wikipedia.org/wiki/Sheshan WRN 2814092 Kanzelwand AT 84 null 1796 1780 1785 MT mountain https://en.wikipedia.org/wiki/Kanzelwand WRN 733734 Adatepe (volcano) BG 83 null 270 484 483 MT null https://en.wikipedia.org/wiki/Adatepe_%28volcano%29 WRN 931490 Chambe Peak MW 83 null 2385 2452 2451 PK mountain https://en.wikipedia.org/wiki/Chambe_Peak WRN 122629 Narli Dagh IR 81 null 392 384 401 MT null https://en.wikipedia.org/wiki/Narli_Dagh WRN 3843734 Cerro Morado AR 81 null 1154 1178 1179 MT null https://en.wikipedia.org/wiki/Cerro_Morado WRN 6161093 Tagish Highland CA 81 null 1183 1424 1412 MT null https://en.wikipedia.org/wiki/Tagish_Highland WRN 5923859 Clendinning Range CA 80 null 2248 2225 2123 MT null https://en.wikipedia.org/wiki/Clendinning_Range WRN 3412050 Vífilsfell IS 80 null 514 -32768 642 MT mountain https://en.wikipedia.org/wiki/V%C3%ADfilsfell WRN 6082913 Mount Sylvester CA 79 null 289 250 229 MT mountain https://en.wikipedia.org/wiki/Mount_Sylvester WRN 3344307 Bokševica BA 79 null 1199 1301 1298 MT mountain https://en.wikipedia.org/wiki/Bok%C5%A1evica WRN 2175669 Mount Bischoff AU 79 null 544 629 651 MT mountain https://en.wikipedia.org/wiki/Mount_Bischoff WRN 3369120 Chapman's Peak ZA 79 null 579 555 543 MT mountain https://en.wikipedia.org/wiki/Chapman%27s_Peak WRN 5913166 Cadwallader Range CA 79 null 2150 2049 2012 MT null https://en.wikipedia.org/wiki/Cadwallader_Range WRN 3397833 Pico do Jabre BR 78 null 1139 -32768 1164 PK mountain https://en.wikipedia.org/wiki/Pico_do_Jabre WRN 6161921 Tatlatui Range CA 78 null 2191 1930 1954 MT mountain https://en.wikipedia.org/wiki/Tatlatui_Range WRN 1812797 Dinghu Mountain CN 77 null 104 249 237 MT null https://en.wikipedia.org/wiki/Dinghu_Mountain WRN 6153295 Spearhead Range CA 77 null 2326 2077 2090 MT mountain https://en.wikipedia.org/wiki/Spearhead_Range WRN 3427110 Mount Challenger FK 77 null 137 333 335 MT mountain https://en.wikipedia.org/wiki/Mount_Challenger WRN 6144258 Sentinel Range (Canada) CA 77 null 1808 1772 1809 MT null https://en.wikipedia.org/wiki/Sentinel_Range_%28Canada%29 WRN 386202 Mount Nitai IL 76 null -136 91 82 MT mountain https://en.wikipedia.org/wiki/Mount_Nitai WRN 8166966 Mount Eliza (Western Australia) AU 76 null 15 69 71 MT null https://en.wikipedia.org/wiki/Mount_Eliza_%28Western_Australia%29 WRN 4918 Malia CY 75 null 433 452 265 MT null https://en.wikipedia.org/wiki/Malia WRN 5957991 Frenchman Butte CA 74 null 629 630 626 MT null https://en.wikipedia.org/wiki/Frenchman_Butte WRN 3839322 Cerro Ratones AR 73 null 4793 5071 5055 VLC null https://en.wikipedia.org/wiki/Cerro_Ratones WRN 3169164 Roccamonfina (volcano) IT 72 null 561 602 599 VLC mountain https://en.wikipedia.org/wiki/Roccamonfina_%28volcano%29 WRN 2188507 Landslip Hill NZ 72 null 270 267 267 MT mountain https://en.wikipedia.org/wiki/Landslip_Hill WRN 10787884 Wilckens Peaks GS 72 null 874 1027 1025 PK null https://en.wikipedia.org/wiki/Wilckens_Peaks WRN 3806916 Cerro El Volcán VE 71 null 614 539 575 MT mountain https://en.wikipedia.org/wiki/Cerro_El_Volc%C3%A1n WRN 5962729 Gold Range CA 71 null 2282 2470 2494 MT null https://en.wikipedia.org/wiki/Gold_Range WRN 1134446 Lor Koh AF 71 null 2502 2492 2505 MT mountain https://en.wikipedia.org/wiki/Lor_Koh WRN 3834577 Tebenquicho AR 71 null 4700 4605 4608 VLC null https://en.wikipedia.org/wiki/Tebenquicho WRN 6162625 Telkwa Range CA 70 null 1764 1422 1419 MT null https://en.wikipedia.org/wiki/Telkwa_Range WRN 191225 Kitaingo KE 70 null 1729 1697 1699 MT null https://en.wikipedia.org/wiki/Kitaingo WRN 6080996 Mount Gunanoot CA 70 null 1828 1794 1798 MT null https://en.wikipedia.org/wiki/Mount_Gunanoot WRN 5934380 Cyclone Mountain CA 69 null 2424 2867 2787 MT null https://en.wikipedia.org/wiki/Cyclone_Mountain WRN 833312 Maja (peak) MK 68 null 2302 2465 2465 PK null https://en.wikipedia.org/wiki/Maja_%28peak%29 WRN 6079759 Mount Armour CA 68 null 422 589 572 MT mountain https://en.wikipedia.org/wiki/Mount_Armour WRN 2150056 Scotts Peak AU 65 null 263 304 320 PK mountain https://en.wikipedia.org/wiki/Scotts_Peak WRN 5925051 Coldspring Mountain CA 65 null 1350 -32768 1380 MT mountain https://en.wikipedia.org/wiki/Coldspring_Mountain WRN 2072097 Mount Eliza AU 65 null 608 633 606 MT null https://en.wikipedia.org/wiki/Mount_Eliza_(Western_Australia) WRN 6173101 Valkyr Range CA 63 null 2100 1867 1877 MT mountain https://en.wikipedia.org/wiki/Valkyr_Range WRN 2163172 Mount Hopeless (Queensland) AU 62 null 637 736 726 MT mountain https://en.wikipedia.org/wiki/Mount_Hopeless_%28Queensland%29 WRN 6082594 Mount Saugstad CA 62 null 2466 2526 2612 MT null https://en.wikipedia.org/wiki/Mount_Saugstad WRN 5917995 Casket Mountain CA 62 null 1829 1903 1942 MT null https://en.wikipedia.org/wiki/Casket_Mountain WRN 5922675 Cinquefoil Mountain CA 62 null 2127 1816 1844 MT null https://en.wikipedia.org/wiki/Cinquefoil_Mountain WRN 8168842 Mount Typo AU 61 null 641 982 993 MT null https://en.wikipedia.org/wiki/Mount_Typo WRN 5927634 Copper Mountain (British Columbia) CA 60 null 1293 1288 1292 MT mountain https://en.wikipedia.org/wiki/Copper_Mountain_%28British_Columbia%29 WRN 5989084 Kana Cone CA 60 null 1141 1091 1107 MT null https://en.wikipedia.org/wiki/Kana_Cone WRN 6162822 Tennena Cone CA 60 null 2008 2146 2162 MT null https://en.wikipedia.org/wiki/Tennena_Cone WRN 5993846 Kokanee Range CA 59 null 2133 2151 2141 MT null https://en.wikipedia.org/wiki/Kokanee_Range WRN 2077604 Mount Arden AU 58 null 527 834 839 MT null https://en.wikipedia.org/wiki/Mount_Arden WRN 6081085 Mount Hawkins CA 58 null 2509 2501 2532 MT null https://en.wikipedia.org/wiki/Mount_Hawkins WRN 3885585 Cerro de La Isla CL 58 null 951 1035 1048 MT mountain https://en.wikipedia.org/wiki/Cerro_de_La_Isla WRN 5884955 Anderson Peak (Alberta) CA 57 null 2572 2284 2234 PK null https://en.wikipedia.org/wiki/Anderson_Peak_%28Alberta%29 WRN 6149281 Slatechuck Mountain CA 57 null 914 881 902 MT null https://en.wikipedia.org/wiki/Slatechuck_Mountain WRN 5938813 Devon Mountain CA 57 null 2491 2797 2778 MT null https://en.wikipedia.org/wiki/Devon_Mountain WRN 2057754 Mount Wudinna AU 57 null 174 253 234 MT null https://en.wikipedia.org/wiki/Mount_Wudinna WRN 5918273 Cataract Peak CA 56 null 2403 2969 2990 PK null https://en.wikipedia.org/wiki/Cataract_Peak WRN 2062827 County Peak AU 55 null 278 352 344 PK mountain https://en.wikipedia.org/wiki/County_Peak WRN 789710 Kačina glava XK 53 null 2110 2162 2186 MT null https://en.wikipedia.org/wiki/Ka%C4%8Dina_glava WRN 6080122 Mount Burns CA 53 null 2524 2386 2382 MT null https://en.wikipedia.org/wiki/Mount_Burns WRN 6153255 Spatsizi Mountain CA 53 null 1764 1805 1851 MT mountain https://en.wikipedia.org/wiki/Spatsizi_Mountain WRN 6080790 Mount Fortune CA 53 null 2088 1894 1889 MT null https://en.wikipedia.org/wiki/Mount_Fortune WRN 3898445 Cerro Benítez CL 53 null 86 521 519 MT mountain https://en.wikipedia.org/wiki/Cerro_Ben%C3%ADtez WRN 5942442 Draco Peak CA 52 null 2168 2082 2101 PK null https://en.wikipedia.org/wiki/Draco_Peak WRN 6079955 Mount Bistre (Alberta) CA 52 null 2136 2159 2161 MT null https://en.wikipedia.org/wiki/Mount_Bistre_%28Alberta%29 WRN 5993988 Koosick Bluff CA 51 null 1832 1923 1914 MT mountain https://en.wikipedia.org/wiki/Koosick_Bluff WRN 5928117 Coronation Mountain CA 51 null 1558 2856 2788 MT null https://en.wikipedia.org/wiki/Coronation_Mountain WRN 5938692 Devils Head (Canada) CA 51 null 2408 2261 2536 MT null https://en.wikipedia.org/wiki/Devils_Head_%28Canada%29 WRN