OuSk+1RsopPjNZ2/WIDOGJI036/0sNAKK7B6641uPK9g++shlBRAlzLhtpRbPOGGb/IRLZXHB37XQZK8Hn5pJmRL6RyOPgl7nNE0N0kmloULX19/RvmRgGcYWOo4FWZCZwQbJjGhqzT04zBFeaALWguIeU7D4ZBSJcAB7iZ+Abg9V8b1J/bYUB7Gb2IpDbFybpS/zRwE+6ACX74JAN3JWZR6ZESzB4uYfwA9pqVseNmrJxxfjoleQmcl2rjwYC7EIS9IeYfYGbbZGArjvmYf4hbQ23fkS23hPvPmS6HS9cgCvlFGYBli6aMAbZdEAHVTxOS5iaPtiV61LkHyZ+hiNIZdCXYDofv15S0UDhjkUzNZtWXRWHBBjGOhP2UWvvb66hgy8elg+S7tiKUEBSNmgqZ3ei6Cz0ofefMyry8VTZkxO/YhLO2k45BDOXB06B5DMrH4DEMVgGUpIhcImdBJkMZIWfY1yJ5d+90bBFoVjYJQIktB5AbTDv92w3K4/xOfb+6EpbpRv8A09u5Y9KJX+tb/aXEEJ3WHc9f2TiKdEYTeKntLW/jUeU/ya3BeLCnX121sLeZL5Ew6eLOFCmLb1OLOFXwubLENyC5Lv6OQu+gbLzFoEdQ4M8/TarHy5NqdzZA+RTx1/NO5m0Xzill9+xRCarZ4a6oPuhFWgNdAlPvl2iNiyt8wpguoAnLC7hB70+XJy7F1nmm74EqvXR2BOe13PpZ8uCJo54bH3CLub3ex0zS5x/pRF1/7YCCL+Hz+uWq13XMhsi0hAGelF2IqC8i1z/BuKEonLO4fJMknJc5XTVOUN4Wp6ERXA9FcaBg9eRTNrI+NuokTFHYNSNh303hZWZcYkpkvPKuy8z6JOqBITv+GjstSxYAsyFjNRHvxDwYF6ksKOviP5V4tuFFjLVmC4UExkqKkfgqIgpvgIIZFsnew71BwTpf+LdlQ2+aCjRJzIXDQ3MLx9zV4cL3rBkwwb40hDSAHa21FJkpWa+g/ZDPizHMT+/GSHKE6d1YYswyCYa1PgixTe8dvHGkzhYoQd9ESJbomhTjlNMhm/ofbKCW3iOZRUsBx6zB6b0Wx7A8AWg5ZmoL/GlT0tZcj/ujrQJ2U5qS+fIktnfPaUUU3EumTfyKedqfB5wcOJq114FZ3TbgM3U+l+CaqcSOsaBx8SXWKG3lafIUBZMIArUPsA2FQbFMlYtvw/2xr+EdPgCB5LwAL/fPeu3dxH9v0G7NvFSMdhrDGOX7AxHfkCjAoAmfVPYV29tcAOjGstIc+/hxk3RmgXFkxZN9iF5g3C2r7iGFGhjRcx+3dCtW/guSdx2hUkcvChsIa4BbK30XMkuB4+u/7dJ1QuShiBltcbnF4qeCtUMphRpXfvv0=
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