VacCQLf20EzZiW8NEawyxa5ZSQH2cKauxkd9gk6t9WvJzuRhFgqBFLN+YpZCkwd1InjFUUcHz3YU5n+VW6jgWLJxzmctfjgUaIKHfDW0FAT8/BYXDa9yB0T2r4wTkc1Dm8/YrrAnmmuZiAvlvZSWkumCLCrBSQIHag96B0aGNR3vSKDpSi8qD6tF8aS6FU5vk9wNTUNbidLn1LiK2Juf44NvI8u3Q39yTyvPUYMPF6xin0opaXaP2OT8KY53cZicLE6/M9hBxpRoO/W448PrQNjG1SDvO9wTqiL5uSnjNsysUOwOB0fquzOkMhjeOWOZ2ak3AjXSWMXLoVoiKOaUBTuJ+3HOgwBjVnh/ZhC2oR5Y3OCnQgQInlWSf0vSS3972hkP0t/BBO+ObyqhMzPU7d14tb2/SZTzSo/Komz7393GL+vP3nfyC+KgnfsuWVYjbQeG09B+z/3zZMjaS610iArtvBhiTSrMLiKpByohXksNTedut4zcT9YvzWSc9PB3O1Wrkk1YYIhf5PreyEiLTPmxjo0SuCd509jgeoAp1AHjDJtqZBM1FvtqpPKNHWe4m62LV1oEocfAOUomCI3rKof0HLAKdZjcoH7CItkob+1hReDQm3+uvpwypTzRbs0xMZfDIYMG8zRkcGN78zspcKdFQe0rIHzTvZrs6kX7dfDtv7CpVmCpyjJDHdvj+fjzp8Z6Z6Jt4Df2lvY0lZBZOmki/COkvSL7MGmGCC+W0qEUUkHQzslxUcBtxzCOVv589xTTShRO1sssX1MxmwqFvzSeYzpY8tNkoTXiD0HWwgd9oqJSf1AyLSN2TwI48M+ix3QFA+djl42KQ8DodL44Xk3V5QHK8qgiY5h9tYG1sLQTdR8mjokM/ZmFEXgQG/4oqbqFFGVgtBRkSi16usUZze7h/VWIC8Occ7uGVawt4SOaIvOMBsZ7y8gRzt51AZQU9ooWRH4+8YFdzv1H6Y1K8WDmhr58ws5VtzvV/9IN1cIHc9pF96i3KDpo2bybuyjdiDKf7QKTh/bNCLQroaJad7bbrRO6HoOlZPRxCsisnu6i9+xSdJmnDUtW82dq3NY4QnnYLkg7M4F6yc8LsnS0dbsQHFZimat1WyGPXOIP2zV3QKE6sQpt/FezYMf+lwP3ihgIqtZIGHclzVzvBIzNhaqNhKgfQe74oMEMo6yVNNLtEeFHSWDe2b7a1+MXSDE5mtHrauxeJyEbSxAznbERHCQITS17LeQNodP+sHadlOMKioyoNWhoeM/bZErMtfPevmYYmX349ElAZSNOB59GhXAylQMbRsGKpG9rLl/VPHKhu+aXlCnY+7Amg1VSJL/d5894bleizGKayZcPdxCAXW5daEOOsdzKJyF3mi0=
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