TSEbg6m7YFXdXBYcRl6lUUcdPsus0PshrwSAO78r6kHK2WIvd11yUhszk/SOi6Ah4Z1XDrsaaJQtM0XkEd8RS1TpLh5jUJF0CxQxEyM8ldI+h36eMMOUL7pe1oLHZQ6JvcvfWsGCNjAqpn+8DotCGB5L1dCLnCmvtjpZl/gufC/nsyPyYEjYwzPdERqs/blN1uYd9RRwKwNYmwDSEAQj3FBTTimG5WfcLinqVybStKwSPu77CmRwJleiZQSZx2LpFmrAMYijLX2q0MNF+LsQ4sKZaGRmXzHSNR4HMN+h+bQjfOydZ8NdQIWb2yHNqUq1gLmJexeXlTLkxw2z9v21X3DYdoYWNGPE7btYrV7avjgUDGxaP/f3IWUeVwnAnavCLxX7re8sM2vuoD5jZU3atHveuSYSUxTFRA1sMGv4k2EcWIh2ucxBOlVah76BJlVkIjy0OK5dt4mieA+X4GQxxnqthM9Uk/tVP9EuUmA7BzCCTDnytinYRNJV5/pttLiRtXu/AJMcAoArKrlSBF607OxpKhtkBxI0LDhy2x8afcU3muOYsdTiFhgofuQgtMtXwjqLN7ITh1dZZOHOXGJ/wfj/JZcNb/+vaPuycc+d8OHe+IvgRpdEahpH61G+GryNaRZtQFHMubbrUP2iFq9kyAkDvFW2u+oigSroEJLc7yze9cyJHqb33tTfbnbvxM+31MyHjqX9rzwlIyAZewj5eYiUZtVcDsoPe2dfpniOz80SPHoC4P6an6UQBdN4CTTvIXf5hhamtou2BOUAG+zGnzqj2D2SVPZcNrrLX56gFdfr1r9PCv6XfCCj32Ikw9SxG63MFYbA5B93W8TjEdCans7qO9RR60ccQ7xHiHY6rOdP5g4uS1MzjAVkLbaGKEwc5Ey5epuQdyTVRHhKuf2jMQas1lSzR2whf3W2PRgZOT15g2DR/pTWRJgQpfbWEBsY3LSARCnwJydb/hMGGMLW42fKHJWF9RLE+twOOHg2So5zQiSjF10ZQr/PTIFkDzmPS0UeG4cVcz0aBx/HRNKwWwFZ8aTlCSod1GcYKwSFAAFX9EKOsv1zEeK0DME3lVDghJ63yKz1SV+/PtACobn3XoMDHCbC8VEYxwYCSw9r/hO+B91h4k490q5DuLXfJPwjhbBWbxMkPfryF6ambLc2Lg86301wVoGiC39617eDAVec8mj3kBBLO5MYGboSID4A7TLwz5l56SS9RU26kIrHft4BYtNcxVWtNud3IXyyCSzCgmV4RLIoBotIjOg4yn3HZ7gWVBf+BgnALBRMlVG31yUHEtILd8LS+p5LdTzlVvGbJ0JHwjtJLqfNn22MwN2r5g/yHtaPvjeJ7kI7U68KkJ0mmwJtkwTBbZtbcVc=
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