SELECT "AdventureHashtag"."adventureId",
         "AdventureHashtag"."hashtagId",
         "AdventureHashtag"."createdAt",
         "AdventureHashtag"."updatedAt",
         "adventure"."id" AS "adventure.id",
         "adventure"."name" AS "adventure.name",
         "adventure"."description" AS "adventure.description",
         "adventure"."picture" AS "adventure.picture",
         "adventure"."startSceneId" AS "adventure.startSceneId",
         "adventure"."createdAt" AS "adventure.createdAt",
         "adventure"."updatedAt" AS "adventure.updatedAt",
         "adventure->hashtag"."id" AS "adventure.hashtag.id",
         "adventure->hashtag"."name" AS "adventure.hashtag.name",
         "adventure->hashtag"."slug" AS "adventure.hashtag.slug",
         "adventure->hashtag"."createdAt" AS "adventure.hashtag.createdAt",
         "adventure->hashtag"."updatedAt" AS "adventure.hashtag.updatedAt",
         "adventure->hashtag->AdventureHashtag"."adventureId" AS "adventure.hashtag.AdventureHashtag.adventureId",
         "adventure->hashtag->AdventureHashtag"."hashtagId" AS "adventure.hashtag.AdventureHashtag.hashtagId",
         "adventure->hashtag->AdventureHashtag"."createdAt" AS "adventure.hashtag.AdventureHashtag.createdAt",
         "adventure->hashtag->AdventureHashtag"."updatedAt" AS "adventure.hashtag.AdventureHashtag.updatedAt"
FROM "AdventureHashtags" AS "AdventureHashtag" LEFT OUTER
JOIN "Adventures" AS "adventure"
    ON "AdventureHashtag"."adventureId" = "adventure"."id" LEFT OUTER
JOIN ( "AdventureHashtags" AS "adventure->hashtag->AdventureHashtag"
INNER JOIN "Hashtags" AS "adventure->hashtag"
    ON "adventure->hashtag"."id" = "adventure->hashtag->AdventureHashtag"."hashtagId")
    ON "adventure"."id" = "adventure->hashtag->AdventureHashtag"."adventureId"
WHERE "AdventureHashtag"."hashtagId" = 1;