--
-- Structure de la table `domotic_sensor`
--

CREATE TABLE IF NOT EXISTS `domotic_sensor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module_id` int(11) NOT NULL,
  `sonde_type` int(10) NOT NULL,
  `sonde_valeur` decimal(10,2) NOT NULL,
  `sonde_unit` int(11) NOT NULL,
  `valeur_temp` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=50305 ;

--
-- Contenu de la table `domotic_sensor`
--

INSERT INTO `domotic_sensor` (`id`, `module_id`, `sonde_type`, `sonde_valeur`, `sonde_unit`, `valeur_temp`) VALUES
(49272, 200, 2, '40.00', 3, '2014-02-10 17:59:58'),
(49273, 200, 2, '17.00', 2, '2014-02-10 17:59:59'),
(49287, 200, 2, '17.00', 2, '2014-02-10 18:17:11');

SELECT id, MAX(sonde_valeur) AS plop FROM domotic_sensor WHERE module_id = '500' AND valeur_temp LIKE '2014-02-03 08:%' 

SELECT id, MIN(sonde_valeur) AS plop FROM domotic_sensor WHERE module_id = '500' AND valeur_temp LIKE '2014-02-03 08:%' 

SELECT id, MIN(sonde_valeur) AS plup FROM domotic_sensor WHERE module_id = '500' AND valeur_temp LIKE '2014-02-03 08:%' GROUP BY sonde_unit

SELECT id, MAX(sonde_valeur) AS plop FROM domotic_sensor WHERE module_id = '500' AND valeur_temp LIKE '2014-02-03 08:%' GROUP BY sonde_unit