GUJNOgBJih7mM+ayMlyK7kcQCbGl8k2APbdig0jTLpMQFKZE71OR/vvaVTfW5CajPhsOYK2w9x6O8M48H+H8EaOGruxgn+Lm0YcOEELqkyeaNDbRjrWTN3kIJm8oWPQXKbxdViIQPiOJW6jpA6/IwQkCDTS3cmzQ1Un048zM4NqqW5X9W8r02Z40lB4BEoSPH8Sv7SMGHSSLsU3V9pb/lgqQ4mm/1dvv8FJ5rW97WI/a2ZK2akfjqvBw5gW8fU3AlEY6jNtkFmXCQdcx+Bd/YcMTkS5cTYYzG4k+poA24vd3Kfsj9wqCZt++TmldB9cokqTk1Yof33zSLDFGTmooDCglGJG0SDTdeJra8ZCWsqb9E/Q9CzcBF1MPUOpcFOWlbAwSz0+weOM+n+phzzH+d/5fnjKZrCAnCYs+e2t4tIK4vL8uF/hHJgi3h+ILV7Boy5AFLQd9/igrmGYteB82gzjNBdZEwE1fa86k4tCPQGPCGfgo2Hp0kuioFWS7FDKF/nuP8HDyWrxA1gFS7hxXV1Q7PUbpoHW2Q43f9IXu5Uq6jAXV4sfKHDKglJH/FoZYtQLepgStQmYRwoLAGQK570ImSUXhFciorhiUdhsvxysupKgoq5gTJIIP7eZVulur9uoJ4nSgCGK6dYulRdenFFs+XxBLenEi8wav1aOVUlXqZQJFGq9wNDJ99+Cm++a5K1+HM0FFu28cBdE5jPi/mEC0F9oz2QpKlcthfdCc4SAd6a88/DbIgvo4tauwsp3tEz/fbU5ub2PVuBmblSYmiq7IdI0vyxC6Xq8tdr4SoiSOzrwpNZnJGEsQd4yiRAsNSa4ldHqbRMcrffQGcoREY6LnqotsuBuc0H3Pn/ZzYj8HBLflFvgceCMFDx7D6YGQwaZrnCfHmnWbGBUomsKSsieARcd8KOf/cElApIrroOrSthzEaRKzJSlTNSSk6VcNKzkcZFJ4tM0oAsz0IxShOWmN7a5YydzGv6TB0Tw1W6x2gnYXPF+0OFU8M0hurnl9Ou2KTcEqeDXYd7dElEG4M7q30sZVxlUQ93Yv1IKpREY7PxMFX3G8AwAKjXpjVqnVn8FNIM75E2YxDz322zNQJI4y5rGkQpM2Ta0FoUtXBU+O5CST5y/bzlkp6P9MOxJxcJWc1cObDYOeZNex5tj807AP/PonRrAITOagspK5RU45ZO9Q5abM9l9jcXv6vi1kZtlvpIKp08iVGbWEUdNNwv+dLR67+Bp/lmuMklY0kIGQgkV3l7KdxNGgevNmzQsUvL1Fm6w9+3kvzu01uWuid79zej0Fh40h0wSP+tCyAxTlZ4zolJTteivrNNzUQG8rcyRBoJF0z5ef/JWHOJzOaJ+ozeh0ZsOfAQW1pTE=
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