[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], ], 'Doctrine\\ORM\\Query\\Exec\\SingleSelectSqlFinalizer' => [ 'sql' => [ 1 => 'SELECT b0_.id AS id_0, COALESCE(t1_.content, b0_.name) AS name_1, COALESCE(t2_.content, b0_.description) AS description_2, b0_.type AS type_3, b0_.created_at AS created_at_4, b0_.updated_at AS updated_at_5, b0_.deleted_at AS deleted_at_6, b0_.is_active AS is_active_7, b5_.id AS id_8, b5_.price_adult AS price_adult_9, b5_.price_child AS price_child_10, b5_.created_at AS created_at_11, b5_.updated_at AS updated_at_12, b5_.deleted_at AS deleted_at_13, s3_.id AS id_14, COALESCE(t4_.content, s3_.name) AS name_15, s3_.class AS class_16, s3_.created_at AS created_at_17, s3_.updated_at AS updated_at_18, s3_.deleted_at AS deleted_at_19, s3_.start_month AS start_month_20, s3_.stop_month AS stop_month_21, b5_.season_id AS season_id_22, b5_.catering_id AS catering_id_23 FROM booking_catering b0_ LEFT JOIN booking_catering_rate b5_ ON b0_.id = b5_.catering_id LEFT JOIN season s3_ ON b5_.season_id = s3_.id LEFT JOIN ext_translations t1_ ON t1_.locale = \'fr\' AND t1_.field = \'name\' AND t1_.object_class = \'App\\\\BookingBundle\\\\Entity\\\\BookingCatering\' AND t1_.foreign_key = b0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = \'fr\' AND t2_.field = \'description\' AND t2_.object_class = \'App\\\\BookingBundle\\\\Entity\\\\BookingCatering\' AND t2_.foreign_key = b0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = \'fr\' AND t4_.field = \'name\' AND t4_.object_class = \'App\\\\BookingBundle\\\\Entity\\\\Season\' AND t4_.foreign_key = s3_.id ORDER BY s3_.stop_month DESC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'b' => 'App\\BookingBundle\\Entity\\BookingCatering', 'r' => 'App\\BookingBundle\\Entity\\BookingCateringRate', 's' => 'App\\BookingBundle\\Entity\\Season', ], ], 'relationMap' => [ 2 => [ 'r' => 'rates', 's' => 'season', ], ], 'parentAliasMap' => [ 2 => [ 'r' => 'b', 's' => 'r', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'name_1' => 'name', 'description_2' => 'description', 'type_3' => 'type', 'created_at_4' => 'createdAt', 'updated_at_5' => 'updatedAt', 'deleted_at_6' => 'deletedAt', 'is_active_7' => 'isActive', 'id_8' => 'id', 'price_adult_9' => 'priceAdult', 'price_child_10' => 'priceChild', 'created_at_11' => 'createdAt', 'updated_at_12' => 'updatedAt', 'deleted_at_13' => 'deletedAt', 'id_14' => 'id', 'name_15' => 'name', 'class_16' => 'class', 'created_at_17' => 'createdAt', 'updated_at_18' => 'updatedAt', 'deleted_at_19' => 'deletedAt', 'start_month_20' => 'startMonth', 'stop_month_21' => 'stopMonth', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\BookingBundle\\Entity\\BookingCatering' => [ 'b' => [ 'id' => 'id_0', 'name' => 'name_1', 'description' => 'description_2', 'type' => 'type_3', 'createdAt' => 'created_at_4', 'updatedAt' => 'updated_at_5', 'deletedAt' => 'deleted_at_6', 'isActive' => 'is_active_7', ], ], 'App\\BookingBundle\\Entity\\BookingCateringRate' => [ 'r' => [ 'id' => 'id_8', 'priceAdult' => 'price_adult_9', 'priceChild' => 'price_child_10', 'createdAt' => 'created_at_11', 'updatedAt' => 'updated_at_12', 'deletedAt' => 'deleted_at_13', ], ], 'App\\BookingBundle\\Entity\\Season' => [ 's' => [ 'id' => 'id_14', 'name' => 'name_15', 'class' => 'class_16', 'createdAt' => 'created_at_17', 'updatedAt' => 'updated_at_18', 'deletedAt' => 'deleted_at_19', 'startMonth' => 'start_month_20', 'stopMonth' => 'stop_month_21', ], ], ], ], 'typeMappings' => [ 2 => [ 'season_id_22' => 'integer', 'catering_id_23' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'b' => null, ], ], 'metaMappings' => [ 2 => [ 'season_id_22' => 'season_id', 'catering_id_23' => 'catering_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'b', 'name_1' => 'b', 'description_2' => 'b', 'type_3' => 'b', 'created_at_4' => 'b', 'updated_at_5' => 'b', 'deleted_at_6' => 'b', 'is_active_7' => 'b', 'id_8' => 'r', 'price_adult_9' => 'r', 'price_child_10' => 'r', 'created_at_11' => 'r', 'updated_at_12' => 'r', 'deleted_at_13' => 'r', 'id_14' => 's', 'name_15' => 's', 'class_16' => 's', 'created_at_17' => 's', 'updated_at_18' => 's', 'deleted_at_19' => 's', 'start_month_20' => 's', 'stop_month_21' => 's', 'season_id_22' => 'r', 'catering_id_23' => 'r', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\BookingBundle\\Entity\\BookingCatering', 'name_1' => 'App\\BookingBundle\\Entity\\BookingCatering', 'description_2' => 'App\\BookingBundle\\Entity\\BookingCatering', 'type_3' => 'App\\BookingBundle\\Entity\\BookingCatering', 'created_at_4' => 'App\\BookingBundle\\Entity\\BookingCatering', 'updated_at_5' => 'App\\BookingBundle\\Entity\\BookingCatering', 'deleted_at_6' => 'App\\BookingBundle\\Entity\\BookingCatering', 'is_active_7' => 'App\\BookingBundle\\Entity\\BookingCatering', 'id_8' => 'App\\BookingBundle\\Entity\\BookingCateringRate', 'price_adult_9' => 'App\\BookingBundle\\Entity\\BookingCateringRate', 'price_child_10' => 'App\\BookingBundle\\Entity\\BookingCateringRate', 'created_at_11' => 'App\\BookingBundle\\Entity\\BookingCateringRate', 'updated_at_12' => 'App\\BookingBundle\\Entity\\BookingCateringRate', 'deleted_at_13' => 'App\\BookingBundle\\Entity\\BookingCateringRate', 'id_14' => 'App\\BookingBundle\\Entity\\Season', 'name_15' => 'App\\BookingBundle\\Entity\\Season', 'class_16' => 'App\\BookingBundle\\Entity\\Season', 'created_at_17' => 'App\\BookingBundle\\Entity\\Season', 'updated_at_18' => 'App\\BookingBundle\\Entity\\Season', 'deleted_at_19' => 'App\\BookingBundle\\Entity\\Season', 'start_month_20' => 'App\\BookingBundle\\Entity\\Season', 'stop_month_21' => 'App\\BookingBundle\\Entity\\Season', ], ], ], ], $o[0], [] ); } }];