yuRf4nx8pe8/ZQMKzAR4sZ2HKVsuUKVj/d3LF/pkhKomzDoIaEs5pcWrLN16N516Q21U4tbWe6FElzFYdjPx4AdTLZoeRtE7R6Klvo4hnnG2Bf5umbLQAliUu+pOWbv/JtDKK9vmkJx750LRljNbY8nzEGxo3wAxsecsKimZ6aOxMr7PZ+30Q2XAdMslblmqRsGMbr4ig+TgRmGajwUH9leDvVF521ELnRK75eW/JknGZD+F3F+nirZHsxnRUHQ/11zcr5UYGPZldwb0KRYzvc8S0PMukEEhaZ2PfCpAQbGzv+hffc58xjqewOdprwHMmq2dB9ZW6DeuBsGLLVAGxRdhhO3KW3lFw0cz3J7VLY/ro7MhM9hYSsv7PJGZPm3HXTPfvKZPXvJqikLkV3UBBkUjuha+1Xe9BKkBn5VtzsNMvYZrIJxmUoKd0kyEOzyWFnBbuM3Zi7hu61GnImLvjbainYbg+Pa1u+XpDVBztGxEcwYJ2mODgESMUXXYP+z1a/l+YZMPlET+n0PSu8MeoUBz+O2ehbxSJ9aQfKFaliILBi+zr6M5+IYTFSuAizW1kfcmd8OqhUciRJt8wH284jGbYYiQ0Fe7/KzdPVKSN37tP+kDx+wE7Q+JMxJIdAF9CMWDtwZMtFeXeP8PPOoqN2fAA4Cwh0o/eeF0gLao6vgcbDga/IqJa95HlS3HU4gCrAslMVVrg5ma0UdWCvt5DtZrJNj8jMQuGNqzfqExbi2ND0EGK1UYxnbp/ajH467ljgZuI1/srBjd4iNzPETWLtfR33Gj9i6IjqwdOXp5dAGcjXpXyg0l/rGKIxVxyWvhXaCj1wXmKHG0yuHA6gV1kQxgWD8f2/RchtnWf4fr5r2GY9pvMyUCGXp/xJSlC1DdKvcuW3DCdtF1GSC8F1d9BLc4cYN4kl4MLjuublPvzKUt5PjqFm431tWTIV0EuVIlPxbrDBo5ZeF+s2zpHGlmHNaBNn+hfdSdDZcbqs0IaPPoSvHkgY/iECJ1bOr9mL0q6cy7VG/F9Lh+1xDVboTHfJDt4KmOprOOzY1eKLy0AX0vwlqDFpk47zxFmaqzaLWR3g5rQLTfah26ncMl2nS+CGwRu5YjJd7As6hNrIPWX5ViuYA8gROr7LbM0O3gkL++kt3Ah9iILeWCY5w+IBBe66RAxWkbLpu5PBmym/Cm0sgYmdLMM8gSz6pe10PJgmZRpmbhKwrQjfFE0iRG8Nk1H5kk2iUvkv6WkitC6bdugNAZKWeoh8r5r9rl0ylM2OgLBp+e60gIr9NKN1fwKwZd9y8sgIzlzVge+n/18oVnIwo9wRr/y5ivaMBZPIW6ZGzjxtSfq51FP+z0xZp6udgDC2vdUwohAipJRoMe/BI=
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