vSFKt9d85AmsrCAUCWnTdrxd92XfkkgFu+UoWXyZuOnL7O9ypI0y285NuMJ7GcU6Er3aW8rvG79a7W229fyufnvVTTemuKMKzVHBa50ll6weXmMusHoF7WzL+FTiBC4hYlnD7Hp7uFprSTr8jAFxCJOD3+WbobuUMHK+DHF2TqET0GLXKoKgkhGC/XFSIIjube+W6pZEuzopeL5bYgnSh9aHYTxeyjPoh3Gi/6SGFBFMIR1HRb6hnqTJ+VCJgSWZ+KVSxdhEoyFkyfvDVbu4j7vkaizAqMrRNDUlEKwCJK3aQpwQxGlPQL0ozpuaJ1qYs2tu7gWTOY7BNfHFl613O9X1SI4yWpkKIpzyrir2jTHigOKtpZaqTae6LtJI5DoMwj78f0O2OGSYNKg8W2hkbLlXzXib+n0SPPiaDSjGzV1psG3XG2VGqfkrwjSNY9yHkMXutywNvJyX0nvnFJzgB737Dy1Ol1vrSNohH3f8VZ2hnNAN8KXr+KZBTwqRM/YhEwVBk9NLtALf3tqJclnB7eJTtfzdljPc5m8b56AEiBhGSOWq4rtbkUO0fIjdUqSD6offFD9x900Y92wqvExskGfcHYmJ23aSNu+UDNQ+UookeShEMAqvgYrwyTrTJFWSH9GtJFuSM2secLQicJZFVHvWaL8vf17/jYJLGrSdp7CXN+vYdmCq10OtlFo/XgnJfkBPBJdCPGlnpajz5STACMVIUlnMVDi7Gpx82IpfuWkuyjCeSL91f/rT/LqmGBJODl/xF3Z7aA8+VXGuxt6AO9D0TwEj8+RR7mXjh4XxHtxwPXEQrTwO5Nm/dzdqmck2WBkWt0dXtx1S2AWWxmHEHqNkGmlNUe4OI0s9pQ3KlpijBA9cmpx6AmUXsL4lg+SDeuHhmbyb30J7gPaxMR82U/keTnDs/3OaOXT+Fqe+R5jl2/+0bQ2ALWvOdh9jEtjoP6IK4qBsZRqIKb+tY60ffoJWuz2A2oNYFQvv4PNmQW2zI7Nd4fIUbEPy/Ka2iOCXSmHsyHJlGQBaEaOJH8FY1Ffvs3wshxVzt3C6CSBQumiVWZ2PjftuhvuIqqo0N+POkl6WZDig1pqFadYAc3SOj6StfgTjN9qFLrdWhO6PPo2EvG9mrEQebi5S5xBsjFz7VMhNOnnQRcrjJGO1gwnOB5lNjTIPnJd0FpfO8sF3Wv8V5GBKeauXAaKzFxUPzkZhLht/2nTuYDg7OUh617GkR3Re6l/C8lJfsF7V3mraZodzaf3Qrf9ghQm+J0361lMpOBmGxIYnjnWj9h8JEKR43MU088SXFYw96MfjrvTan6rqT7A12ZME2pIXTKG9K8ZFVClEsML9Vmo9k6F4+SwPg6dBbbV/3ZmrR9y5gjU=
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