WzpfPIP8YXRaQl8Z7zWVtxXgrnl4v0DRBw3VBfjGOwOKrjTRQ0F2K/HHSKYyYnl+k081sJVQmi8kP6lZ1CKW0G9b+RvVxOL0bzv2HVk5ULGUU0Dx+EVnvR3wt0KSgCiZkqAlZabTCEJEHw30YRzvLoqni53bR8pqXDjikQBjPS2yBAnHqpDHXzdrdiAAAXapF7NN5IE9Xr7N3bprJVp9gK4dgLksxg+yPsi1V5SQIvo+LG6BxJjrSNhUDIfKFIcQ5keIg2lmr2XZZPR6rIX/frolMkXT05DeoIiibnOKc7A67fUc/qrFhGlbQB7D51D2VejKvc0p7xVU/IWhhlI4smKKT9UFedKARJ1+BRAtyzQc6hnYh4/fMBNaY5Pvpi77HFkmIF4oZ9h1/yHLp6C0B4va2Dbd74oD+NCcRtELVWRy3kjNZyzslGMdHYBN97/Me9um/G2I9tQMGnuPlI6POHHrNo8qmz7AyCUYik6UkdCQAIzvW+8MfCwWNX1rqL1NzV2gifgqFUQz2rJMZEOqYMSn17eJ+8jVIvP0ftpNTzwx5bBTAKNUYjDSskgW8HFHfkoLmCQh61vrzPP938hcH2Xs6/3D9zw5t6sJ3UcQdHvpteT/BTZQnh3r30gZ9Lofjd9l9wRmgra3CxqvEhLokwzXOkeFh2Lz+Pf0Vj8XH30P5oFxhzitAv9KTwYr/HRCf7wBPYArwYxOpYgHsAeLjz/SUXJGa0CXMyM5EgpGFWhqTGFMEKjInOFhsSL2V4H/KSYwMOcMpmk/fg9Qk94RHWce6eaxZQ9bzQFOrGAhUWnC7DjkwUyG4vQd4P1UkZDKsIkg9o26kgokNS163k8ov+5NfWfBBUw3QHwXUBV+lQsVlc4E1WV5SDJorSyMBBS1M/MYPKP2QWk2tDnKWALRvlDtkCYRYJ0McaSn4VPTKEMn10dUPb+H5ijpG3rmWwtOJSMX+WaGW/ehAbKEP0sG5uuQq8Nr4/UEiWEWZbU1j5tYhVNm9UDYl8EhEM0S8iaXzg0a7cxOubAAZ/Or4O1ynyFRKTyzfKKjGjC4ofvy1Jgaiy5jJisUlFZrT5ST7otH9PvWtEJPt8IN75UyJ5X8IfMuRnOoRGGTQdLidiAIt5qKA+JC3ucTKzXheP5sGZBBLPQ+m1fuk+i02rLGf9W+A5oV+47AzwoXkE0lf3vKZwweadpRsTRzasPxzKnVvaQxLSP+AX15yFxsGGQ6Kdo1NfBn8ZxluaPGeT7MmI4t1bwNT5edlaULGNdBEqf5SydT4CLiLHkASHNVJQDYEAMlNfyU/pXKU6jWHyehIBUAvGGNVjFc49seMhpQdwl6eozr7vNe+h482X31xxEmxZcvxFdYaQh7JV+A3p1LbCo=
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