-- remplacer par cmd_id
SELECT
          DISTINCT commands_on_host.start_date as dated,
          commands_on_host.end_date as datef
      FROM
              commands_on_host
                  INNER JOIN
              target ON target.id = commands_on_host.fk_target
      WHERE
              commands_on_host.fk_commands = 4
      ORDER BY dated DESC
      LIMIT 1;

+---------------------+---------------------+
| dated               | datef               |
+---------------------+---------------------+
| 2020-12-06 16:21:54 | 2020-12-07 16:21:54 |
+---------------------+---------------------+


-- remplacer par commands_id, date début, date fin obtenu juste au dessus
SELECT
  GROUP_CONCAT(DISTINCT target_uuid SEPARATOR ',') as listuuid
FROM
  (SELECT
    commands_on_host.fk_commands,
    target.target_name as dname,
    target.target_uuid
  FROM
    commands_on_host
  INNER JOIN
    target ON target.id = commands_on_host.fk_target
  WHERE
    commands_on_host.fk_commands = 4  and
    commands_on_host.start_date <= "2020-12-06 16:21:54" ands
    commands_on_host.end_date >= '2020-12-07 16:21:54'
    ) as listhost;

 UUID3648,UUID3649,UUID2793,UUID4865,UUID3642,UUID3643,UUID3640,UUID3641,UUID3646,UUID3647,UUID3644,UUID3645,UUID3888,UUID3889,UUID2684,UUID3880,UUID3881,UUID3882,UUID3883,UUID3884,UUID3885,UUID3886,UUID3887,UUID2201,UUID2200,UUID2203,UUID2202,UUID2205,UUID2204,UUID2207,UUID2206,UUID2209,UUID2208,UUID4316,UUID4384,UUID3258,UUID2791,UUID3592,UUID4560,UUID4749,UUID4579,UUID4845,UUID4319,UUID2676,UUID3080,UUID3081,UUID3082,UUID3083,UUID3084,UUID3085,UUID3086,UUID3087,UUID3088,UUID3089,UUID4951,UUID2790,UUID3593,UUID2123,UUID4950,UUID4513,UUID3248,UUID3249,UUID3246,UUID3247,UUID3244,UUID3245,UUID3242,UUID3243,UUID3240,UUID3241,UUID4923,UUID3762,UUID4388,UUID4890,UUID4389,UUID2963,UUID899,UUID898,UUID897,UUID896,UUID895,UUID894,UUID893,UUID892,UUID891,UUID890,UUID3769,UUID3768,UUID4346,UUID4744,UUID4511,UUID4768,UUID2361,UUID4578,UUID2367,UUID4510,UUID4873,UUID3308,UUID3979,UUID4885,UUID4884,UUID4887,UUID3043,UUID4881,UUID4880,UUID4883,UUID4882,UUID3597,UUID4597,UUID4517,UUID4888,UUID2656,UUID419,UUID418,UUID2657



SELECT
    `glpi_computers`.`id` AS `id`,
    `glpi_computers`.`name` AS `name`,
    `glpi_computers`.`comment` AS `description`,
    `glpi_operatingsystems`.name AS `os`,
    `glpi_computertypes`.`name` AS `type`,
    `glpi_computers`.`contact` AS `contact`,
    `glpi_entities`.`name` AS `entity`
FROM
    `glpi`.`glpi_computers`
LEFT JOIN
    `glpi_operatingsystems` ON `glpi`.`glpi_computers`.`operatingsystems_id` = `glpi_operatingsystems`.`id`
LEFT JOIN
    `glpi`.`glpi_computertypes` ON `glpi`.`glpi_computers`.`computertypes_id` = `glpi_computertypes`.`id`
LEFT JOIN
    `glpi`.`glpi_entities` ON `glpi`.`glpi_computers`.`entities_id` = `glpi`.`glpi_entities`.`id`
WHERE
    `glpi_computers`.`is_template` = 0
AND `glpi_computers`.`is_deleted` = 0
AND  `glpi_computers`.`id` in ("UUID3648,UUID3649,UUID2793,UUID4865,UUID3642,UUID3643,UUID3640,UUID3641,UUID3646,UUID3647,UUID3644,UUID3645,UUID3888,UUID3889,UUID2684,UUID3880,UUID3881,UUID3882,UUID3883,UUID3884,UUID3885,UUID3886,UUID3887,UUID2201,UUID2200,UUID2203,UUID2202,UUID2205,UUID2204,UUID2207,UUID2206,UUID2209,UUID2208,UUID4316,UUID4384,UUID3258,UUID2791,UUID3592,UUID4560,UUID4749,UUID4579,UUID4845,UUID4319,UUID2676,UUID3080,UUID3081,UUID3082,UUID3083,UUID3084,UUID3085,UUID3086,UUID3087,UUID3088,UUID3089,UUID4951,UUID2790,UUID3593,UUID2123,UUID4950,UUID4513,UUID3248,UUID3249,UUID3246,UUID3247,UUID3244,UUID3245,UUID3242,UUID3243,UUID3240,UUID3241,UUID4923,UUID3762,UUID4388,UUID4890,UUID4389,UUID2963,UUID899,UUID898,UUID897,UUID896,UUID895,UUID894,UUID893,UUID892,UUID891,UUID890,UUID3769,UUID3768,UUID4346,UUID4744,UUID4511,UUID4768,UUID2361,UUID4578,UUID2367,UUID4510,UUID4873,UUID3308,UUID3979,UUID4885,UUID4884,UUID4887,UUID3043,UUID4881,UUID4880,UUID4883,UUID4882,UUID3597,UUID4597,UUID4517,UUID4888,UUID2656,UUID419,UUID418,UUID2657");