servicemap

Custom SQL query returning 2 rows (hide)

select id, parent, business_id, name_fi, abbr, street_address, address_city, address_postal_full, www, phone, address_zip, oid, organization_type, level, municipality, www_sv, street_address_sv, street_address_en, address_postal_full_en, address_city_fi, name_en, www_en, address_postal_full_sv, abbr_fi, address_postal_full_fi, abbr_sv, abbr_en, address_city_en, name_sv, street_address_fi, address_city_sv, www_fi from department where "organization_type" = :p0 order by address_city_fi limit 101

Query parameters

p0