Miscellany

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;