) AND dossier_autorisation_type.dossier_autorisation_type = '[dossier_autorisation_type]' AND dossier.date_decision >= '[date_decision_debut]' AND dossier.date_decision <= '[date_decision_fin]'AND avis_decision.typeavis = 'D' ORDER BY [tri], dossier.dossier"; ?>