prog/boffice/fin.txt

1 line
3.5 KiB
Plaintext

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)