3UM3IHf7999PwmVzYjsC9+VAzGpiAz8ZiznkMMV1QICDyV5CVn6rWR+ZOLwAEMJRCK7wl6j5+KWAoa34MzoMvJyo31ELgwoZJJ086cyI4QhEqEw1SbqSlDERyG6+4f2uOvuTYNv07652tAAF0scBXWRitfDLOFotYbAGbNubf6OFLL1CUOJIVC1x8PMLhXt9K5piL3mTMWy8FDh0y9edbbgF7lgyIjpkhqeDgGeN1HBFZuFDIGcE5l1T70UXj/KRMWS134U8Nzm7hjEjNF7KImFDIsuMVrvu/iq/+b+UgUllwQtR0X5GmLMliuAuHYy6Z7a2cphV4WHg6abQl4+OEN8LphxEBdPbgNzrVJUV38bvxIdnd5IeMifgfFxx71L7qXIqgJC58Bor1oZ2usReBQB1NjQOlQH9S5RI5G90ob909YW0itQ/DzQaYdKzlrI+uSjkSJxDGF0CuCYEHpj/M40olfNh8o3IdI8WHr/NLsyk2Rz0eqMQub3oPJH8sGNSmp9oCWqlaEbfwug+fDKmhJYf9xDehAai0Ji/EXunR+EEkcvXxFfqUzqG73+VPXnjiV/QEryYK/DpJQvcoEALqfABCHYMh3mkgETjlfSHSvwUbn5xYkPyum0lMoZZ5Cussy1QlMW/uM7ZztuLha/ZbXPO30M1yUZeCwQ/I9vPT11dYpPScvUz+bOdjRYifrYT3ht91TTt6Ib6/IQXgfCSozkEvkJwF7SmbwipqYO/A8a0wEi0jBAW5+7zYVxOT6PU7nUp/uzCtWc/duan28Agf8l4D8bxlpTHGpWMj9MJ1ytLyuHzvxuUgO14ASiPKr52MIMJ7ZiQHVW7QM6U4aQk08DAHv17kEzKnaJAuLRedRjpDdkLkCCW50+lNkpXlhfpps92rZ0hZMqhPWgkS1YYPzZtCMboX3a505WaTs4ODg83dotAUWxWKIr5lCchxsuLReUxr5bXY9kDxNG3IftABAyyTT9DyyqSRMLwz2SK1TaK09AMUGrS3R/q7/ziNMlpuOozc5j8LvZ5ZhGjqWwp3IRwo7cPeDa8oOxKDoNnl6Tr0w3R9CSOALhGiTFBBgbNSFLeOHi3f6+DZUcg/VtaJ0m2qQe7GAKUE+ABi8izjretYPtd+u4HvF7mYvgY5OA4VUtex4CqVrBW/aMtVx1OiOE/GpAP/PiPklJrpHCloTsg5fm475Sqwige2uzFCDRT8gIWF+zsRuQgUne4GZXso/PhiKy6+b3dWF8WH4fusLcmZxQbD7AmNaQEGeS5LluILKVfhoXi3orQNGB11LFWxedhJTwwrnBTZ0iWTx6/akbWdpSsIgSpeMSf50CgRtnLOSg75Li+4Q6aSsvK6SlXbgN1c2fZ8ib7q6mC85M=
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