A6XBO5o7xheFPmNriZCYh6UDF6s7Ctlk+LffKtEYd0d6422acOnUS6dBOf3pCBWFkwjGmQoN7Dw2cvSL+MdbteC3/jFj5UR5t4t8ZZCNbCV5Id/aVG/auHBu9i4yczU+MKWFCRptxy6dZW4eZFCse1hpKnsICWbsoGp8+7gKwaNnIAbkARtl76Mc19sTGABO14Mnl6da7mk+DPzvcPIaVFc5+6OEjU9ZWm0HFzSQ8q91HO+fWcsyBGjnmoXxkKnIevJlJ/tu6IRufXOb1MT4Txfzc2oI3LFLPgDOLHdiu4x4PxjjgR+g2r99uDORwY/c8VqPMzPfLc0UdIuerN5xzilWyLBhpjLLve+QWNASMg6y+lYXl2RzpxCtMShyZ9gCaaELuDuO5WheWX/i7QQqcGa9IkcZG0L/38m2nPhd/RwEff5rc4YRXLVF/m2yml3J3yzQUuGowWU0fqh3cij+Y647F2oUIlVCAncqSRnXTV6u/0cPPXKYqY39VNpDKjce3MSjuw1WHLFXp8XF3EeKZPjfx26U0ybbIyb3Sp8MuP57U0t6H0eAJrqr0ZjjP+ahAIokwEDzZrpVHt43xtcqez449V+AENlScu1xqDIjnepF5xWQVYexNGly2Pqy5h9pTl9EF1FdHofQ6dg+zlOaXQtnnzEF/lBb2NV7yf7KqJqcCHU6beIeO6bW9wIUs7+sEM2fl7rCHq4gNyWEy8rh4r3/eDpvZ76B0+Nz9pcBIMwYTffOFo4/dVkoma5B4wLOKlJ+PpQZb7SwP1o8JKIHA6Xxl/N+kz6582bbrc3Mzm3xvoLh+7cnRHqG7Ml5awi/pgIjNxH9yfVb5UXR20GeJ5tQX30XjAvcmjjk2QiGlDwArZgCM4i122mbweexAgNDdWXoEjNTTPO7HVv7KWkSxwcIl3Ef3QVxTqY/tFF+hlUwczjJTmwlK8+2sdlrvO824bLiFwSiLcYn8FGLzL63qAxinZkl1HwIUN8H4st50NgYggemGQrEerzq8791Wxf2sdPajS5hpHL7TS+pLlx9sH4hexvFKkmQaRk3RF76NzCbgTcOvWg7qN2uKvrXG8heSZFJ+0EhephlPXoSIyCBLoSWeapkp5KXv24Npm7cxTTSlujKjUIRdUkWrtetlCDxBZv95J/rWW4Bhv5KhoRGoq0SUyYv4n4LQk3G4in6t0Zdi8zSCKtDANrLjNAzGMAannGFFqvVNVS3xMKaUdZxT2Jdmt8EDWxGxgjyH9R355QpGbHiA6YawOtzLkQQ1sSwwuvb/zoYy1lHjCSPGSBxDE/Q99l5zD6eL1Sd0+j/BjkkP4cFSXt+lQ58WbzbXCnbzReYk9hM25WRl6k9pYGftkRWqr70PeotWiJsbUY=
1 - SELECT et.id, et.residence, et.bottin, et.emploi, et.msss, (eev.dateFin > NOW()) as vedette FROM emplois_temp et
LEFT JOIN envois_eer_emplois_vedette eev ON eev.emploi = et.id AND eev.dateFin > NOW()
LEFT JOIN residences r2 ON r2.id = et.residence WHERE et.bottin = AND (r2.emplois_masques != '1' OR r2.emplois_masques IS NULL) AND
((SELECT desapprouve FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0')
AND (SELECT affiche FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '1'
AND (
et.residence in (select res_id from utilisateurs where res_id > 0)
OR
et.bottin in (select serv_id from utilisateurs where serv_id > 0)
OR
et.msss in (select msss_id from utilisateurs where msss_id > 0)
OR
r2.groupe in (select res_groupe_id from utilisateurs where res_groupe_id > 0)
)
GROUP BY et.id
LIMIT 100