 SELECT event_alljoin.num_evenement,
		fds_evenement.date,
		event_alljoin.id_depart,
		event_alljoin.nomcomun,
		event_alljoin.libl_site,
		event_alljoin.destination,
		event_alljoin.nature_animation,
		event_alljoin.operation,
		event_alljoin.type_scolaire,
		fds_evenement.commentaire1,
		fds_evenement.salaries,
		fds_evenement.benevoles,
		fds_evenement.non_adherents,
		fds_evenement.adherents,
		fds_evenement.enfants
   FROM ( SELECT event_site.num_evenement,
				event_site.id_depart,
				event_site.operation,
				event_site.destination,
				event_site.nature_animation,
				event_site.type_scolaire,
				event_site.libl_site,
				communes.nomcomun
           FROM ( SELECT event_scol.num_evenement,
						event_scol.id_depart,
						event_scol.insee,
						event_scol.operation,
						event_scol.destination,
						event_scol.nature_animation,
						event_scol.type_scolaire,
						sites.libl_site
                   FROM ( SELECT event_natanim.num_evenement,
								event_natanim.id_depart,
								event_natanim.newcodesite,
								event_natanim.insee,
								event_natanim.operation,
								event_natanim.destination,
								event_natanim.nature_animation,
								fds_t_type_scolaire.type_scolaire
                           FROM ( SELECT event_dest.num_evenement,
										event_dest.ref_type_scolaire,
										event_dest.id_depart,
										event_dest.newcodesite,
										event_dest.insee,
										event_dest.operation,
										event_dest.destination,
										fds_t_nature_animation.nature_animation
                                   FROM ( SELECT event_op.num_evenement,
												event_op.ref_nature_anim,
												event_op.ref_type_scolaire,
												event_op.id_depart,
												event_op.newcodesite,
												event_op.insee,
												event_op.operation,
												fds_t_destination.destination
                                           FROM ( SELECT fds_evenement.num_evenement,
														fds_evenement.ref_destination,
														fds_evenement.adherents,
														fds_evenement.non_adherents,
														fds_evenement.enfants,
														fds_evenement.ref_operation,
														fds_evenement.ref_nature_anim,
														fds_evenement.ref_type_scolaire,
														fds_evenement.id_depart,
														fds_evenement.newcodesite,
														fds_evenement.insee,
														fds_operation.operation
                                                   FROM fds_evenement
                                              LEFT JOIN fds_operation ON fds_evenement.ref_operation = fds_operation.ref_operation) event_op
                                      LEFT JOIN fds_t_destination ON event_op.ref_destination = fds_t_destination.ref_destination) event_dest
                              LEFT JOIN fds_t_nature_animation ON event_dest.ref_nature_anim = fds_t_nature_animation.ref_nature_anim) event_natanim
                      LEFT JOIN fds_t_type_scolaire ON event_natanim.ref_type_scolaire = fds_t_type_scolaire.ref_type_scolaire) event_scol
              LEFT JOIN sites ON event_scol.newcodesite = sites.code_site) event_site
      LEFT JOIN communes ON event_site.insee = communes.numero::bpchar) event_alljoin
   LEFT JOIN fds_evenement ON event_alljoin.num_evenement = fds_evenement.num_evenement
  ORDER BY fds_evenement.date;
