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