servicemap

Custom SQL query returning 1 row (hide)

select name_fi, name_sv, name_en, id, period_enabled, clarification_enabled, keywords, root_service_node, unit_count_municipality_helsinki, unit_count_total, unit_count_municipality_hanko, unit_count_municipality_raasepori, unit_count_municipality_siuntio, unit_count_municipality_sipoo, unit_count_municipality_janakkala, unit_count_municipality_null, [unit_count_municipality_nurmijärvi], unit_count_municipality_virolahti, unit_count_municipality_pornainen, [unit_count_municipality_hämeenlinna], unit_count_municipality_salo, [unit_count_municipality_lapinjärvi], unit_count_municipality_inkoo, [unit_count_municipality_miehikkälä], unit_count_municipality_porvoo, unit_count_municipality_lohja, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_hamina, unit_count_municipality_kouvola, unit_count_municipality_loviisa, unit_count_municipality_espoo, unit_count_municipality_kotka, unit_count_municipality_askola, [unit_count_municipality_mäntsälä], unit_count_municipality_vantaa, [unit_count_municipality_hyvinkää], unit_count_municipality_vihti, unit_count_municipality_kauniainen, unit_count_municipality_karkkila, [unit_count_municipality_järvenpää], unit_count_municipality_kerava, [unit_count_municipality_pyhtää] from service where "keywords" = :p0 order by unit_count_municipality_kotka limit 101

Query parameters

p0