RwFeW0LSRQ3GZIZJ0Agf6CzNmDp27y1ndF9jQQRfhUCEZ6XGOqKYxVDhCR1oaNNWn2mZKb4KPoMRYUMgjyQsVKrok0ordamKlp/U3Hz+c/H3jlUbFIT2XMk9byFajYnJi7NzBcpEUBQ8YXXc7bINnbVXHukKvITHAkWDhQBQiP1XbJscaPGXVn9wqkoJaRVncz3HAohYENJq1L5ixFfe67KQ5W9lg/OJ44ncvUUgsbqLKRwf1+ie7KrPLVC9l/E6VLuDK9elayJZoCph3ccOQShzP6TQT9BGYwW7Ek0hGPdNIx9KLy+uT9iZYzJIJP/FPEjdodW1UZCDCeXVu8ekHfkQg7WVxgCJYMbyC6vlxm7qrIT9fqwGuSs7MZpeaJRAOrCWzfCAqdiWOMeMCgQiqkzQXinh2akheJyIy2e7S93agxT2FQU4nhHoZDcw5TKW+oQ15uZXwhhuww2nxbk3A9LWPr+KYq3UDnrkicEK6K8jPfTd7Bxm3GpsA4Q7qjemFLcQRwgfutb16xUxMjSN7ssxeFII/l3lawheGAtNu3+7y+Jx8IVkMfRZ8LoMypr6WkaheyUim5PfkYN8DajWaDy3fwowxojakTZsfelWQpFQ+wGV1bcCGj5L9aTw51uMRRyLoXXavcicAxJqn0eaplus4GQKWCTwuAStGrX7joWM/9uFAxwFIDMe4EXpTdJfOq6BM1pEskFAcSxDGLOKFQDTM8a5gHuNkzZcQcqgWbgASIqBs162v5XbZqli4LEGzd0Ohrdc7tp6iV00hC+eos6WfjCN+A7ykvfCQvww9VnUQ/brzcdevQfMH4LKXebMWRNh0fUhL8KQ9DUHu1InCMmcWUHR8yfAXxxsTSFF7QGDcx5C+FrD2qZyYkmlK3LjmbkZdOwZlJIpCdtyoUqrz2TRBdC1wFrcKk71TKqaMQ3hMNh10HYtQR0LZtmxwWTMOmyMKsyulmF9JUQiTGO5T2xohX71ThkkduGSgQ6vnc5naHMQ59cGt+LkG3vg+AMgxHCIBaJWEEyyFXBnw5Oufj2NkC2WgUQJr6N4N2U+50bVsZIMGEx8DZ4yMMJTjqZJ9PDSJ6/+DAeb0tuInClSpjOaAARPmSIC9AZk2FHVFmCnMD3NGibKJwcXT/P2NjpWh0cku0Dekr5qp+aoyN5ZvTZ9pJBXN9dTexL4tbPDs6nId+HEwejQENdNI9uZaPPwQYccZ0bufWxDrtqAgjcUPZyE8y0vwPPFtZkvOYW8cPurphfTvITvbYP/jhR7xLEDig4QBs9/G7gz9UBX0//GV1hYa9bEiuiukOiC3y71fVGICJMJB1owrOpLbpi04WOYTrW/eV9BhFqwnnX+nJsTPnGVvEdpmY7CynoUffM=
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