SELECT act_num_ale, count(activite.id), ale.ale_var_lib FROM ale,projet_activite,activite LEFT JOIN plan_activite ON plan_activite.pla_num_act = activite.id WHERE ale.id=act_num_ale AND projet_activite.act_num_id = activite.id AND pro_num_id IN (2786,4404,4631,1906,4983,4984,10959,13469) AND act_num_ale IN (1502,1501,1497,1498,1500,2068,1499,5445,258,6116,7033,1969,7132,1270,1284,5424,1279,1276,1283,1277,5419,153,1716,1297,1266,1280,5427,1264,1720,1267,1402,1401,5430,1296,1712,5435,165,166,164,1715,1404,1298,154,5416,156,5414,155,157,158,159,1268,1221,160,1403,162,1278,1281,1282,161,1265,5422,1269,581,549,548,554,552,583,575,557,564,579,577,551,4940,572,574,563,568,559,6657,556,6656,570,2276,569,6658,565,585,573,567,558,566,578,580,561,6647,6648,6649,6650,6651,571,555,576,582,553,550,562,584,256,255,254,257,252,253,7225,5661,7028,7029,7025,7026,7032,3529,1872,1898,4146,1866,7129,7130,7127,7128,7131,163,6522,6524,6515,6520,6521,6516,6517,6519,6518,6523,3473,560,1881,5432,5446,6527,8004) AND act_num_sup =0 AND ( act_hor_pla =1 OR ( pla_tms_act >= '20120625000000' AND pla_tms_act <= '20121224000000' AND (pla_num_per1 >0 OR pla_num_per2 >0 OR pla_num_per3 >0 OR pla_num_per4 >0 OR pla_num_per5 >0 OR pla_num_per6 >0 ))) GROUP BY act_num_ale, ale.ale_var_lib ORDER BY ale.ale_var_lib
Partager