tvew0BxB3dJO5pqCrFUSUWU+Ojvim7KI7ptr+9NQFVEA+vgMJWGoN40Vr7ZYGoTw8GYWzKyr5qVlriIWAikFxOdNCVZGhqhpYtcJR5koqQqo0dL4EqzQRYEzevkXgIpzdBQJ2aVPLJuKCn9Ub2G/fyGVHa/w9ByObUtutFSfLgzWCA+1qWqBxsa6OkasXXhenJShAM0WHG7XVH4J18VWyoFr/gRZya0rqMMb/ja2L+Ldh3eeN1TC+Enn+XhlhcIDlQ5c1oaqA/K+U2T9rkI4mrTiRNFIrjYAwg/eMSqCakmYHSHT6JkOZCGQDfq5pAY/FNw+NBqsMIrxia5fF/gpMHqnl1gassGIJBCIVir0mlYtr+PmNkBumgt+njnleTN3Yh1AGlQvQ0nM7cL8WDdZdK8Rj9P2ON9BdHdMUuycicW9ju8JcD1k7SpNQbzsHMxCjgzjPiWoJFYWk5/aOP2mHHXrtshgeS5rEyGR0kg6K+M4qTrcOs+cPDbaxBSgakGx7M1UfYdVH9eV/zBJZ+qocO2fqly76KQdWq0iF8b0MCjrPyriaC5tLCS8dKRpQf84n9V50O2XhhcmBGGfm2RuFeRPRGxgYic8PVmPZg7bA7l7vWX6PT9+s82UJ62891SwGRrRY+TqYuXtJAvzMEDTrTDdtL4f6dS9YzbaRs3Hxlhy+R79O6zkxfNNzBRoKegw9pbc/LXcvzvQcvPtoF8cCP0k5VHPtJzNorj+9CYqCTid6fQiN1y9CCLrs2kZv/3GlRPIxZ6hWcLsj8PiXloqrGQkJXNZwuP+StrgQmUzm+3tObZ0xiiN849CNh10AjnVk00cpZdcQsXIZmfdGHgmkQzCjovTfnfpZRRAQz/2k19QreUf6GPf5LRODBWWxF5zszdOONagtsYgcoHXByV2xVZjaeqem4uOEyV3u5kIPITToc/K33y/yphzTgxsg/FI2Ruwim7gJNDD1Pqvrwhi7xUgTpBKOwuwRN9nsNJKTkOogDEs8A/Yf9LVN/AOZdpljjEnzJS2bCXKF6ZD6CkdGWc1Iaod4k5BdX5NeuLmuyHjVskYjOYrkoqnQJRuyRaGPYTvq5wObyq2vHYOGY9lCwo31ae6SlDEzfTYvlGhTreWD+Rhpy5HDKJnIrylmMXeaOygFuvnrYln3fCR8LIQfo9wgIpODyyduXZQ8o61b3drVasfcAyOtNT+obcPD9ylVI9r0WTlIIr+Pfb7pid9s1ukkwXVxtNrKbagaPVxY+Kn45J+FjILEuMz2oVuQH1P+r1Hw/W4uPQNt8g80WliiotsP6VUT5PeniOj6js/8P/16bGRlAvfflkD8iNjlwr0Y5nNJtplZwKnExq0aey+8N6T3IAVzxiJCvgfSqs=
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