6Y0FK84DCDdG6WQzYweY985Q1jjHq1/wTM9vorG4fzhK2ItZZIXIZOhv1p8Gt4sFT3FePpOLqWTHP0b0mTqxh13E7GQr3Pddh3d3hH9uc7yGugbnmEDtmL0O3jsg9qzhmbDVmm7KP30pAz8IrnA/nhb5jJVttsdltRHrGNRO+uJzs8cii0seWGKa1UIAZNMbjKQVgwLNkmghC7tmtj34fOXvefkTDJFiWtH8EVLSfPNIEEN092cAiAtw9ipES3ZofVo4zRtBEqnjzFcGrggV0V8FjJEbrnm9+CmtT0nx5d3/8yGacZqcUbcrmC/G0TMKVVvuBM4k3N0hJT9VK5UwDrkw/WX3Xcs+5QdlTLa696SorLUQt9t9fhd1vSjV+5PGnPZpHK1FsQXt5MtWoH6aUHIF+hs5E8+qnal+poIWWfmZObkLIcjMBV8x69c4EYWoysQ8fE5opd3Dprm2k44t7RyHXhaEyOOIvzw+YQY0Fx+v0t0cBnUVLhkjbScBdRc6S80kH95gxZw8o/y7IxHHMy0h6RWwVxz3/C5RPYdgURUvxaijQ7VKxgNX7F21cM9CdcYVY6ILOUyh55RqsiZo5P0I3C+34YWlFg5C4DkzSNmY0Xn4Xba7P5sntMLl5W1c5EsrHHq5JDiCzRl/JE6Ob3GUIoW+67y501cUwXlzrANfWaAS1gPAp7XxjO9tGvkvWCFZQsT6XkwXq8gl4pZkdAaW6I1UBUp2GN6JVEUOlJF+I0ihJPcFocscyQNJkCc81wJ+qtuqznj4tYTGy1ctE6k1XNRS/c+VOUIJzXkMrZRf8pfsVq0rwyUCDG2LQZ1WmM/zHAt/er8Fx15/4eWn8JM2voW6VZB5gF64rnABvZzBZrpzKrTn87aj/tgDnWU9J+dVQaVDlFp71/wvNGt5S55idx8JZ05ebkyXE3k0edC8MET5VWBjO9FLC4Fxo5gcvLSzodLmGpFUQyLHSyNRukvK331/OnUEZEpb5fk2Y6j9QF9jrFmQNQVl0Ugjge0IrJU27I8JT0G0Caroq0eKGtDBiBZ8qMILCXgLhuELAcFV1qOtY1oEC+u39SYjXxO+WsIGIBR1daW0sKosZrKq3KaetJ/1m7ne2qwi8c6mSuFRfIguklTl2QqY6OkX5HrpaExbOyPFI4qMykG+uJ4QmTgJJzY2I9wm94GG8dmUVCD8wmnAzBUKaeVo2eLLKaEC4d9xjKVWr8nCdlgk0T+v7rfgUeP2aRJn8nEE9mXEbSyiVJumcf5JzGOuQ+5O+0dvwWfLjabFzuas21QNaTffs+CqCzmpqLeAf73tBG19vUPHRGDvc/G5wMxVtyDWir6kXDqfEuqhQ2+QqjQrS7dR94rlj4D/3ok4PvRUzww=
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