9MvUjL2Ms9I+c1VSaTXYtL5c6ZhoGXZb4eaImeoxP4kPEX26Qen7/b0tNjiljkMCO9q/XOmuzg94xY2Pi8ah+lNxFyFoQ15kFWyWqeBr4uT+Rb8Ls6AdwSentXDvC+sfjBOBsuIBv7gU2l/psIys7Fx+RC0JcD++cH/aIEZ8pgENBr3lK3OVy09ZL80Teb5l57M4jTOYMbRuu/4bgH8z9i5egaFFJ1D7q5gUiAJ8YLRgowSJ8LcRsm91TXMvqCRfaeVwNZGrv879+wx80A+9HgoPsYTHJqyEv+eGhh9s7zGfzXgyn0o3/UoAn+AwXqn4kTazn6tc+N5c9hTFDBhw/dmekQGPDGd4VxPvh6PUsFWZ8/dzI65/D+YIuSZ2cFYKnFSLaQzwcMNFfHqtMwzR3DxfYKNvdHzlmXnQfev5L5DVauXmsjmGHd6thQfQ6Hj6FqYE8nnCXenzkX8jtY0Q4FW2GFy3vk0pDh3n/zKTOc6xV5p0oMaNO8nfNH1Mi2jl9y0LLJCLAuS2NCEq3AsmlE31oebAolwmtWfknrVu3u9dpMNuzjRdZvuOtMlgScKmRxsBOGbtL+P3OtAzAU6ZTpEq96hZjyhTaFiLLU73kVubDl8LCC8mv7AWc8Siy4wRlJ8E9AgkoQQSypgxQkDFazx1qzUMhl6XO/3w4jympM1srZznEUubzqFqVfWtYRbiakyLz7zWQhw9On+IAyEDxvLHqr7oF3Jx4gyLOyI+j9MK1VmR69wGfbfSpfVJ7OhTIRlvIPXPkC977NXjYOZhwOLVrCS1g/CN+j2LLje4pfffQyzvKPAFElGqUY3lQDJ4Ovn7aHtT4pb2yYxGu8/PEXraO8wV+VLDD4WGuf380rcogcRi6dXHMHEDd0ZgR2m5NDx7oVo3jRN9wzaAgpwoTKLS5h5xWyXUNiCEdyXfJaHdrC5Ol/HQgW6psCRSZfAvIqJbMzyPjVnfMkEz7qSGO6SrAvSTPaFDaNDcztGoMteSBXGyBnofwT69S9LdPIcMEjqcjuOnsx13Tj7ydxiiWPCj3Xw7uJdAp4Zx8lSNIuL6xoLNNpiZXqkxqV3DLI5I6KPKLiymGQVsef/gSRnnMVDtnr61OXjuKXNjAxwgztiUYnj6QTPEYxDjhGuv9F7nxClK602u3PHaDHTg2SiEn9S4PMIb/xcUCifuZqEfbbiwd0oJArWwqm3dTCB4P88ZJj+ay60TA/vggBPbIj1ebmERT5psIhPQ5lareZ4XcmTFSLv03kCStbYAkoqmIgO9RBLRUzJBK0zx3J5Ov3CxgX2yFsKQl5RAmqwvh4FyA7HutwIT17g6tux+0YLqYnMSW0d9s590lGF/mV3PLD49BDzuSvOslEWHyQadrUE=
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