SELECT
       "t1"."id",
       "t1"."created_at",
       "t1"."updated_at",
       "t1"."external_id",
       "t1"."name",
       "t1"."annotate",
       "t1"."text",
       "t1"."extra",
       "t1"."date",
       "t1"."parent_id",
       "t1"."place_id",
       "t1"."landing_id",
       "t1"."is_periodical",
       "t1"."flat_category",
       "t1"."flat_place",
       CASE
           WHEN ("t1"."parent_id" IS NOT NULL) THEN "t2"."external_id"
           ELSE "t1"."external_id"
       END AS "id",
       CAST("t1"."extra" AS JSON),
       "t3"."id",
       "t3"."name",

  (SELECT row_to_json(_place)
   FROM
     (SELECT "t3"."id",
             "t3"."name",
             CAST("t3"."extra"->>'preview' AS JSON) AS "preview",
             CAST("t3"."extra"->>'address' AS JSON) AS "map_config",
             "t3"."extra"->>'plan_address' AS "address"
      FROM "place" AS "t3"
      WHERE ("t3"."id" = "t1"."place_id")) AS "_place") AS "place_info"
FROM "event_en" AS "t1"
LEFT OUTER JOIN "place" AS "t3" ON ("t3"."id" = "t1"."place_id")
LEFT OUTER JOIN "event_en" AS "t2" ON ("t2"."id" = "t1"."parent_id")
WHERE (("t1"."date" < now())
       AND ("t1"."landing_id" = 108))
GROUP BY "t1"."id",
         "t3"."id",
         "t2"."external_id"
ORDER BY "t1"."date" ASC