servicemap

Custom SQL query returning 9 rows (hide)

Query parameters

idchildrenname_finame_svname_enservice_referencelast_modified_timelevelparentkeywordsrelated_servicesperiod_enabledrootunit_count_municipality_helsinkiunit_count_totalunit_count_municipality_hankounit_count_municipality_raaseporiunit_count_municipality_siuntiounit_count_municipality_sipoounit_count_municipality_janakkalaunit_count_municipality_nurmijärviunit_count_municipality_salounit_count_municipality_virolahtiunit_count_municipality_pornainenunit_count_municipality_hämeenlinnaunit_count_municipality__unknownunit_count_municipality_lapinjärviunit_count_municipality_inkoounit_count_municipality_miehikkäläunit_count_municipality_porvoounit_count_municipality_lohjaunit_count_municipality_tuusulaunit_count_municipality_kirkkonummiunit_count_municipality_haminaunit_count_municipality_kouvolaunit_count_municipality_loviisaunit_count_municipality_espoounit_count_municipality_askolaunit_count_municipality_kotkaunit_count_municipality_mäntsäläunit_count_municipality_vantaaunit_count_municipality_hyvinkääunit_count_municipality_vihtiunit_count_municipality_kauniainenunit_count_municipality_järvenpääunit_count_municipality_keravaunit_count_municipality_karkkilaunit_count_municipality_pyhtää
615 [] Jalkapallohalli Fotbollshall Football hall 204 2018-08-07T14:00:23.650553+03:00 4 614 {} 0 1403 8 18                                           6       3     1        
616 [] Liikuntahalli Idrottshall Sports hall 400 2018-08-07T14:00:23.657783+03:00 4 614 {} 0 1403 24 38                                           7       6     1        
617 [] Monitoimihalli / areena Allaktivitetshall/multiarena Multipurpose hall/arena 444 2018-08-07T14:00:23.665496+03:00 4 614 {} 0 1403 97 133                                           36                      
618 [] Petanque - halli Petanquehall Petanque hall 512 2018-08-07T14:00:23.673008+03:00 4 614 {} 0 1403 1 2                                                   1              
619 [] Salibandyhalli Innebandyhall Floorball hall 616 2018-08-07T14:00:23.680694+03:00 4 614 {} 0 1403 4 12                                           4       4              
620 [] Skeittihalli Skateboardhall Skateboarding hall 631 2018-08-07T14:00:23.687502+03:00 4 614 {} 0 1403 2 3                                           1                      
621 [] Squash-halli Squashhall Squash hall 645 2018-08-07T14:00:23.695720+03:00 4 614 {} 0 1403 4 10                                           5       1              
622 [] Sulkapallohalli Badmintonhall Badminton hall 647 2018-08-07T14:00:23.705272+03:00 4 614 {} 0 1403 9 18                                           5       4              
623 [] Tennishalli Tennishall Tennis hall 699 2018-08-07T14:00:23.714268+03:00 4 614 {} 0 1403 13 23                                           7       3