     JOIN places p
         ON (p.entity_id = part.primary_entity_id)
     LEFT JOIN (
-        -- Just in case there are places with multiple types. We only want it to create one event
-        SELECT DISTINCT ON (place_id) place_id, type_id FROM places_types
+        SELECT place_id, trisano.text_join_agg(code_description, ', ') AS place_types
+        FROM
+            codes
+            JOIN places_types
+                ON (places_types.type_id = codes.id)
+        GROUP BY place_id 
     ) pt
         ON (pt.place_id = p.id)
-    LEFT JOIN codes c
-        ON (c.id = pt.type_id AND c.deleted_at IS NULL)
+--    LEFT JOIN (
+--        -- Just in case there are places with multiple types. We only want it to create one event
+--        SELECT DISTINCT ON (place_id) place_id, type_id FROM places_types
+--    ) pt
+--        ON (pt.place_id = p.id)
+--    LEFT JOIN codes c
+--        ON (c.id = pt.type_id AND c.deleted_at IS NULL)
     LEFT JOIN participations_places prtpl
         ON (prtpl.id = events.participations_place_id)
     LEFT JOIN disease_events disev

    LEFT JOIN places
        ON (places.entity_id = p.secondary_entity_id)
    LEFT JOIN (
        -- Just in case there are places with multiple types. We only want it to create one record
        -- XXX erm, this won't work. It's on Josh's TODO list
        SELECT DISTINCT ON (place_id) place_id, type_id FROM places_types
    ) pt
        ON (pt.place_id = places.id)
    LEFT JOIN codes c
        ON (c.id = pt.type_id AND c.deleted_at IS NULL)
    LEFT JOIN organisms org
        ON (org.id = lr.organism_id)
;

    events.id,
    events.parent_id AS dw_morbidity_events_id,
    p.name,
    pt.place_types AS place_type,
    prtpl.date_of_exposure,
    ad.street_number,
    ad.street_name,
