select CEN_SYS_FROM_ID as ID,CEN_MDT_NUMERO_ADHERENT,CEN_SYS_FROM_ID,CEN_MDT_TYPE_AFFAIRE_INT,CEN_MDT_TYPE_AFFAIRE,CEN_MDT_TYPE_TRANSACTION_INT,CEN_MDT_TYPE_TRANSACTION,CEN_MDT_EST_EXCLUSIF,CEN_VTE_PRIX_VENTE,CEN_LOC_LOYER_MENSUEL_CC,CEN_LOC_LOYER_MENSUEL_HC,CEN_LOC_PROVISION_POUR_CHARGES,CEN_VTE_HONORAIRE_VENDEUR,CEN_VTE_HONORAIRE,CEN_ENV_EST_CODE_POSTAL_VISIBLE,CEN_ENV_CODE_INSEE,CEN_NFO_SURFACE,CEN_ENV_CODE_POSTAL,CEN_ENV_COMMUNE,CEN_LOC_EST_MEUBLE,CEN_IMAGE_PATH,CEN_LGM_NBR_PIECES,CEN_NFO_DESCRIPTION,CEN_MDT_NUMERO_AFFAIRE,CEN_AGE_NOM,CEN_DSC_SITUATION_FR,CEN_DSC_VIDEO_1,CEN_EQT_A_GARAGE_PARKING,CEN_ENV_DEP_VDF_ID,CASE WHEN CEN_LOC_LOYER_MENSUEL_CC = -1 THEN CEN_LOC_LOYER_MENSUEL_HC ELSE CEN_LOC_LOYER_MENSUEL_CC END as TRI_PRIX
from t_centralisation where CEN_MDT_TYPE_TRANSACTION_INT = :CEN_MDT_TYPE_TRANSACTION_INT and (CEN_MDT_TYPE_AFFAIRE_INT = :CEN_MDT_TYPE_AFFAIRE_INT0) and (CEN_ENV_CODE_INSEE = :CEN_ENV_CODE_INSEE0) order by CEN_VTE_PRIX_VENTE asc,TRI_PRIX asc,CEN_MDT_DTE_CREATION desc limit 12