1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| SELECT
recherche_jdm.id_publication AS id_publication,
recherche_jdm.fk_autorite_contractante AS fk_autorite_contractante,
recherche_jdm.fk_id_region AS fk_id_region,
recherche_jdm.fk_id_type_de_procedure AS fk_id_type_de_procedure,
recherche_jdm.fk_nature_de_prestation AS fk_nature_de_prestation,
recherche_jdm.date_publication_definitive AS date_publication_definitive,
recherche_jdm.date_de_cloture AS date_de_cloture,
recherche_jdm.heure_de_cloture AS heure_de_cloture,
recherche_jdm.titre AS titre,
recherche_jdm.etat_avis AS etat_avis,
recherche_jdm.montant_previsionnel_marche AS montant_previsionnel_marche,
recherche_jdm.type_publication AS type_publication,
recherche_jdm.Region AS Region,
recherche_jdm.sigle_ac AS sigle_ac,
recherche_jdm.designation_type_procedure AS designation_type_procedure,
recherche_jdm.designation_ac AS designation_ac
FROM
recherche_jdm
WHERE
recherche_jdm.etat_avis = 4 AND UPPER (recherche_jdm.titre) LIKE UPPER('%{Param2}%') AND CAST(recherche_jdm.date_publication_definitive AS DATE) BETWEEN '{Param4}' AND '{Param5}'
ORDER BY
date_publication_definitive DESC |
Partager