1lE51VjJv6/ZYi781X2CFUka1g5836cBkiZ/MUnPuOnbBeui3Wlvx/WPahdOGoDsENgc7dOdti7EznSLQVkVHVX+PPjfJ3HDEDt3T2NusFNMCMnWN5RHvPQY5Z4sef4PcoDuPIb80u3yDjfFgRl4q5AnjsIxrPPnj+9idVE08qjM8jkGZYRr1o4p/7kde02JEDgm8wlcVmDlzmfBZoPr7sDm0AbKO2X+nnMpRyF2WVdGr5WbqFYTcuXkYn84RFVlVUYerZJWiq4A4EH3nnE9YUJOQswMCVB8VX1DIVRsgVTU1jlidj/m/yNjqzj2OxbMkCFvm86UneKxl3jNS7cxQa/rh8f8tE14iHfQfphRw/31OT+pSNvHNmg4jQikp9w+KcETXDSEOuvDReENc83nwTFQm6cBJLSv2lHxoievZYeQur9fkc3ms3HcFguaI95CE8oz/sBC+9p/sLLC97NDnlOGCa06sMlw6yVRmCjMJ5Nq4GwHepfevmtJuo9u9CkURu+QFMP3Eu8GL7Ffshkme1J6KnQNjOJS6aAslLrtOFDe9kQQQzGMl3Z675vOwKsAfVWshcFqhJ4cvPiFSpTpruw9djlseB3L50z3eS7PYr/Dpwcro2cfnJUMpwvy5lJVPNQcEaffrk3+9NPojrdxjT0bO6RX+KGsbL2jSsvq4kCuzJWvEAw5olEqkTBLiq8R/Wnel33CJNwU9V57aotizJG/HbM0ZDyPh6xECdTGcND1Dmmim6Klf377KeYDBebaVxu75JiB/8P5fnE8EMTw19lE4Wpa7AIO5Qu/y0RMGuRLIwgBkWphnWhomUzZ+nI/+2aYx96awEhq6t9o0nKAma+8cXIKC3M8nxjA33gdRktibKLl1VJRZjzIpL1dC2EqNM/XGsXi6YV0VHNr5WUMTAE4edmojIoObs4HnPGwcb+QLahJo8gwnA1uCxq7jikNgcAPW7C+OfvESF8clRGGVrZ8ypB+RxO06Ejj9Q569lUuY/AeRRXZrtW+EqUKuMwUBz+J1J3fiAhA2u5z1XFtI8bDEOnHiy3F6Lk2jgch2WbGlrZScGqsB9LuqhFLobLQ2aYBTN6PIsDn5Iv8ISUtE5ZCoMDt21o9g6gS+HA52/hL/mEj6v6Unfy3AlWkU680SAYufSmohKhw3IAhxXpZFdi8rLveFlUOQ4zC5uWvjoN0OBjegPEQo2iQStc7zYHtEZ8ujio8vlOZu+crnL6uy3+tnytrVqIHn/592QX+X5pRPfe7+6c+Kh7ie1rGSw1QR3x1nndhRNmfYVC4YltxX2lHpsP3fAH31e+RvalNp+0uIXykaGFkEQ6M5KuVgsvoyDKEQWGMIKob0udoCz0iiFo+7m/bJ8qLH2ykBko=
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