servicemap

Custom SQL query returning 6 rows (hide)

Query parameters

idparentbusiness_idname_fiabbrstreet_addressaddress_cityaddress_postal_fullwwwphoneaddress_zipoidorganization_typelevelmunicipalitywww_svstreet_address_svstreet_address_enaddress_postal_full_enaddress_city_finame_enwww_enaddress_postal_full_svabbr_fiaddress_postal_full_fiabbr_svabbr_enaddress_city_enname_svstreet_address_fiaddress_city_svwww_fi
11ede428-5a8c-482d-9413-a4d8d0764443 b8764ca3-5819-45f7-88bf-d98df4fe7006 0201256-6 Osallisuus ja neuvonta-yksikkö           +358 9 310 1691 00170 #10 MUNICIPALITY 4 helsinki         Helsinki                   Pohjoisesplanadi 11-13    
1a3ff77f-ae82-4e2e-85f8-b7b1843992e2 b8764ca3-5819-45f7-88bf-d98df4fe7006 0201256-6 Sisäisen viestinnän yksikkö           +358 9 310 1691   #10 MUNICIPALITY 4 helsinki                                  
1d87287e-aa4f-4275-9cbd-97788e703e47 b8764ca3-5819-45f7-88bf-d98df4fe7006 0201256-6 Vieraanvaraisuus.           +358 9 310 1691 00170 #10 MUNICIPALITY 4 helsinki         Helsinki                   Pohjoisesplanadi 11-13    
315cbb5d-562c-4b40-b94c-4041346b88ac b8764ca3-5819-45f7-88bf-d98df4fe7006 0201256-6 Sisällöntuotannon yksikkö           +358 9 310 1691   #10 MUNICIPALITY 4 helsinki                                  
88ca5cdf-7ebb-4501-ae55-8a761657f5a2 b8764ca3-5819-45f7-88bf-d98df4fe7006 0201256-6 Ulkoisen viestinnän yksikkö           +358 9 310 1691   #10 MUNICIPALITY 4 helsinki                                  
c6e56a68-2e92-46d2-b401-517241b87a7f b8764ca3-5819-45f7-88bf-d98df4fe7006 0201256-6 Brändiyksikkö           +358 9 310 1691 00100 #10 MUNICIPALITY 4 helsinki         Helsinki                   Unioninkatu 28 A