number of errors=65
number of warnings=0
country=SI
select countrycode,provider,datasourceid,name,'http://www.geonames.org/maps/google_' || source.longlat[1] || '_' || source.longlat[0] || '.html' as gnurl from source where countrycode in ('SI') and not exists (select 1 from geoname_datasource where geoname_datasource.userid=source.userid and datasourceid=nameorid)
countrycode provider datasourceid name gnurl SI si stat 129012 Prapretno pri Hrastniku - Del http://www.geonames.org/maps/google_46.135982182397015_15.064528461062421.html SI si stat 162003 Lesno Brdo http://www.geonames.org/maps/google_46.01596115789687_14.327719346895877.html SI si stat 070035 Rošpoh - Del http://www.geonames.org/maps/google_46.598938230297456_15.61954254646403.html SI si stat 167005 Rdeči Breg - Del http://www.geonames.org/maps/google_46.56198459356654_15.379199316002557.html SI si stat 134007 Brlog - Del http://www.geonames.org/maps/google_45.79750094619826_14.565346834435669.html SI si stat 103024 Tolsti Vrh P. R. na K. - Del http://www.geonames.org/maps/google_46.56886415015131_14.968404506167706.html SI si stat 093010 Rdeči Breg - Del http://www.geonames.org/maps/google_46.5671443451429_15.346433413723695.html SI si stat 025019 Tolsti Vrh P. R. na K. - Del http://www.geonames.org/maps/google_46.57158762834392_14.998896633495427.html SI si stat 179010 Male Vinice http://www.geonames.org/maps/google_45.74706286535105_14.669467267535428.html SI si stat 179002 Brlog - Del http://www.geonames.org/maps/google_45.787231392536604_14.56083213300703.html SI si stat 194020 Kamni Vrh pri Primskovem http://www.geonames.org/maps/google_45.983005941362734_14.942978549708437.html SI si stat 034004 Čeče - Del http://www.geonames.org/maps/google_46.16669604722264_15.095768599753878.html SI si stat 029010 Ivanjski Vrh http://www.geonames.org/maps/google_46.59031906225455_15.961846621908844.html SI si stat 029011 Ivanjševci ob Ščavnici http://www.geonames.org/maps/google_46.61803923219586_15.965200059564784.html SI si stat 034015 Prapretno pri Hrastniku - Del http://www.geonames.org/maps/google_46.13543699308214_15.07057968680165.html SI si stat 036023 Mrzli Vrh http://www.geonames.org/maps/google_46.05854721562308_14.047535892443474.html SI si stat 043110 Zgornji Motnik http://www.geonames.org/maps/google_46.22268146600477_14.895061708530509.html SI si stat 043104 Zajasovnik - Del http://www.geonames.org/maps/google_46.20954421457173_14.888757382199893.html SI si stat 142065 Vrhe - Del http://www.geonames.org/maps/google_46.193984380249425_14.99154569538445.html SI si stat 054145 Spodnja Libna http://www.geonames.org/maps/google_45.94845690434766_15.518591788588358.html SI si stat 153008 Ivanjski Vrh http://www.geonames.org/maps/google_46.58656327572501_15.960456484019868.html SI si stat 097021 Vadarci http://www.geonames.org/maps/google_46.75405747829527_16.07592146503062.html SI si stat 021032 Setnica - Del http://www.geonames.org/maps/google_46.08242334044618_14.322258706674205.html SI si stat 064014 Ravnik pri Hotedršici http://www.geonames.org/maps/google_45.91759328683438_14.1643026219955.html SI si stat 073014 Dolnji Suhor pri Metliki http://www.geonames.org/maps/google_45.689953984891986_15.278605854817553.html SI si stat 031004 Košarovci http://www.geonames.org/maps/google_46.75886378410979_16.20062160938141.html SI si stat 060049 Kandrše - Del http://www.geonames.org/maps/google_46.13186291535673_14.831309431946071.html SI si stat 060053 Konjšica - Del http://www.geonames.org/maps/google_46.100502587427336_14.983982217406828.html SI si stat 105009 Sotina http://www.geonames.org/maps/google_46.831255438560746_16.03953482419992.html SI si stat 142045 Prapreče - Del http://www.geonames.org/maps/google_46.14609017925564_15.019281679889657.html SI si stat 142078 Spodnji Šemnik http://www.geonames.org/maps/google_46.14367128388895_14.943091048661719.html SI si stat 119019 Gorenje Gradišče pri Šentj. http://www.geonames.org/maps/google_45.84121457639756_15.292495975323348.html SI si stat 045012 Spodnji Gaj pri Pragerskem http://www.geonames.org/maps/google_46.3962886287411_15.675850329953962.html SI si stat 103020 Stražišče http://www.geonames.org/maps/google_46.55728088623674_14.9464225064121.html SI si stat 114025 Novo Tepanje http://www.geonames.org/maps/google_46.35235414179304_15.478042651178516.html SI si stat 120024 Grobelno - Del http://www.geonames.org/maps/google_46.224633984539004_15.430204860945597.html SI si stat 120057 Planinska Vas http://www.geonames.org/maps/google_46.10428921210009_15.438540956542338.html SI si stat 122018 Gorenja Vas - Reteče http://www.geonames.org/maps/google_46.15947778891121_14.380590654147623.html SI si stat 147008 Mrzli Vrh http://www.geonames.org/maps/google_46.0564285398058_14.068664109654575.html SI si stat 129015 Vrhe - Del http://www.geonames.org/maps/google_46.18996395089619_15.013299907063512.html SI si stat 128072 Žabče http://www.geonames.org/maps/google_46.192234242638584_13.746938000820554.html SI si stat 129002 Čeče - Del http://www.geonames.org/maps/google_46.1801786446499_15.089625317794715.html SI si stat 129011 Prapreče - Del http://www.geonames.org/maps/google_46.156208165861536_15.024119168287287.html SI si stat 124056 Spodnja Ponkvica http://www.geonames.org/maps/google_46.24127539914852_15.471857590508247.html SI si stat 133010 Lopatnik pri Velenju http://www.geonames.org/maps/google_46.365771354115445_15.169098091129658.html SI si stat 130039 Dolenje Medvedje Selo http://www.geonames.org/maps/google_45.913690177322536_15.022854807283071.html SI si stat 130057 Gorenja Vas pri Čatežu http://www.geonames.org/maps/google_45.96473809132636_14.975809893624705.html SI si stat 142027 Konjšica - Del http://www.geonames.org/maps/google_46.11503989960544_14.995238887807924.html SI si stat 140006 Lesno Brdo http://www.geonames.org/maps/google_46.005215787374354_14.333819495730008.html SI si stat 142023 Kandrše - Del http://www.geonames.org/maps/google_46.13669556792429_14.8463660164177.html SI si stat 189015 Zajasovnik - Del http://www.geonames.org/maps/google_46.20990753294409_14.91853050968122.html SI si stat 178002 Fala http://www.geonames.org/maps/google_46.54652924160699_15.458384494070264.html SI si stat 070049 Zgornji Slemen - Del http://www.geonames.org/maps/google_46.60538349661632_15.537827178219343.html SI si stat 071014 Setnica - Del http://www.geonames.org/maps/google_46.09055759879987_14.33573113298084.html SI si stat 055011 Rošpoh - Del http://www.geonames.org/maps/google_46.60271016106413_15.639284891744508.html SI si stat 178011 Vurmat - Del http://www.geonames.org/maps/google_46.59701718222958_15.443756561268128.html SI si stat 178014 Zgornji Slemen - Del http://www.geonames.org/maps/google_46.599555197240534_15.512323382234184.html SI si stat 060158 Sopota http://www.geonames.org/maps/google_46.06042082375959_15.053332041396928.html SI si stat 142074 Sopota http://www.geonames.org/maps/google_46.062529154274465_15.046773801913904.html SI si stat 175013 Stražišče http://www.geonames.org/maps/google_46.554946440349084_14.934945961545964.html SI si stat 108006 Fala http://www.geonames.org/maps/google_46.5457810880074_15.449391261021688.html SI si stat 054038 Dolga Raka http://www.geonames.org/maps/google_45.91754601515513_15.381707617901787.html SI si stat 124023 Grobelno - Del http://www.geonames.org/maps/google_46.21431150297836_15.44696117929919.html SI si stat 194037 Razbore-K. O. Poljane - Del http://www.geonames.org/maps/google_45.973995058146286_14.939588450648854.html SI si stat 093013 Vurmat - Del http://www.geonames.org/maps/google_46.58952625147721_15.42456229663165.html