hQNaki3LHNLwvobOwCT+KLACJ/EyyAIFQ9SeLJsMiPGD+GutMYIB+QLjb+zZrVfcZ9Oq9+6TWeUu8F5Luo62IZF7KNC5OZa+7/3GtHoirFIlC+cQCR0hkzRyFkQRGUU7VAL5WweJLrPEIUPsvn5fsvOWRSkZ10t9c33veq2pnPn4p9ylcwE8LpsTpZwF3IygtU1tEEf9UdKUDPsIeZHm+8KVCSvpJTqqIHZfkzycSd/Yn7d7aCSMIaCBDAcrj9gUjLP8vQFx5CYyTwITcbkkkf+KjoCPEpoACLNQlCUsSoO98MuQF1uGFFgIxpJZlyKO9IKoOQ73UlXaytViRKMh/NYmFEsgHvl73egXKWOCAVo9v4ProUDJAosJIb3c+KXNZEPMEkDBIibQ6mcuZVIgeGWphWbR4kMJADyQJvTqFvVC9iIvw5XzC0NtU5TK8JrTXPHRq7d7EmfHse/0oIp1omT0BoxI8MfUqsCqbY6jtjv6eeZH2l6i8fX3gF95mb8eDQwwD2r23ycMXOp4MVhzQ1rIocGp4loF04ifiEJC3zMCp/MdGa2tjK+d0ajXS9GPEqkglTXM9Z5rVRDLCxHCscQqlqE8LSApvxrPsSccxnDXEtHgA6CQBknmMQDAKmWqYMQ2gUPNsuk+HOpFK6UBZZok7xtZtmjsh1SNvo+76hY/4axfkoO2Xz9Tw3q3mc7W41ljw45JodQ/oiN01ZaPDOcMkku3aCp75ZW6lGRxZ9Gg3cAHXOcUR28AmmNXYlgt2wJ4ckDFkVJ7YsEJkMmuy7StQmFyOehWgHc2C1gZFbJBQA1NySB3Ta+5g1lukomgvIGef9KHV4ChtUHAgorqXcYmdtawo3tfholXCyIwmJiFNzDbPeLgxbc8p9bUyVsPpuMT7KfElK+rseVd99RGG4zje8+Ulja2SqjPAXy9//qcw3AKaH22nZLM3FZBT3yWkz7+PFtHImsaT2nSLK9+qDCH2ofQY9xPwI9m5vGm7BaA0O/Hdea6x4kKV53ZphK9k2YdjYqViMwVkJxgTkSbDkmXTVtKdi/H2051YQQdEi4jiHgKgjt8CJRbPr5Mx0DAHVyumtYPOO2WokQeY474o7uUftFAST6DxjoHd9WebnzptxcijWKnSjePIGWS2dYHXJohKXegiv50wZo/lmB1K2/mRkIxU2SmNAKKMOtl6bk6Umi4f4Sv5Z/z57F47WGbmco/dfYfhZiujUpqKICZeNHXivEvZnN8ZF1QB0ngmQk2xQzRnPrMCXkYP54Tar1gfxfd6nrdbFqQ9ljuYRSZZ6PNWFZ3+PAV5ZlwZf/16+Rzf1aczWRrEts4YtRhibeaTUT5nEJAdeFzkwyub0PfR57LdGDuxvLCHg+UqR4=
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