Requête : [SELECT t1.ZG_ID as id_zone,t3.DZ_TITRE as zone_titre,t2.ZG_ID as id_cont,t4.DZ_TITRE as cont_titre,count(P.pr_id) as total, CASE WHEN t2.ZG_ID=34 then 0 WHEN t2.ZG_ID=35 then 1 ELSE 2 END ordrecontinent FROM t_zone_geographique t1,t_zone_geographique t2,t_desc_zone_geo t3,t_desc_zone_geo t4, T_PROMO P, T_DESC_PROMO R, T_THEME T, T_DESC_THEME D, T_LANGUE L, T_CRITERES_5C C, T_RELAISCHATEAUX E, T_DESC_RELAISCHATEAUX D2 WHERE (t1.zg_niveau=1 or t1.zg_niveau=2) AND t1.zg_id=t3.zg_id AND E.zg_id=t1.zg_id AND t3.dz_langue=L.LANGUE_ID AND t1.T_Z_ZG_ID = t2.ZG_ID AND t2.zg_id=t4.zg_id AND t4.dz_langue=L.LANGUE_ID AND L.LANGUE_ID = 4 AND R.DP_ACTIVE = 1 AND T.TH_ID = D.TH_ID AND P.TH_ID = T.TH_ID AND P.PR_ID = R.PR_ID AND D.DTH_LANGUE = L.LANGUE_ID AND R.DP_LANGUE = L.LANGUE_ID AND D2.LANGUE_ID = L.LANGUE_ID AND E.RC_ID = D2.RC_ID AND E.RC_ID = C.RC_ID AND E.RC_ID = P.RC_ID AND SYSDATE >= P.PR_DEBUT_INLINE AND SYSDATE <= P.PR_FIN_INLINE AND E.RC_RETIRE <> -1 AND T.TH_ID= '8' group by t1.ZG_ID,t2.ZG_ID,t3.DZ_TITRE,t4.DZ_TITRE order by ordrecontinent,t4.DZ_TITRE,t3.DZ_TITRE]