SELECT
        T.species,
        T.trueWhen,
        T.falseWhen,
    SUM(IF(T.trueWhen = HI.VALUE,1,0)) AS totalTrue,
    SUM(IF(T.falseWhen = HI.VALUE,1,0)) AS totalFalse,

    DATE(FROM_UNIXTIME(HI.clock)) AS fecha,
    HI.id_item,
    I.descriptionLong,
        I.unit,
    P.plan,
    P.id_plan,
    T.warning,
    T.critical,
    T.nominalCnt,
    P.nacd,
    P.nacu,
    CASE    WHEN T.nominal = -1 THEN (P.nacd * 1024)   WHEN T.nominal = -2 THEN (P.nacu * 1024) ELSE T.nominal END AS nominal_value,
        IF (17 > 23
        ,/* PEAK EN  DISTINTO DIA */
                IF((DATE_FORMAT(FROM_UNIXTIME(clock),"%H")>=0 AND DATE_FORMAT(FROM_UNIXTIME(clock),"%H")<= 23) OR DATE_FORMAT(FROM_UNIXTIME(clock),"%H")>= 17,"P","O")
        ,/* PEAK EN EL MISMO DIA */
                IF(DATE_FORMAT(FROM_UNIXTIME(clock),"%H")>=17 AND DATE_FORMAT(FROM_UNIXTIME(clock),"%H")<= 23,"P","O")
      ) AS type_peek
    , COUNT(*) AS "cnt"
    , AVG(HI.VALUE) AS "Avg"
    , AVG( IF( HI.value>P.nacd * 1024,
        CASE WHEN T.nominal = -1 THEN (P.nacd * 1024) WHEN T.nominal = -2 THEN (P.nacu * 1024) ELSE T.nominal END,
        HI.VALUE)
    ) AS "Qoe"

FROM     bm_host HO
INNER JOIN bm_plan P                  ON HO.id_plan   = P.id_plan
INNER JOIN bm_plan_groups PG          ON PG.id_plan   = P.id_plan AND PG.groupid = HO.groupid
INNER JOIN (
SELECT * FROM bm_history bh WHERE bh.clock BETWEEN UNIX_TIMESTAMP("2019/03/11 00:00:00")  AND UNIX_TIMESTAMP("2019/03/17 23:59:59" )
AND id_item IN (23961,24365,22749,23153,27603,23557,24769,25173,25579,25983,22761,23165,27615,23569,23973,24377,24781,25185,25591,25995,22725,23129,27579,23533,23937,24341,24341,24745,25149,25555,25959,22773,23177,23581,27627,23985,24389,24793,25197,25603,26007,23964,24368,22752,23156,23560,27606,24772,25176,25582,25986,22764,23168,23572,27618,23976,24380,24784,25188,25594,25998,22728,23132,23536,27582,23940,24344,24748,25152,25558,25962,22776,23180,27630,23584,23988,24392,24796,25200,25606,26010,23970,24374,22758,23162,27612,23566,24778,25182,25588,25992,22770,23174,27624,23578,23982,24386,24790,25194,25600,26004,22734,23138,23542,27588,23946,24350,24754,25158,25564,25968,22782,23186,27636,23590,23994,24398,24802,25206,25612,26016)
) HI ON HI.id_host = HO.id_host
INNER JOIN bm_threshold T ON T.id_item = HI.id_item
INNER JOIN bm_items I ON  I.`id_item` = HI.id_item
WHERE   HO.borrado = 0  AND HO.groupid = "8"
GROUP BY HI.id_item,P.id_plan, fecha, type_peek
ORDER BY I.descriptionLong,nacD,  P.`id_plan`, fecha DESC