jdDAEc14N3pWI4+TO7X3QGDLwn8GKE95HaHKVuApCTniFt4S0wIIADOXNhk0PIYiJMKoX7kIav/BKdL5MlQDE3BA4hlrzMEY07nfFNvl8n5hQq+3PNFVhzt1qRgpa8yJ7ybcPQ5IdndE9r0quMg0graXXTFe2vb1fDy5d4eCEwL021dYhEqjwozY4pS4PRIglajwfs5YFmpY1Kzi38J7HozKRnwQ+DnWAazIbTOuKZTjfCx6jn16HM1oGZSTnkRFKi/gOI0RefEThEdazXuLdg2sKVodWWhfGT8o2HblpZMG27kjT3UkLkJLRM3a29HrtexBq4l7x2SptAhtivtkueWmFkS8+/zYI6yHBX81yMk6Wk/qowl1rnMPqFGsawjImm04vfhjTMTQoW4gNKw3sIYgp1Ag4leoHz5KySwYV83xzlxim6hiP+gu2nQoGNzGz6r8c2EAYxlXFYG8SIqWSjGbE6A4QLvNACP7qd1OfM8MGQvwFpcD7ojKlN1jMJfwBtaXUdlqsP7itDr/urznQH5kEQ5RknXgRDi02IdON40wWBy0ZMxK33/sBLjyJy+9rJ6vSVHQre61O3LSeVYneoD3tGAlFwYml3Wgk1tQeU4WaL8qktbcP30qtkFdqAckdVVL95QWZqRahrvaiADYtCBdcnKObsoVlBFk2+4tiB/qzirFBqe8Mm5Rg1qFjEWQs4fHGlqUIu5HbMUE/IjUy1ljoE/ViJz6CNbehSTaYZjtSF1STWzKsQsf2/6piSH/BuP5lRVRUMCIqFShHFvFTh/5OLc4wHxvl+thtie6Svi0c1ynsNPxFovU7MXxzLy9LehgPN6jLdx+FrJArFom4EvNoGNtXT51WKWVzD/OSDrbgaSX1DCrVEaO9govv1MO7G2RXAxywWAM+xRDvFK149fiSfMKesqDJyGyzww9WghhUWZXRP7t/yfSsE4n95nRJ7vr0sCgcAVXX5R6NnrZMyJMvbFQRxB69zN84826MlcJlEPxNRpE0clMkF/5fRvLkcJSfQnLwHGLhlE1CPy9p0ySeE2nq+k4DMy7zZDszjY2TKkhiuxEEcZA9lBQayHWn7a+1vsXSqytlf6dp8gF5bA3+S9T9KbhR2p16UpC0Can7DWuDJwc5hUTDc6tAiX2+1poXTkaDLbdaiD0b6gWkaWmNu2fASYwVGdRxsrBY/cwM/yRSVbIyDpt519ssQLZLLF0eF9F7HJj/pyUIG/3JwE/559hvaoy/IV/53Nbu3zWHLJgMlx+xwgVKQAk/VDAQQOTXNid9gC3G/8rvyQx6q4mJ2FxW2B2aBnmIzq2nRTr6MU+VwOT/S5Bzycq3FO9qA0oqfK1gMURmkocC9RaUnUvGHZPWMTZvmulbMI=
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