SELECT * FROM planning WHERE onoff='0' AND valid='0'AND type='Atelier' ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'AND type='Stand' ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'AND type='Conférence' ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'AND type='Débat citoyen' ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'AND type='Partage de pépites' ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'AND type='Vidéo projection' ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'AND type='Temps collectif' ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'AND type='Spectacle' ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'AND type='Musique' ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'AND type='Autre' ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'AND type='Conférence inversée' ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'AND type='Contes' ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'AND type='Cercle' ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'AND type='Conférence chantée' ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'AND type='Cercle de chant' ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'AND type='Artistique et Bien être' ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'  AND type='1'  ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'  AND type='2'  ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'  AND type='3'  ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'  AND type='4'  ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'  AND type='5'  ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'  AND type='6'  ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'  AND type='7'  ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'  AND type='8'  ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'  AND type='9'  ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'  AND type='10'  ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'  AND type='13'  ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'  AND type='14'  ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'  AND type='15'  ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'  AND type='16'  ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'  AND type='21'  ORDER BY jour, CAST(heure AS UNSIGNED)SELECT * FROM planning WHERE onoff='0' AND valid='0'  AND type='22'  ORDER BY jour, CAST(heure AS UNSIGNED)