servicemap

Custom SQL query returning 6 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ää
17 [] Koira-aitaukset Hundparker Dog parks 317 2018-08-07T14:00:21.693384+03:00 3 16 {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} 0 1400 94 140                                           22       24              
63 [] Koira-aitaukset Hundparker Dog parks 317 2018-08-07T14:00:21.380622+03:00 4 62 {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} 0 1400 94 140                                           22       24              
494 [] Koira-aitaukset Hundparker Dog parks 317 2018-08-07T14:00:22.710417+03:00 4 493 {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} 0 1403 94 140                                           22       24              
624 [625, 626, 627, 628, 629, 630, 631, 632] Yksittäiset lajikohtaiset sisäliikuntapaikat Enstaka grenspecifika anläggningar för inomhusidrott Indoor venues for various sports   2018-08-07T14:00:23.722887+03:00 3 601 {} 0 1403 118 186                                           43       24     1        
787 [789, 790, 788] Lastensuojelu Barnskydd Child welfare   2018-10-25T08:00:09.006369+03:00 1 783 {} 0 783 37 81                               1           17       24 1   1        
1146 [] B1-ruotsi B1-svenska B1-Swedish 149*108+150*108+162*108+163*108+301*108+302*108+384*108+385*108+567*108+568*108+612*108+613*108+661*108+662*108+771*108+772*108+793*108+794*108+865*108+866*108 2018-10-25T08:00:07.912218+03:00 4 1120 {} 1 1087 107 205                               1           72       24 1