SELECT * , pmt.project_id as "projetid", pmb.board_id as "cycleid" , COUNT(pmt.project_id) as "Total",SUM(pmt.status) as "Tache" , UNIX_TIMESTAMP(STR_TO_DATE(CONCAT(NOW()), "%Y-%m-%d %k:%i:%s")) as "nowdate" , datefincycle, UNIX_TIMESTAMP(STR_TO_DATE(CONCAT(datefincycle, " 21:00:00"), "%d/%m/%Y %k:%i:%s")) as "datefincycles" FROM wpvy_pm_statut_cycle pmsc, wpvy_pm_tasks pmt, wpvy_pm_boardables pmb WHERE pmt.id = pmb.id and pmb.board_id = pmsc.idcycle and UNIX_TIMESTAMP(STR_TO_DATE(CONCAT(NOW()), "%Y-%m-%d %k:%i:%s ")) BETWEEN (UNIX_TIMESTAMP(STR_TO_DATE(CONCAT(datefincycle, " 10:00:00"), "%d/%m/%Y %k:%i:%s")) ) and (UNIX_TIMESTAMP(STR_TO_DATE(CONCAT(datefincycle, " 22:59:59"), "%d/%m/%Y %k:%i:%s")) ) and pmsc.statutcycle not in (50,40) GROUP BY pmb.board_id <br><br>