Nous recrutons
Bien au-delà du suivi médical des salariés, nous proposons une offre de services complète pour tous nos adhérents, en contrepartie de leur cotisation annuelle. Ces services sont déclinés sur trois volets principaux :
Téléchargez ici la synthèse de cette offre, qui rassemble les fiches d'information pratiques éditées par Présanse.
0.0003025693359375 DESC `actualites`
0.0003728037109375 DESC `actualites_themes`
0.000893271484375 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.0003494931640625 SELECT COUNT(*) FROM `actualites` WHERE 1 AND (alaune="oui" ) AND (`actualites`.etat = "en-ligne")
0.0012058583984375 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.00030118359375 DESC `agenda`
0.000330705078125 DESC `agenda_themes`
0.0004001044921875 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.0003958984375 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.000305349609375 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.000859638671875 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.0002832333984375 DESC `temoignages`
0.000177228515625 SELECT COUNT(*) FROM `temoignages` WHERE 1 AND (afficher_accueil="oui") AND (`temoignages`.etat = "en-ligne")
0.0015119404296875 SELECT * FROM `temoignages` WHERE 1 AND (afficher_accueil="oui") AND (`temoignages`.etat = "en-ligne") ORDER BY date ASC LIMIT ?,?
0.000904728515625 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.0085940068359375 Total: 15