VsEH79nmkGVtNx4m61Yt0k2o54TONmuxYaLz8EwvWIX4cbdjf6IzxCKnkVw2R46cvb904ZgqF1Go3Nobw8+PuCdETRhQnIi2Gr8dwUEPEG0gC5vJsgL5WtCGAtQsKbOn2wM2KGpOk6chjbQPzgi6C9Y5cogCa2mn22TUhRGUFgEcCR7Th2nq5g7jtBWEX6xGd10qsfhVVxBbhzK5l/dJ6dGwkzSiJ9QRa5TdbEa+/4bDdhmpQkwa+Dcz42yCWXv6gQvL9EUi1Z0dMurjWgD7Caf5W7mjxQQzpEoA6/HwyiHAJks6w7GA08JZma25i1N4SZYxSyjUPIy/sEdWZP71s7iGgC3mjoH8SkRJXkYtWKD3hcgGr1dLEG/QhB/j1l8jacxmDWcZRHS+AnzRs85Wy/nK5dTvqt05W6Wek0isE2bNRqCn+HtzFK8QUaZgRrVbHLcDUkpuI1yhUa2N/CfA5buRzDZBDva8SrLTPM2b9TYe8l0ceEW1Me0YfTjJsN64CsVTXKlmAKbuiKTYsN7MaG7HE0laJ95dlc5xvI2itnp60eFMsAxjSzqFnVEgfhuurMeTKTzKzVDfxfwcG9s7P80fdYYzs7rnM7ncYQaYu9Khbp517WyJrhhVR4E6CxU9GNY3aLuIjInE4R+qsXzYAK+1Os7zV7NnpjqnvkLfBppKM4tejxC1iEnfCtVZBMivgH6F0qrVM4Yr0gS6KSubg3R5vQ4y4YHc7RTISUkAj2qqLrOOxyb5N5tAFtwiPu9aQrvjYgG5nrRbUDno7CfP4yvYVp5L79bJAbDfu9C1mQ5TNOs09lzTx5X1dN0B0KKuH0r25Gm6CYWIt1ssIFHy0AYa4M4eFX0XB4XKbL1x10xvKnJKJ5FhkWPT6Ysyc1UDYhwijvfZnImcBZHGUItFArSQ/Ue+qvjO0e2eH2Y153Lw0v13MyHPcJ+RsdAWiHwJ/UzBsJQzLh/g4VVXaIpFVOGTh+tZPk7QghpNIhS+bH2FVtFOZcmCK6+D8kG6uzXrbEs4XMH4DXmfXspjSPopA9jYDALh4S2CzLHepqtYeONhcn4fFZH1JCXs8/qOt82Em295BnoyD8+d0kG3ecjDC+4zAosOiY7kaMqbox5vFpIsbA6HVVJEo0aRgCS1WtxUUEb/+WXvgc1wWWSihSNSP6O0AgYWZjv7F3Cbi33xTi0fcVQLE2VVFwUhUeXtaYa468jdtCSokQ55CeR0eZZXAyqHIuf9lalTsL2jSv0gRBvyr6dxdyBfAl7tstKc2SiFWh6RxRs0fOUJoqJF6Ckj3uKJBJWpDsnoo/PI0GPZie+AOecc1w5F2ag3oZWkNDO1+XhmUu5nT5jwCONw6jcwyyKWGaWyxQIgVZZjG6A=
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