mU2ROS05CqcLm8T7HlWArnRDt5b75Zr+6sq/rz3WNbBii2mAzRen9eOEZP7GJUCzmB7ErE59/gmTm/L5ReqQDCykQOODAotauIPtwhPIlpjtOEIZI5ZU3ClOfKKf66TVx2ujCQL5O9uD7Gf5vYr4bZB6VULf/Te93naQbfNXVt8M5XGNtcJBC4q2KmqJyHzpViEySS8OV5WZXgPR4J1Rx65OFbMIoiDh+Ycm71uuiBHkwBnJStz5SmbvEfau49fM0QFsiEXNx2ZOzImvA9i/LCqANBSB7bamzpF3oScbJA38qeZy/73RA/tOay7NxCuhgzmld8qMhXMO3Drbz9Hn83WTnR28bg0CMeuEf1L8jvpEHstI1YY3jqE1LXKy3aXx5hNMOejXIzR8OgcgFqLtVGUTThUfsYYzzofmh/i5LEuCKpadSUYH2IZtq5xGKmfnR5KXP3XmPqT1vHN4uGmwrAjx3yviH1VYSQQ2yEiwVu9KazwteoGMWEQGuqTn57+DO3iFOoCXsa2dEkIhaNloTEIkmzCZy7YBwoheajdTQASqomJKz0h8GbO09fP6N9LQ1/UAOCol1z4F+/TvrxIhMDLLGEjeEo1NtggRwV2wvEtxRDHgYjZL5EToVp+GzuxP2R4wJATl4A33AaO4tdkMYIFSGoZqduqwDMbdpfXRkfVB2Qo5rNx4qg42Qabv+cZ8YokAPmeRtPALxNSD4AHUmJDquOmYyFPIHgl5RLaRJGdM8kTeBNcl01MZG0DDVRtiCHcT2fU+EQweq6XnM6In3Tg558hUCdFPiEWP3Pel7N/czdXLHtr/zicfxtC+MjJLUSGuaj5+Wx13UONhO28k32D8JFktg7TZOUeUUpBQU20BELrwoWS+xw1oVqPfbyJCmQUrJuQIQbtEo/5teYUxQft37q7pVlqrgoprBAVCKngE9Whc1ea1lJXRJcWN2TVep+RmnlVADHNEbCiArmG9biI1fdisR756j2MsvmVTN500ukff8fzlGvdHKORtxziZyQ5+U9SwEAldS9q0HavV5NTVCne9n8Rj2OjkOlryUxvVTRJ5RKsrB2mhZvrsXNUXcYfImvLL7WTjJ6MdXlj9EDg26T8uJDne2yj0+++i93TtJj4i61HDL7wQrf5Gsl66Ye0+6H7FQrDPQOOoN2/wrgtCOzmwMqRY0JPfsj9yL9kiterAlKh0jG8w+8ArfQbamdk2kNF7BaFnyEfGX6zwlU5lC3h5L+fT5EAkeDBj5XR/vCa54qILDjujh+eDT18Gw8+9K7Y5VRKnQUqlqpra+iycYrnJaUVVNsUpydjNRO0oGSVTRtpxPOUP9NfRkkC62dKjY1FpPqjfd7IqXjveqldYqIfhNI8WxHmv8RU=
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