StltpkuY/ntvYwUg1uMrq3myLc4m8+jMO+MtFzgdPhFciQsoqVsa6awgZVltRVla15PS/hXPGCtFpRckU+vaADtj7CeCNmwmQhrsZ7m2OVs2yAkAWIwxVxM55KrVFe1W3p4rikyrLeNOb1y2u55fB0pq+Qs89Js5cgrMSTALkyAaAtjLok3fOa1Kqp+OPy6VofGSs/OP3gY8TZI9/hPVPKTXEtQHgXl4LVw44g5VRyQr92pXZ6f+qsbiHjK90hycZp5ik6aUw4AJoVCrwm5+35Ehmz/feSFKFJ35VRZoJRwrzBYuN+dB09CEkLvzK3D9YnsmRx9TNp4ErQ75H5T7XvIHe8FXWCKZaoL4+OwOShMgkycz7VYpPEZHi7Ux1dZnQM8Zu3NdIoj66L0rG5O6+4nsZmmqtZHX+AEfowZFVUUOZGNiz639YcrNOg8AAyuwt9X3Pp6LmQ0NUUrUvgRxYy9fpo4npR7d7uaPXKNiUli7wAxY5XUnTji79uS1ihb9CyTz/UaIgGK+dBkz8OC0/pX+scVmlp2dZ+Qe6Rl5Y78OMQiPnOfUrM8jRvkxhmyYxlPl58Cs/pHnzJKy8XjSlu3etC0+l/MJ43NP7KGdObUyR9ts1t9ZE071iUBjwec1W2wndYlBy6RvLkr75QNszlyQDlKQ5VXavMUDarF0lirNoa8wbXTF18fUcjsjkFjL86XAm1FzLfVH5QLhw32nvO3PIyGSwus7Sw1LxrNkk/EXdJDVnDD9iFmPsBWk0IOzG9sPHKtPw0J+WgDDiWZKVEBBFDfDYrEkIOqGncOU+jVh9N2z5paloEEdme3FZ0JxF8ZOO8HjOFb7yEmd81MZ93N8p7wSMsz03BakM5wYYxWi9bMJQqJJHFFrNwj+2uTYHqA/3/j8ToQ2yQkHj59RzEqfb7SXXLJWSkDBOft899GbW0VWEgm9yu+zoCnjO+54MG4Qf2ax/cvkQoz1o3JfKZSvBM8TNsgmMhyvK58G3qBry7Y3YVxpISE4Ez1se7WGJCXAFSym6bKms2kBbyOCtl6vmYmzDctdrjJ2QN+MAlbOYsSYelSdqambBF5v92TvjDSRlyEgLiobE/xq1KooVFRYZ8BNzsTsNhBtbl+0V893rxTxodAsl+zdbfIv5AXxcPIJwpbAyRgocxhpGAFgcuDBmlJ7BxGGZ+vHJixCjzY0M8nr/sD1zeShcTV232b4WEBdWPa7JQzZNx59HhqfKmPMTGWMnAocZPRWn4l99lajB9/+nPSvpPQlB8VMIM9ecVJ9bxtlENVqabiGWEhFHT2YuH2+J01YhQEu8ahUD/sjQqhDSACEJdwQ9qDHli6au4t6nZDmMKPjZdgYg3M1n6ztPThg6qEKXaOuWHE=
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