Symfony Profiler

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND resolution IN ("remonte", "remonté")

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 2 AND l.rgt <= 543
                 AND resolution IN ("remonte", "remonté") ;

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND resolution IN (
    "resolu", "résolu", "true", "resolved"
  )

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164
                 AND resolution IN ("resolu", "résolu", "true", "resolved") ;

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND HOUR(s.heure) = 21
  AND resolution is not NULL

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164
                 AND HOUR(s.heure) = 21 AND resolution is not NULL;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenoms AS prenoms_3,
  t0.adresse AS adresse_4,
  t0.statut AS statut_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.gestionnaire_id AS gestionnaire_id_8,
  t0.user_id AS user_id_9,
  t10.id AS id_11,
  t10.idpv AS idpv_12,
  t10.libelle AS libelle_13,
  t10.nbi AS nbi_14,
  t10.nbh AS nbh_15,
  t10.nbf AS nbf_16,
  t10.lieu_id AS lieu_id_17,
  t10.observateur_id AS observateur_id_18,
  t0.zone_id AS zone_id_19,
  t0.zon_id AS zon_id_20
FROM
  agent t0
  LEFT JOIN poste t10 ON t10.observateur_id = t0.id
WHERE
  t0.zone_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenoms AS prenoms_3, t0.adresse AS adresse_4, t0.statut AS statut_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.gestionnaire_id AS gestionnaire_id_8, t0.user_id AS user_id_9, t10.id AS id_11, t10.idpv AS idpv_12, t10.libelle AS libelle_13, t10.nbi AS nbi_14, t10.nbh AS nbh_15, t10.nbf AS nbf_16, t10.lieu_id AS lieu_id_17, t10.observateur_id AS observateur_id_18, t0.zone_id AS zone_id_19, t0.zon_id AS zon_id_20 FROM agent t0 LEFT JOIN poste t10 ON t10.observateur_id = t0.id WHERE t0.zone_id = '101';

SELECT
  t0.id AS id_1,
  t0.niveau AS niveau_2,
  t0.appelation AS appelation_3
FROM
  decoupage t0

SELECT t0.id AS id_1, t0.niveau AS niveau_2, t0.appelation AS appelation_3 FROM decoupage t0;

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND HOUR(s.heure) = 6
  AND resolution is not NULL

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164
                 AND HOUR(s.heure) = 6 AND resolution is not NULL;

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND HOUR(s.heure) = 20
  AND resolution is not NULL

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164
                 AND HOUR(s.heure) = 20 AND resolution is not NULL;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.lat AS lat_3,
  t0.lon AS lon_4,
  t0.lft AS lft_5,
  t0.lvl AS lvl_6,
  t0.rgt AS rgt_7,
  t0.nbe AS nbe_8,
  t0.decoupage_id AS decoupage_id_9,
  t0.superviseur_id AS superviseur_id_10,
  t0.circonscription_id AS circonscription_id_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13,
  t0.circ_id AS circ_id_14,
  t15.id AS id_16,
  t15.nom AS nom_17,
  t15.prenoms AS prenoms_18,
  t15.adresse AS adresse_19,
  t15.statut AS statut_20,
  t15.created_at AS created_at_21,
  t15.updated_at AS updated_at_22,
  t15.gestionnaire_id AS gestionnaire_id_23,
  t15.user_id AS user_id_24,
  t15.zone_id AS zone_id_25,
  t15.zon_id AS zon_id_26
FROM
  lieu t0
  LEFT JOIN agent t15 ON t15.zone_id = t0.id
WHERE
  t0.decoupage_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.lat AS lat_3, t0.lon AS lon_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.nbe AS nbe_8, t0.decoupage_id AS decoupage_id_9, t0.superviseur_id AS superviseur_id_10, t0.circonscription_id AS circonscription_id_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.circ_id AS circ_id_14, t15.id AS id_16, t15.nom AS nom_17, t15.prenoms AS prenoms_18, t15.adresse AS adresse_19, t15.statut AS statut_20, t15.created_at AS created_at_21, t15.updated_at AS updated_at_22, t15.gestionnaire_id AS gestionnaire_id_23, t15.user_id AS user_id_24, t15.zone_id AS zone_id_25, t15.zon_id AS zon_id_26 FROM lieu t0 LEFT JOIN agent t15 ON t15.zone_id = t0.id WHERE t0.decoupage_id = 1;

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND HOUR(s.heure) = 22
  AND resolution is not NULL

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164
                 AND HOUR(s.heure) = 22 AND resolution is not NULL;

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND HOUR(s.heure) = 16
  AND resolution is not NULL

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164
                 AND HOUR(s.heure) = 16 AND resolution is not NULL;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.lat AS lat_3,
  t0.lon AS lon_4,
  t0.lft AS lft_5,
  t0.lvl AS lvl_6,
  t0.rgt AS rgt_7,
  t0.nbe AS nbe_8,
  t0.decoupage_id AS decoupage_id_9,
  t0.superviseur_id AS superviseur_id_10,
  t0.circonscription_id AS circonscription_id_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13,
  t0.circ_id AS circ_id_14,
  t15.id AS id_16,
  t15.nom AS nom_17,
  t15.prenoms AS prenoms_18,
  t15.adresse AS adresse_19,
  t15.statut AS statut_20,
  t15.created_at AS created_at_21,
  t15.updated_at AS updated_at_22,
  t15.gestionnaire_id AS gestionnaire_id_23,
  t15.user_id AS user_id_24,
  t15.zone_id AS zone_id_25,
  t15.zon_id AS zon_id_26
