3FbgUkc+WHUFDIOT7BPGvxCA46BthGS83zDAlStmcvUhHeRyioe6uGDXRrJxMXGT6NsSbPZhXIrqLt+dqR+iRNw1YGdosf0aKdWgmh+RNJQzdYLrUsqPRrZtBEZo3bWlq1uswiEON4/cgTxz7vP5SjF4e9YFjFcSZ6kheD9rX5kTliPs/dQX7iKDCTwHZS4/gVhDyxhLcQHY+cOONv/wJbnzdwtWXiG38TiHxTtNC99cfYjwbPtqlgUVsOTk0zPKLVtGt4DrK9K9aSw9H2/3wYjdJqHAw0HGD8zGRDrtLgCyBVWR+1jSaF5vYEdry+2rQCYp5uGUBqJn+zRVwJkjjJEtfTpgdeAVRHKBQjE5METthF79r95JixVEXWVWaQM+X7A33SQNetOt+mD7hE6rcu7q3PM3TcrQrcBYV79A/Z37PLg4+IY4IcYqIRzdOupJ4+b1RCs8yOoSk7PIXWLG8ynITUkKs3MaiB3E/ve+1rL/3MVyD0YxZqFRd/3M8ULyPismWqHlT32lJrep7KVGrQ3saKqUxM7YBjCi6uqgzEq2nVzhtGHp+J+bdGxzc7V3lyj6x09RGjcu/CbKyWbmXIqE8xcsE1kGDxh2Aa/dgs/l5wruDfdtGcKFjMNIE6HqsqkMgK3EaEZfuotrYOzpzUVyxXqlsLGPrl+EbKVbDhm3KfJYY4j5ZOf6E5r4y0CZygHwz2smDwgry4F0QOhoDT/zJ+le1OiqjoEREmte9c+HTD9Pf1nx+kyMJ2ELtvbQgIUzCImj5hwT3OXlcCGSaUHse3j2L9CG9OiHYSiy8caviosMhQr06RhV1aUKy2V2N0BIwdoV4SyPfOFqodJUCF3p5gq8JYsZc0B+JNrTOFUMsakUPbSzN4fR6nizNHli6ZAk8z4AkRi2RrdDDJKhX+8f+fUOhPNlS97qSoHqWQMqyMuqtMWUhDbjRGjMerhOsK2YMy+sXFkQZ/FCUVy3xfdVYSLlvjU6GBd+kNvogEo2mrRgGqJI7t7VMagQoyTfW/qBWEUdhuIVU9mkYp+mKDdIarXojERJFtn4LmUXOMEPpcl6cVjZuMEsZn2OBALrWFOwvcRxJcqMsI8OueX8tHPi+T6MNggI6vx1dyQiWWGNkfoqbjBxYS5zMT4QivzEv/imfyynspkin3AwVrD6VXtxum1VZqJ4nLrUYig4pZ3Cgo2jrxVhEXTapw5TmVTU8KOo+t+H7j9mrEjV2dpkZiDRfnFjHS9giwYcYNJ/rD2K6RJ7nK7cfLc8kCT30IcLU5s7RqrXLUrO4MJCBIHXLGQKjmz8XW4+ggYC1bpwTweJ3xLKNNUqGA0KjLDAXwd3Ms0nnudmE79Xjhmon/iBIC9WhI5W6q71KnVD/78=
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