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.00036637915039062 DESC `actualites`
0.00037378686523438 DESC `actualites_themes`
0.00082874291992188 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.00028335815429688 SELECT COUNT(*) FROM `actualites` WHERE 1 AND (alaune="oui" ) AND (`actualites`.etat = "en-ligne")
0.0018081149902344 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.00028296899414062 DESC `agenda`
0.00033836889648437 DESC `agenda_themes`
0.00034855004882813 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.00038041821289062 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.00020146997070312 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.00066538110351563 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.00042078393554687 DESC `temoignages`
0.00015885620117188 SELECT COUNT(*) FROM `temoignages` WHERE 1 AND (afficher_accueil="oui") AND (`temoignages`.etat = "en-ligne")
0.0011740698242187 SELECT * FROM `temoignages` WHERE 1 AND (afficher_accueil="oui") AND (`temoignages`.etat = "en-ligne") ORDER BY date ASC LIMIT ?,?
0.00068215307617188 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.00831340234375 Total: 15