FROM
  lieu t0
  LEFT JOIN agent t15 ON t15.zone_id = t0.id
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.lat AS lat_3, t0.lon AS lon_4, t0.lft AS lft_5, t0.lvl AS lvl_6, t0.rgt AS rgt_7, t0.nbe AS nbe_8, t0.decoupage_id AS decoupage_id_9, t0.superviseur_id AS superviseur_id_10, t0.circonscription_id AS circonscription_id_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.circ_id AS circ_id_14, t15.id AS id_16, t15.nom AS nom_17, t15.prenoms AS prenoms_18, t15.adresse AS adresse_19, t15.statut AS statut_20, t15.created_at AS created_at_21, t15.updated_at AS updated_at_22, t15.gestionnaire_id AS gestionnaire_id_23, t15.user_id AS user_id_24, t15.zone_id AS zone_id_25, t15.zon_id AS zon_id_26 FROM lieu t0 LEFT JOIN agent t15 ON t15.zone_id = t0.id WHERE t0.nom = 'BENIN' LIMIT 1;

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND HOUR(s.heure) = 23
  AND resolution is not NULL

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164
                 AND HOUR(s.heure) = 23 AND resolution is not NULL;

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND HOUR(s.heure) = 17
  AND resolution is not NULL

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164
                 AND HOUR(s.heure) = 17 AND resolution is not NULL;

SELECT
  l0_.id AS id_0,
  l0_.nom AS nom_1,
  l0_.lat AS lat_2,
  l0_.lon AS lon_3,
  l0_.lft AS lft_4,
  l0_.lvl AS lvl_5,
  l0_.rgt AS rgt_6,
  l0_.nbe AS nbe_7,
  l0_.decoupage_id AS decoupage_id_8,
  l0_.superviseur_id AS superviseur_id_9,
  l0_.circonscription_id AS circonscription_id_10,
  l0_.tree_root AS tree_root_11,
  l0_.parent_id AS parent_id_12,
  l0_.circ_id AS circ_id_13
FROM
  lieu l0_
WHERE
  l0_.parent_id = ?
  AND l0_.tree_root = ?
ORDER BY
  l0_.nom ASC

SELECT l0_.id AS id_0, l0_.nom AS nom_1, l0_.lat AS lat_2, l0_.lon AS lon_3, l0_.lft AS lft_4, l0_.lvl AS lvl_5, l0_.rgt AS rgt_6, l0_.nbe AS nbe_7, l0_.decoupage_id AS decoupage_id_8, l0_.superviseur_id AS superviseur_id_9, l0_.circonscription_id AS circonscription_id_10, l0_.tree_root AS tree_root_11, l0_.parent_id AS parent_id_12, l0_.circ_id AS circ_id_13 FROM lieu l0_ WHERE l0_.parent_id = '1' AND l0_.tree_root = '1' ORDER BY l0_.nom ASC;

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND resolution is not NULL

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164
                 AND resolution is not NULL;

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND HOUR(s.heure) = 18
  AND resolution is not NULL

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164
                 AND HOUR(s.heure) = 18 AND resolution is not NULL;

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND HOUR(s.heure) = 11
  AND resolution is not NULL

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164
                 AND HOUR(s.heure) = 11 AND resolution is not NULL;

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND HOUR(s.heure) = 19
  AND resolution is not NULL

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164
                 AND HOUR(s.heure) = 19 AND resolution is not NULL;

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND HOUR(s.heure) = 14
  AND resolution is not NULL

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164
                 AND HOUR(s.heure) = 14 AND resolution is not NULL;

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND HOUR(s.heure) = 15
  AND resolution is not NULL

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164
                 AND HOUR(s.heure) = 15 AND resolution is not NULL;

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND HOUR(s.heure) = 12
  AND resolution is not NULL

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164
                 AND HOUR(s.heure) = 12 AND resolution is not NULL;

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND HOUR(s.heure) = 7
  AND resolution is not NULL

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164
                 AND HOUR(s.heure) = 7 AND resolution is not NULL;

SELECT
  COUNT(*) as incidents
FROM
  type_msg t
  INNER JOIN sms s ON s.type_msg_id = t.id
  INNER JOIN numero n ON s.sender_num_id = n.id
  INNER JOIN agent a ON n.agent_id = a.id
  INNER JOIN poste p ON a.id = p.observateur_id
  INNER JOIN lieu l ON p.lieu_id = l.id
WHERE
  t.code LIKE :alt
  AND l.lft >= :lft
  AND l.rgt <= :rgt
  AND HOUR(s.heure) = 9
  AND resolution is not NULL

SELECT COUNT(*) as incidents
                FROM type_msg t INNER JOIN sms s ON s.type_msg_id =  t.id INNER JOIN numero n ON s.sender_num_id = n.id
                 INNER JOIN   agent a ON n.agent_id = a.id INNER JOIN poste p ON a.id = p.observateur_id INNER JOIN lieu l ON p.lieu_id = l.id
                WHERE t.code LIKE 'alt%' AND l.lft >= 1 AND l.rgt <= 7164
                 AND HOUR(s.heure) = 9 AND resolution is not NULL;