q5crhbIBzdTxvogGyGQXM4S/XFs12UOL/3WuSRkd04N4k8UEgMjTyt+4qkZ4YN4OpYm5vWy/1JzoP0qYgIEwUWz+It4Uwm1Sw59nwFZjcQ2vY+p6WGFLFjCG+182agZG9rEmXX4G7npmcAccB+ADTVj83+ZzjQwls0vy0K8f4WRlibyXL0mQtw4JS4cq7fkqOSSYb6sJuExOFWGrlXAM5IdWOpXeC2ulXGu3UiAJLDVRakwzKhj6dKwj6Ha/SP9hb8CSn/vlToG76iHNAjW62KdXuuG37UhhEgaOyGuoBreVsZKsNgBe1MoO3zRSSZ5J7CdDCbCXA4KSgbPQ6NxA5CJqU2dsCcl1PRzNLb/G0wBdfQ/aKzFd/T4gzbUto19NWZXSm8sL+XKQW/fxdMPOV2SkicSYjI5rHfNMkHa23fTPMLPMgYLI+KAJnJdzpJeYaWuUggbAQeYpy91iaos6GxrRSWT2hpoNDDRXX2l2Dx2VqyskxlmcMPwdN1TD2xYCTfISiUUEjfGctpWBqE1YH0AdnJ+KJXWglnZfW5+Qviox5cWYryf6klXd+g1xTjz0L+xx1u9VLUJ69I17t7ZpbpTDBde666kg9qRTzV/wzxazI6MXEuM5Dw0Pq6oqTmiKcA6Eh61hD/03IfjtCe9wdDLpaxKdEk2LZOJ+PvoaFzqMz79uVoyYmMdt4LHcji4dQy1BJ5vhvJivNQrGqWMQVyee7Ks8xTXtcFHSPsdsU+wZcARXxF3hvFxsQ/Z9osidzAi34I9eyz4y+5Q5LEldJcSIltFCv3XJirVGjsIu4QuMdi5IhoGHb8W7E41x8OX0uBQTlIOqWAfXmElNwn091NOkaiP5Q2X2gXyQz6wCVIaLArnRPBj2Rr3XVGXcXg6IHDPZiiN7xdFk1dTdH+zflnSBGlKoR/e36sd3v5yKw4MdCmKX5AoINFXP1IKik8+bcskKpJtPxNTPe0gShjkHuOCn6NT+7BGpXn0ykDJB52zr6S2KlgfTlOgHCSCknZpBjXzhTsvQY+PwInV8VrPvnUPGiFbFo0xWDE4qUjVoutVY6cPVJTM6G9bepxyXFws3vaW7+uj+nsQCk6XOOwHR5Azlx7klcX6KC/TfraqdzsB4YRvyDVgYEfTV3Z0zYHmyHnofkkN5dcXGwB1G9TzNidSI0Myi1Lh3NlnyRdoOWde4jHTQ4HXwS/2oKOZHkiBz6M7aXMRsnTLfoXO77/bPZSXGHzvjmIVndXEIRizL6Hqk3OK3e7XKtIDCnMQAIOPvNnCK8JrzaiQrjbyBew/HWOqZbOcMUDQLAGFPFn8mf+BLzrL2E3OcBM4U2HERmzrOFx9vONT9pSTi9NvOq+0tu4Ss9LeoVqpQcGofQd0=
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