1 2 3 4 5 6 7 8 9
| $Req = " Select zppaup.NumZPPAUP,ExemplaireZPPAUP,NomCommune,Departement,Insee,Pluricommunale,SuperficieCne,SuperficieZPPAUP,Intitule,Typologie,Population,ChargeEtude,Commentaires,Situation,DateDelibEtude,";
$Req = $Req."ConvMairie ,ConvEtat , DateArreteSubv,DateDelibAvisProjet, CRPS1 ,AvisCRPS1,DateDelibCRPS1,DateArreteEP ,DateDebutEP,DateFinEP,";
$Req = $Req."Conclu,DateDelibEP,AvisABF, AvisDRAC, AvisDIREN , AvisDDE ,Synthese ,CRPS2 ,AvisCRPS2 , DateDelibApprob1 ,DateArreteCreation,";
$Req = $Req."ConvMairie ,ConvEtat , DateArreteSubv,DateDelibAvisProjet, CRPS1 ,AvisCRPS1,DateDelibCRPS1,DateArreteEP ,DateDebutEP,DateFinEP,";
$Req = $Req."Conclu,DateDelibEP,AvisABF, AvisDRAC, AvisDIREN , AvisDDE ,Synthese ,CRPS2 ,AvisCRPS2 , DateDelibApprob1 ,DateArreteCreation, MiseAJourFiche,Count(NumRecours)As Nbrecours,Count(NumModif) As NbModif,Count(NumRevision) As NbRevision ";
$Req = $Req."AnneeFin,PartEtat,MtEtat,PartCommune,MtCommune,MtTotal,ComplementFin ";
$Req = $Req."From (commune INNER JOIN concerner On concerner.NumCommune=commune.NumCommune) LEFT OUTER JOIN concerner On zppaup.NumZPPAUP=concerner.NumZPPAUP LEFT OUTER JOIN revision On revision.NumZPPAUP=zppaup.NumZPPAUP ";
$Req = $Req."LEFT OUTER JOIN recours On recours.NumZPPAUP=zppaup.NumZPPAUP LEFT OUTER JOIN modification On modification.NumZPPAUP=zppaup.NumModification LEFT OUTER JOIN financement On financement.NumZPPAUP=zppaup.NumZPPAUP ";
$Req = $Req."WHERE zppaup.NumZPPAUP=".$NumZPPAUP |
Partager