Seminars

View all ...This week

«
Week 11
from Mar 11, 2024 to Mar 17, 2024
»

get_all

SELECT a.*, b.type, b.id_unit, c.localisation, d.nom_centre, DATE_FORMAT(a.date,"%d/%m/%Y à %H:%i ") as Date, DATE_FORMAT(a.date,"%a, %b %D, %Y - %H:%i ") AS Date_en, DATE_FORMAT(a.date,"Du %d/%m/%Y ") as date_debut, DATE_FORMAT(a.date,"%a, %b %d, %Y ") as date_debut_en, DATE_FORMAT(a.date,'%Y-%m-%d') as dateS, DATE_FORMAT(a.date,'%Y') as anneeS, DATE_FORMAT(a.date,'%m') as moiS, DATE_FORMAT(a.date,'%d') as jourS, DATE_FORMAT(a.date,'%w') as Jour, DATE_FORMAT(a.date,'%H') as heureS, DATE_FORMAT(a.date,'%H:%i') as heure, DATE_FORMAT(a.date,'%i') as minS, UNIX_TIMESTAMP(a.date) as dateTimestamp, DATE_FORMAT(a.date_initiale,'%Y-%m-%d') as dateFS, DATE_FORMAT(a.date_initiale,"au %d/%m/%Y ") as date_fin, DATE_FORMAT(a.date_initiale,'to %a, %b %d, %Y ') as date_fin_en, DATE_FORMAT(a.date_initiale,'%a, %b %d, %Y - %H:%i ') as DateF_en, DATE_FORMAT(a.date_initiale,'%Y') as anneeFS, DATE_FORMAT(a.date_initiale,'%m') as moiFS, DATE_FORMAT(a.date_initiale,'%d') as jourFS, DATE_FORMAT(a.date_initiale,'%H') as heureFS, DATE_FORMAT(a.date_initiale,'%i') as minFS, DATE_FORMAT(a.date_initiale,'%H:%i') as heureF, UNIX_TIMESTAMP(a.date_initiale) as dateTimestampF, b.jour_seminaire as jourDef, TIME_FORMAT(b.heure_seminaire,'%Hh%i') as heureDef, b.id_localisation_seminaire as locDef FROM tbl_seminaires a, tbl_seminaires_description b, tbl_localisation c, tbl_centre d WHERE a.publiable LIKE 'oui' AND a.serveur LIKE '%2%' AND (a.id_type=7 OR a.id_type=13 OR a.id_type=8 OR a.id_type=17 OR a.id_type=21 OR a.id_type=22 OR a.id_type=6 OR a.id_type=24 OR a.id_type=25 OR a.id_type=29 OR a.id_type=23 OR a.id_type=11 OR a.id_type=18 OR a.id_type=5 OR a.id_type=4 OR a.id_type=10 OR a.id_type=1 OR a.id_type=2 OR a.id_type=9 OR a.id_type=26 OR a.id_type=27 OR a.id_type=3 OR a.id_type=14 OR a.id_type=19 OR a.id_type=28 OR a.id_type=12 OR a.id_type=16 OR a.id_type=15 OR a.id_type=20) AND a.id_type = b.id_type AND a.id_localisation = c.id_localisation AND c.id_centre = d.id_centre AND a.date like '%2024-03-11%' ORDER By a.date asc

SQLSTATE[HY000]: General error: 1021 Disk full (/var/tmp/#sql_520_0); waiting for someone to free some space...