snh+sN5TKTDjqBFKdLT7qGZ0sQi7bYm3jE3GHy8FaEuNTQJI1yC1z2oJOm/56wySfrXDOmR0Df6HAaVPzAkNQriHZ6OZBhFnUrrc/NGYBS96Ic0Afd176Nc7wHa0kFEpJUW1JzwPNfS6hjEveLYiE3vXHcUXLixfKQNzQRgb2UBKyFU17/aQ0VWiZIx2xGPKQ42zsffOtWdQz1afDOKt+jaQEQ683673EzR9UeSc8zBRdCOoOOOxwQF20ZfaIQHEEk/WGMQrcZ6eVLQnzgQ6wZof6BZoMRkXRA0eTRbI5/RJ7V98/NdXl1xyahTVicbOD/CAICegEjvNuc3JPcXd1YotDXPhGnX5Lhlp+jNmYY42PKd1Qy4Z2r8qrx9OitbjYkEheKa2JPwkKR/1sRGu0deRZxWlTh6XfKc0YjDlm3Ncp8uHsi03Gh+IGaNgq4y/BBTlkMK8eeaYrcdxaXRU9t+NgzQW1k0Pyniqi5dQdvPYxq6ULskN21kuxOPI9dBBw3iWtCNJOEYN/TnRLochCiehnfhC8u0UC32fCgzl5UPUOg0DR+iohjd8dPfxbMm1Pnf3u37VB3zwpfQ4uhI1wOc4t8EnYrD3c9ZzE3o1ocBYSMGi1Rs3CXphYLFwQx3GwAIfgeJRpVwqy12f5gX/D9MkAsY+VphZ5EJg5qASGdYoVWcaObPRbOmwoHxKHx9npLXz3B6yMaGUIbphRp9CNBYW7diEDtmmWCbgMEIODXpqfah00f4sDw1ljwJb0PNX1y0nNt1SKirq4zEkaOksGnXyIy96SUVGAbgQ1Xn1uxI/pxKXDcFw76QqsjynjTwYMIFG2YFJ5YwaPAybcMU0kRWz1b+8Gc3cBG2LhLxMsE5+VtpZC9UVgDCyNxrfBZQAnTp0U3yiEv0v2LwRqwUiVg+MuxoGNa7klLtkUV0pnX5AV7ko9t4RuiDf6iBSm9WvfZ/n5oqJ/cJSdMmpSTVX27ECJ+oWMp/HolBO7ywD5k6xhA9LAiopqMvEMXVfkF75McdetGaIGR4AS6H2gStNpzirtnW1x6tPlpHzkIi+o9TlxU2tqHT+9zv3aYjQsvMhw/NCHUHjjLlzNxqa1z3vFI7bJiweE4FH5ynEE1fkwwxazMK/D0W/wncAwXt0cpMZdofYWoPRUWh1hD3MGrsosq4vVr5XCQQKPNubWkFKkSMATrXuJwt2DKk19w98WPrv0g3BJ1aYLtJaYPyHDAN0+x6qhLYe7P3Tk7CPHdpY3m9i+zUaFYs50XrW9OEkIO7TNbP0z5Yo8rpkQNEf/2zdGgyeWhShmsG3ZHomHYS8XZzNh50ZPdsCJPduUa2ygNqcDK0x7jPVkunmUFXMDc7xVNdmm5DrM6NIHHQRjqc=
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