#*********************************************************************************
# MacDescription = Count the number of finds in each country
# MacFileName = NlGemList.gsk
# MacAuthor = Idee Kai Team, Aanpassingen o.a. voor NL en County = GeoFlowers
# MacVersion=1.0
# MacUrl=http://www.wandelverhalen.com/gps/uitleg/NlGemList.gsk
#*********************************************************************************
# Om de benodigde informatie over county en country op to date te houden
# is het aan te bevelen om in het File>Load GPX... venster in veld 
# County update "YB" in te vullen, zonder quotes en in het veld State update "SBA"
#*********************************************************************************
# Is er een filter actief, even bewaren  
$SavedFilter = SaveFilter()
CancelFilter
MFilter Expression= regex("Netherlands",$d_Country)
IF $_FilterCount > 0
  SQLITECACHES Scope=Filter
  $_sql="Select Distinct County,Sum(FoundCount) As FindCount from CachesTempAll Group by County Order by FindCount DESC"
  $status = Sqlite("sql",$_sql)
  $status = "County; Finds" + $_NewLine + $status
  $Out=SqlToHtml($status,"Finds by County", "Y")
  IF RestoreFilter($SavedFilter,True) = 0
    Pause Msg="No records match your restored filter. Filter has been canceled."
  ENDIF
ELSE
  PAUSE Msg="No waypoints in filter, action cancelled"
ENDIF