[
"sql" => "SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.date AS date_2, k0_.location AS location_3, k0_.custom_songs AS custom_songs_4, k0_.song_order AS song_order_5, k0_.video_links AS video_links_6, k0_.plakat_path AS plakat_path_7, k0_.programm_vorderseite AS programm_vorderseite_8, k0_.programm_rueckseite AS programm_rueckseite_9, k0_.kritik_path AS kritik_path_10, k0_.song_notes AS song_notes_11, k0_.introduction AS introduction_12, s1_.id AS id_13, s1_.song_name AS song_name_14, s1_.composer AS composer_15, s1_.arrangeur AS arrangeur_16, s1_.composition_year AS composition_year_17, s1_.duration AS duration_18, s1_.background AS background_19, s1_.keywords AS keywords_20, s1_.etikett AS etikett_21, s1_.etikett_color AS etikett_color_22, s1_.etikett_number AS etikett_number_23, s1_.folder AS folder_24, s1_.dropboxlink AS dropboxlink_25, s1_.is_aktuelle_proben AS is_aktuelle_proben_26, s1_.aktuelle_dropboxlink AS aktuelle_dropboxlink_27, s1_.sort_order AS sort_order_28, s1_.parent_id AS parent_id_29 FROM konzert k0_ LEFT JOIN konzert_song k2_ ON k0_.id = k2_.konzert_id LEFT JOIN song s1_ ON s1_.id = k2_.song_id ORDER BY k0_.date DESC"
]