fcd9O1EEf/4S179+Q0+VdzAQotF0xZGzdM7/AIo52wDAiuJpz7J098anOlYrjeCwZQfNULJ/NomRlAidLCtOr1TZfq5zgydj++6/arq0UAFh+G9qPplg8wVG0R/NcvOgnFpSnBlBfPp4bXhWkY/AZ07MveX/gzwmHBUYouFK09U4vRIVx6Y9yD+co7DmXSzpqjYPQ+K1CRJS1G+qcV2OKaIQ8T1AMoUlsgPsSGI2rfskNN9rQ3cTyGDAX8pWMaLmr3tN7r0ZFrlHmkhk7idIwOIFCVmBE3UNrrCXD04QcfQ4F00aWFO5yT07aZiCO/+ZW11MK2TEOwvOqez0haXunef+REjCUDIHoP15mfmo6YQjDuzP4WewQY6TiSe3PXmroAvBRP7+N0/Qrs+43djAHYq0i2E9jAv3UQ1KlUI7jS9Ml5KSKCiNgFwODLJtIpodUO0qGhbSQyqD5bVSNdCklhMJh5nfPThHk5u3yG1RCAoIsQQM4RXe0YUbxAvquynaTkLjQvrBzXoVPxVJqwFyjruA4lLRJTaxxBvxkWoDnKpDqjMdWLcZbTBlFemNKTKr3EdXmyyGgZwksxVexkR6jx5ueOTszyag41JqE98H4guQb5+7fBiVXhVxBFvWYncUqeiki5Ovg6GV761LoZg4sn4PDTzsnf/MeXaL8IG9724fowNBW2g+FdG5/aB0jcKiCXjK66JVYqBzcI5Vh/iAXTIHb7Sdnr029IjbT1Y+trH4XauQhky6uSfN4ebxEveaIeSRmJ1MqMdmck4qs7CKJB52/6Cdhc+bqCy9DCnEwm0iGNNauhtfiPnZVKwupMwF+5aFAwiatQ2iGZi7WK6OLuk7K+NpvUx5cGIi2cUMzD0aUmK2JQl+0K/FSCys7JpSh2v4N6WzYuqSeigoiXJWzugrhIyZm9Ymd9VKyBnBg46wApu40y9N0O4prAKvaUFqUazTT2+Y/WaiKbAWJSxWXF+IsU+OyllVH67zOBpF0ml+//bd8jZAB+zGLaLQA15PbjFcBzQViZpt4eU/l5tbShYWTXfF2eQslYrE+p+QQcC9Jr4rAHy2PZoJh++EuCSXZ2/DvMxskWQckD8yDQtEiF4NjGOtL7D4sKZveQvd92ZXqmfK8EZobrvm3q44SPLWDua+1vU9MHr4QQdO1JWkbwmPzS/VOAedBeKjEGKs8m+dt+Yz1vOmhS1+BPF9eAevGHroVU6gTtd2UC2/lktMLAO5csOp9JXD/c0pztYB0fONjL+oArnAUZpkXjvo0yE7X8TFtoA73iIE9vIrwEFv0T1kCenEhIwpmjeUa+ghtOcHRraXtnIGk2AKXGRPgLFYeqCiEYdldgCVNQpQjByhP1tebH1DbeybcIhlPe8=
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