Nous recrutons
Maison de santé
2 bis avenue du stade
74140 Douvaine
Tél : 04 50 35 46 82
INFORMATION PRATIQUES :
Ballaison, Bons En Chablais, Brenthonne, Cervens, Chens Sur Leman, Douvaine, Excenevex, Fessy, Loisin, Lully, Massongy, Messery, Nernier, Perrignier, Sciez, Veigy, Yvoire
0.000314595703125 DESC `actualites`
0.0003860625 DESC `actualites_themes`
0.0009512060546875 SELECT DISTINCT `actualites_themes`.* FROM `actualites` LEFT JOIN `actualites_themes` ON FIND_IN_SET(actualites_themes.id,actualites.theme) WHERE 1 AND `actualites_themes`.`id` IS NOT NULL AND (`actualites`.etat = "en-ligne") AND (`actualites_themes`.etat = "en-ligne") AND (alaune="oui" ) ORDER BY
0.000341908203125 SELECT COUNT(*) FROM `actualites` WHERE 1 AND (alaune="oui" ) AND (`actualites`.etat = "en-ligne")
0.0011573544921875 SELECT DISTINCT `actualites`.* FROM `actualites` LEFT JOIN `actualites_themes` ON FIND_IN_SET(actualites_themes.id,actualites.theme) WHERE 1 AND (alaune="oui" ) AND (`actualites`.etat = "en-ligne") ORDER BY date ASC LIMIT ?,?
0.000354982421875 DESC `agenda`
0.000386640625 DESC `agenda_themes`
0.000394498046875 SELECT DISTINCT DATE_FORMAT(date, '%Y-%m-%d') FROM agenda WHERE 1 AND ( (UNIX_TIMESTAMP(date_debut) <= UNIX_TIMESTAMP(date_fin)) AND (UNIX_TIMESTAMP(date_debut) <= UNIX_TIMESTAMP(NOW())) AND (UNIX_TIMESTAMP(date_fin) >= UNIX_TIMESTAMP(NOW())) OR (UNIX_TIMESTAMP(date_fin) <= UNIX
0.0004670625 SELECT DISTINCT `agenda_themes`.* FROM `agenda` LEFT JOIN `agenda_themes` ON FIND_IN_SET(agenda_themes.id,agenda.theme) WHERE 1 AND ( (UNIX_TIMESTAMP(date_debut) <= UNIX_TIMESTAMP(date_fin)) AND (UNIX_TIMESTAMP(date_debut) <= UNIX_TIMESTAMP(NOW())) AND (UNIX_TIMESTAMP(date_fin) >= UNI
0.000226921875 SELECT COUNT(*) FROM `agenda` WHERE 1 AND ( (UNIX_TIMESTAMP(date_debut) <= UNIX_TIMESTAMP(date_fin)) AND (UNIX_TIMESTAMP(date_debut) <= UNIX_TIMESTAMP(NOW())) AND (UNIX_TIMESTAMP(date_fin) >= UNIX_TIMESTAMP(NOW())) OR (UNIX_TIMESTAMP(date_fin) <= UNIX_TIMESTAMP(date_debut)) )
0.0008810107421875 SELECT DISTINCT `agenda`.* FROM `agenda` LEFT JOIN `agenda_themes` ON FIND_IN_SET(agenda_themes.id,agenda.theme) WHERE 1 AND ( (UNIX_TIMESTAMP(date_debut) <= UNIX_TIMESTAMP(date_fin)) AND (UNIX_TIMESTAMP(date_debut) <= UNIX_TIMESTAMP(NOW())) AND (UNIX_TIMESTAMP(date_fin) >= UNIX_TIME
0.0002953251953125 DESC `temoignages`
0.000180298828125 SELECT COUNT(*) FROM `temoignages` WHERE 1 AND (afficher_accueil="oui") AND (`temoignages`.etat = "en-ligne")
0.0014475517578125 SELECT * FROM `temoignages` WHERE 1 AND (afficher_accueil="oui") AND (`temoignages`.etat = "en-ligne") ORDER BY date ASC LIMIT ?,?
0.0008980625 SELECT * FROM `pages` WHERE (FIND_IN_SET(?, lang) OR lang = '') AND `etat` = 'en-ligne' AND url <> '' AND groupe <> 'invisible' ORDER BY ordre > 0 DESC, ordre ASC, url ASC
0.0086834814453125 Total: 15