SELECT 
		fanny_dernier_troncon_section_depart.num_quai_depart
		, fanny_dernier_troncon_section_depart.num_quai_arrive
		, troncon.id_voie
		, IF( b1.pk_amont < b1.pk_aval, b1.pk_aval, b1.pk_amont ) AS pk_b1
		, IF( b2.pk_amont > b2.pk_aval, b2.pk_amont, b2.pk_aval ) AS pk_b2
	FROM fanny_dernier_troncon_section_depart
	 JOIN fanny_quai ON fanny_dernier_troncon_section_depart.num_quai_depart = fanny_quai.num_quai
	 JOIN troncon tr1 ON fanny_quai.code_troncon = tr1.cle_externe
	 JOIN bief b1 ON tr1.id_bief = b1.id_bief
	 JOIN troncon ON fanny_dernier_troncon_section_depart.troncon = troncon.cle_externe
	 JOIN bief b2 ON b2.id_bief = troncon.id_bief;