# Pastebin utmVrlDj
'SELECT \' . MusicBrainz::Server::Data::Event=HASH(0x5642bc2aa318)->_columns .\'
           FROM (
                    SELECT lae.entity1 AS event
                      FROM l_area_event lae
                     WHERE lae.entity0 = $1 OR EXISTS (
                        SELECT 1 FROM (
        WITH RECURSIVE area_descendants AS (
            SELECT entity0 AS parent, entity1 AS descendant, 1 AS depth
              FROM l_area_area laa
              JOIN link ON laa.link = link.id
             WHERE link.link_type = $2
               AND entity1 = lae.entity0
                UNION
            SELECT entity0 AS parent, descendant, (depth + 1) AS depth
              FROM l_area_area laa
              JOIN link ON laa.link = link.id
              JOIN area_descendants ON area_descendants.parent = laa.entity1
             WHERE link.link_type = $2
               AND entity0 != descendant
        )
        SELECT ad.descendant, ad.parent, ad.depth
          FROM area_descendants ad
          JOIN area a ON a.id = ad.parent
         WHERE a.type IN (1, 2, 3)
         ORDER BY ad.descendant, ad.depth ASC
    ) ac
                         WHERE ac.descendant = lae.entity0 AND ac.parent = $1
                     )
                ) s, event
          WHERE event.id = s.event
       ORDER BY event.begin_date_year, event.begin_date_month, event.begin_date_day, event.time, musicbrainz_collate(event.name)';