A0IAieSajHMeWduTtRvMdGoKq1yyQEL5YwR1/72vBxRpGHQqaV9QQaRdBtpTh4zjfL9rfhbpOCV7JZ58tCQJ1O4EV6rSKyArANLp2yg9BIndWTzdFq+sGzecMhET9VTL/HxCUB9bANTUyjGTgdlmsDyqEDfspm2Ky7CUUFTVtkespOiVyCW+4ZkE7hdHkZHIt7CHQ3g6tKymqtEagYa1bCJCqY9w3MgzG5jCc+CMCIvv3BCO+jMfJVz4qcf3bm7hII1/MUstSkfukXV8u+z31cWasX9xQG1DsSASB+YgjWL8VI0M4awJybdUYdIgGhQ1KTx32irD/quw7gX45onbG+2Jwma8oL9tkQCvub7J2X3AntS3sSDzW/PraJFXTQXxkLj6QAqIhQby0jZ/HzZdIlbpCO0+aChbZZPoBKYXTncT23xeuZPXZkLNGsRBK0Hy0uHh29vaRrGC400yypQFGtQy/eWPkDESNIO6t64QbFl5xuIDgoo8smWl7nx3857XNqzGaNq3Ehzl8Kv4UKKuq67xCkJeJ9i2882dJut4UElXSCuCrXMwPkdB9Z1tCXY1try8Y/KtqT7JHlkuao/pDPW8Q15UzKOM5+sDkHhO36JCXUaOFHAxQh4nxHsrOGc+z86up4V5yLvdssIbm9p6ShMWl40fO2a4JDXGNghuHmRD98fo8Rmtd8eBDThTH2vcv062NWNRrGkmz7J+SS5WMVkCndz0GTevwYZ57gIdX1DVHZTgTjzpwZDSbmUD7497aTU4n+tpVpKt8+U+D0DZ/nSGC6CDIvp22n6+kOzcSPROK2aSaDoERP+EjzGgBCYKHbCOa3KUyhsgbF5XAWiPTLOyjIOOVcfu7WgTaZ6L7XfitjVx7kihzSfk9k4Y8ISmhBIE7C8h2RksBbdSoGEZjSvr8eyFn7FiOfQH/wpsaHK0QIkujLOMwxYwkqxzTR6X4Sz9hS9ZfrnpBpwFtcADJcL0Ouoj7X5Dh9WZSCJ4WD9nsW8jY43P6GviiUx4IxPMsJmIbxSdW01NKEbomiCHTUiU3Vle4lrfGP7HnZ2AEl9ivc149EgmJi60LN1xmUkDNKGpomYTAQohHT5W1lB6XDDYtMBVI96qkJLl711kP8Rl0GIV2xaA7/nPEED0JSqaT10bfLG9G6axX9gwrflqIrc7WpgDRij8LiovAEbDZ5c/iVfTP5Ad0hIo/DMmV2InboxtpFNWiqkyoB2e+q/35NKwFsFWGSlwVJFlbYJ8Z584hNoYQFD7HxlDGcbUdSUpsfAOOuxTYpI6FqqIgmATL3t5SKS8ps96NKqu4wJuLHFcld62mTgymc0aWctKnijNPDQq5KjmDnn1daED9QymnYlFSYjLRJiDoTRXMfg=
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