VSCVrx1Phjng+gBcbgGcJv3LtaQvqt53UcbLpplChSkhQMsJwjiA4izN0XN2nKZ/FoE7kh/T+c1hEFhAvfSTDuxl9pot1vfPvDH08+0KXKuGO9t6YKjtQVm722yLZRXXt68oHRnzqw19sgATk1VA4FavsvA0iRH3fUs4NT4zLQ/c9CkWytyNl9RQRZXTiVkJGRQNHi9T/87EfmWgZV8yyIEH0PgXLQIFy9lp4Tnq4A4IJdLUicexLinDBX+F1k4sYHgHTbOvc+0p+cfJwX2ktpdSPWJVjwrxeUCjT0xVXT3hrh1/JXPkQIN1de7dIH1/WK6qxaEl3qoeM6+nJknZ5MqVKhtC5odA7Kb0Vh3Nc6DnL/erY40qzjmOtt9jUwM58vb5w8YCDIWZmrd3rmz+GpbeUUMzuxyGQuYw3/2lQc6ijNR+LEo/iWYu5LtldVp6/uuA5VR2xq6aP6KCoXZUbLUQfBGqGimeaYDY83ny4sv03bzIZ7XoP7tiQEdFzqHBivZFEKvS4hurd7wadYsneV6lWKPlb4lVHhLjA2NRHO9/2dtuczD0H2tv0RUYAgojASQf591VHguTNhk0rUWyro/nCcp4ieIzvAh04DhFQvoUzYOiJv0OiJnHVRAZdrXUG+Glx3I/UTcQeE5vDiByFSm3nkVcBEgQWhiT5ugXeqYe9TI6SViqUOaS1YEf5muAp+ovRgPMl7sZMUA9fxs6n1GCHrBVAUALgaQzYYXjm6kjEUOCC8MrdPJNxuuWRnCp4fYF9bCA3mPnFiy2CprZtI7RX1kzhHqNQ27J4H/PLSKdgwHukl58qkKgzg9S+F63RWGuU9mcMCWKsR9YbLlSZTMxgsT9Ltm2gCdantz/Zhsvw+/jPJ9tRm4cCYW5YvVr4zSc4wFFw2NLwkYZm8m7qZCJ1wiPo3g1hl/GhKimKkpwJLDiZ7od4Ay0qirJWXNIhRqF7M59mRASRPGmqJ1UqKZiJ9zZ+vb5qYNqvpFVajBcY/xVuTGGNe56EPuYxs3Wr+57fNapDZXETZPgR7Rk0nzSen4W3P2MkQYcV/tQfB6fNPE2Z++qj87Abj+ZsrLi/I63NoAijdJZARCPQiLGk7jEtnDFfRb4FrW1+embw7G7zlTMPPgX4MPecgw5YFEjhtXFqLUnZlbB2lJppFm2P22MFKH1NBcwhrS6zr7TyqOtUM1kF0qQd2/jg1iIx9Yn4ezef4lKXMuPrh7/xUXrIIKfDwkTioyde1mA6XAjS0yZFTY6IKkRUpXYiXpeb1N7ntIOiJWHbl1qQEMnq6XV878brUJ1mcXwCwy1yikPE004BBNWP+Zt0WxZ76uv/bLH3B6GZOUx1fCUA1PKsubKNLQEtkwmcFIAnhkx9BM=
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