+tn3h15OPLM3hu3p+3GuSeO7UVEH3krGs1G07NEEtrIuXqsM/BEiUXUVM2KE2EtwW1VYi0lzr4/OXbhVBRKbyiwjSaW++S211xunMKvsDiSnVGKw9+3S/GC/zn/W/FgWVQEVj+d69NSEoKCkmedkcorvJWV3qrfYx+Asp7jwjv19KHm2kT2BRKi8SPezG7/mjaJzeIdxOPEitJex26lYbV/snbIKrNo5OUG1dwAN543CqGYR+bMIcmB6YTs2aLGYxo92Ptzt0baoZh/JygKs7m6DRqcQWXF2EQ38eo97gUlLpFbMTFSxOnzg3fg5r+iCMN8z0lL+UimhOC1xfaC3t/e6+0iFBWWWTwn5v1I3bP90fbPwN8Hmog4/69fnFTySDYKjnDk1mhFNnyp++B61xkjYe8pvBR7cI3GykmVHjc3D6rO+zvjcCSPnxb/w/4IdPog6FDLYVqJDBKNDOjM1le4oNjUChnatdXMUeWUiKDsfSzbQexZeE0oPJ97kqvDEgmj4xQFLYGB6l+yp5DBa88yaA2NiA7yO73pFwd0SAEUHCDbyln/F7dWS+a/kDi7AYmhNuPqV6fJi+cStfD0je6XkCVDBCzeCBWZyLh3xz7MqZr+vN58V9usjjXkEh4zhcj50UMLX/514xAxWZaZ0/Z1XSXcXusLqNqWYr13RaKOdcoZSY5i4RVwqACTe5ug5CMeZLpZf8qc1pWYapHGBdrHPHOIu3kcIblVVKHR+GXfN7r1J9AnfunwB+jrW19o1pSzpdeMgEiOK7KZCQw9wLxeicYYAgg+GZU+HMVMlVbvaTvtk24lqgXlES6No7tpUlNXn3dNZzvXycrdn33SxyegqG5GlrCXmwQH+yYbK3RfNQGwQHj5XWtTbOyhnpSFmB8haFLeQpmMus/8nRraM3orRPGQdPI/1/kG9k5DlUQ/boWXU519wZHUHb4YnZXI0qfxD4RIhAzI8HuB7nqcdJ+/38NTJtzCdIpgYtfCrInqdKaIklxcJohbe4erML5G6hGGrXkFjNWjz1dk1M2q0TK1FGXeS54juY45eFatmRfJfmc7lQBZLnVsZraruw70+3AH9j1or5xddhwK1dPrQoz7dMlzBNf1l2sdkdYOSxFCxP93lGd/ec648tzFtxxPYMzT9a78JMscSzytZk6HUZA6BxqIAkxhBvU5dl0cSM6kFEA5GOWSelUM5USSK5sVGtiVe3/GPBje7C0YP1q0lueL6xpKBb1taBxl/PG3hDJQ4dj6xLmpGIqjHwMe1EBUgi45TMGpd5dIPB8TgTQad3S96Rv9q3/kqjcwwbOZb0TxTWNn8Qjv1QlCFFCPiPYcov+n+RBHrgbU7McRu+P7SBw49r0qiBCZxyfz8U4o=
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