1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
|
$sql = "SELECT
S1m.pseudo AS pseudo1, S1m.id_membre AS id_membre1,
S1.id_permutation AS id_permutation1, S1.precisions_comp as precisions_comp1,
S1from_region.nom_region AS from_region1, S1from_departement.nom_departement AS from_departement1, S1from_ville.ville_nom_reel AS from_ville1,
S1from_direction.nom_direction AS from_direction1, S1.service_from AS service_from1,
S1to_region.nom_region AS to_region1, S1to_departement.nom_departement AS to_departement1, S1to_ville.ville_nom_reel AS to_ville1,
S1to_direction.nom_direction AS to_direction1, S1.service_to AS service_to1,
S2m.pseudo AS pseudo2, S2m.id_membre AS id_membre2,
S2.id_permutation AS id_permutation2, S2.precisions_comp as precisions_comp2,
S2from_region.nom_region AS from_region2, S2from_departement.nom_departement AS from_departement2, S2from_ville.ville_nom_reel AS from_ville2,
S2from_direction.nom_direction AS from_direction2, S2.service_from AS service_from2,
S2to_region.nom_region AS to_region2, S2to_departement.nom_departement AS to_departement2, S2to_ville.ville_nom_reel AS to_ville2,
S2to_direction.nom_direction AS to_direction2, S2.service_to AS service_to2
FROM
t_permutation S1
INNER JOIN t_permutation S2 $jointure
AND (S1.statut = S2.statut)
LEFT JOIN t_membres S1m ON S1.id_membre = S1m.id_membre
LEFT JOIN t_villes S1from_ville ON S1.id_ville_from = S1from_ville.id_ville
LEFT JOIN t_departements AS S1from_departement ON S1.id_departement_from = S1from_departement.id_departement
LEFT JOIN t_regions AS S1from_region ON S1.id_region_from = S1from_region.id_region
LEFT JOIN t_villes S1to_ville ON S1.id_ville_to = S1to_ville.id_ville
LEFT JOIN t_departements AS S1to_departement ON S1.id_departement_to = S1to_departement.id_departement
LEFT JOIN t_regions AS S1to_region ON S1.id_region_to = S1to_region.id_region
LEFT JOIN t_membres S2m ON S2.id_membre = S2m.id_membre
LEFT JOIN t_villes S2from_ville ON S2.id_ville_from = S2from_ville.id_ville
LEFT JOIN t_departements AS S2from_departement ON S2.id_departement_from = S2from_departement.id_departement
LEFT JOIN t_regions AS S2from_region ON S2.id_region_from = S2from_region.id_region
LEFT JOIN t_villes S2to_ville ON S2.id_ville_to = S2to_ville.id_ville
LEFT JOIN t_departements AS S2to_departement ON S2.id_departement_to = S2to_departement.id_departement
LEFT JOIN t_regions AS S2to_region ON S2.id_region_to = S2to_region.id_region
WHERE
S1.id_ville_from = '".$_POST['dest_ville']."'
AND ((S1.id_ville_to = '".$_POST['prov_ville']."')
OR (S1.id_ville_to = 0 AND S1.id_departement_to = '".$_POST['prov_departement']."')
OR (S1.id_departement_to = 0 AND S1.id_region_to = '".$_POST['prov_region']."'))
AND S1.statut = '1'"; |
Partager