4qaFVqv3dqqpfLk6x4nvPNwN3S07Nlb5wMr6hPltgQZryIWQ3Gl2CzotEG4P9tAMu35zVXcsg+OMhn0VLiqSZ3uTPWh5p/1gO6gkB0wNftcM8Sbo/Nx4JMxEV+Zgm/NB5M0audM8r5FlyPqcwUQNvoy78y4ls24+bqwwMIh40Cisg+//Xhj093DxwhD4YN5Y13pmjU0TUnAQDJr/HP7GwB3uneN4WOwEqwLqquE8FFTw4cNhS7I7jDEdHB7N1Ze1by0Go7OxGWjeTKdfuXO3k4GuvhUSVuNak5ZUMr+MNo9jqsGTfcCQCv3ESRuUj4PpMMn/go5QkZwjX81QthWxt693hM9zLQhwJulsnrarB9AhvTeT+0rPpwGnlHbHZ5mVA+HApAjICOZwd5C5E0bb3iB3u5QpJh+imW91Q+BBN3qHQW/mZvP7XHYcuIN8bKZpSyEOGEZYMLvjAE2h7BTzOIimeospG2MQ4l5WviJcXeT9M2uHi1zK1k5e2pkf9dl4cczURSQatyDHkAUk8agp6/2d4lJyuZrDGi8eNwHz+wtsHvRq994L1BCF2ch2gMhfTTxWvrGR3KlOH1ivya+gZwSldiONamdS2RVlvo1vJadMzfJJaasKkOxPz8sgGGQ0+CTkrhm6Ba4jSAe1DARDYfvzahJ2kDs7m3K0ymUX3jyPu5BnMvB/cwF3ETrVXK36xYoz013S0z3a54FTMEf5jKIGKf5rJ06QHghBwEtiq0ogOt5rjHomdgq4U+wDej9JydhEDNvlCc+MIl9Gpjbu5DLxeTPf16+SOqo3y5bg/ScILu/UqDWgJZ3wkZbM0PsCcKJxnzTqj7KpgVRVJbNKBGw71B+Xy10E/lLHrftOZBVLSmMmTlDc1VOT2jndMmnnCZcHlNSokCBkiPqueSuxnzB0fJxK1NX8FR1lzJnWHtkIDCgJV+8Rjm8SLWS9ZALXY7HK06yEJnnhGCaL7vdM1opgVYheQHXF2JV7A23GH5OOAexKnNLy15ClSGDOMZlFbNgTI97Gxfkw9/bQ6s5tgMTEZq2lTDbSO9Qss9FWf+e10LLJMPdWix52Wf/g6yVHmr5lESLelNYYbkaWH8YAH17JXPtCekTLxzfqw2cEWZBE0Q+Yd+EAx7O5cUIbnmREm472K6ARbam9m1JCoHmYPk25cVggrkk9Yo4pgs3bTHo42zVsQaVhWKRtEAOCCxLKfISUK/R2K1mlRWBbaznSAR8KEMNqFzckyXzXeJBF1hfOLrW7cGILb5tynGGPmH0agc44Ht2+o1QZxqVvi36zSkvAxRKyoWVV7rnTZ4vgTx85EicqRqXbwoVd9SJISWWcE8ongpmlauAA+K66leEu0L/xKqtrQbmTEeDxTh4=
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