Nous recrutons
Saviez-vous que des assistantes sociales font partie de nos équipes pluridisciplinaires ? Elles proposent un espace d'écoute confidentiel aux salariés confrontés à des difficultés personnelles et/ou sociales. L'accès à leurs services est inclus dans la cotisation annuelle. Nous vous proposons un aperçu de leur rôle auprès des salariés et des entreprises avec Lydie TRICOIRE, assistante sociale chez AST74.
0.000415162109375 DESC `actualites`
0.0004211669921875 DESC `actualites_themes`
0.0009668291015625 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.0003490009765625 SELECT COUNT(*) FROM `actualites` WHERE 1 AND (alaune="oui" ) AND (`actualites`.etat = "en-ligne")
0.0020826540527344 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.00032277001953125 DESC `agenda`
0.000368001953125 DESC `agenda_themes`
0.00041561303710937 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.00066561181640625 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.00023135595703125 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.00089327197265625 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.000306130859375 DESC `temoignages`
0.00018786083984375 SELECT COUNT(*) FROM `temoignages` WHERE 1 AND (afficher_accueil="oui") AND (`temoignages`.etat = "en-ligne")
0.00090138403320313 SELECT * FROM `temoignages` WHERE 1 AND (afficher_accueil="oui") AND (`temoignages`.etat = "en-ligne") ORDER BY date ASC LIMIT ?,?
0.0031150068359375 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.011641820556641 Total: 15