NmecOLjzkJDDogpx7nQtl7rdg3+goEbQDw8f3QgqNlUuHrmDV5qaxyfawhLRX33ALQWOlO9Eax0+nab/CNA30Ix//TFGiRov4zyiSIqg66VTSKMf0Wp8wbuKV53SJ70+OWGXm0KlcPTFfRQHzB3aQ+bLH5sNs4Rt+DrQ0YOk3GrWeYS2rjCijz+mRlvtX7D5xq1BQiuft+Z2pT507qOoeCC0Jf+FFdnlmOUrAF8D/e5YbZvZU2oS5pv+A9e+QDiLrlBHc3bxckhmfwpBR8f1NbdJIxkYlOMEBQSMLiGGNv5SrofVNPee65vZiqxA4tjyZGaoKuMV9UNTRoC94GDEtX+KXiNsRXakrXH6WRXZjWoaOmOqMupq1upafmmTQjFgb1c6kyd1eZM/tiLgwnwKHTJmB4Ue9oJ/fK808bycEFD7QkVW4YKI5CmYQVxaSWKh3hFiiATG9eAiZd4dbKqxtKe1hX5XUF46LXttRo4zkdAgyDS+jsThHdyD4/ab8BAvPyfOEmCb/oMV/zUfUx0b27+5DQC1vJBV0dpbp5XBUe72F5Ayaa7Lw5gs8Q7ni1L6L9EQiJWpRdZC4+hSMGw+JtTb/JfRPuZzPgopbGoaoiI8VmGERy0lCdi1vc2uiurMBCTJ7AeZoSIBBLUJvYgIrnzzqev/+G+9m/0rkRUIJrpN8l6G4k78UwDHPHESVf9ZCyafu01s9T11l3MoF6Uy4yL6M+pc9tlQUWvjOcCSU2YbveMq3ELLh8e+IAyqdhbLWlK9gOCekPMqIkaUxBFIhegPZtJ/gJ6nocFupnKkwi7gXn25uwPnwi7GM/P5g+W7J8k+aiTaPcfVSShsMH/8OdkLT1eHL6z9eHck5VYjjqyZYImsPPajMbJZa7MrRtNJno1noxz635n7YtzbsbPZ+Nb1jngoT8ITa3A/OLGvakeSIWb0Q87uJdSdJXLy1sDWbjShaQJF8TaDOhxRr4Nr8CKeR4ECXYH+Zs9iS+MllB/0+LdlgX0ucU6gAg8tCQRHN7FdP1Qy+5yNtwC45Fs7V74uUeYOoHE2zVJHZbyoogLwnrwhv2FcGvJbUzw1PMz2rAnzoeUErBsRCUiD0EcVDUB260ig9kqw93jedib7q0GTWCGRY7wXknmTy/Uq+eFei/0xLcR3xAdBfmtKnMUY8xhY55ft+P8ZQWq5ZKpGtGGW6cNAJr5DaZ4XbTAZslaZbmj5gJl3qmet9RKgOXMCfsA0yM/r6RdEe4er3upjN4dkJiK3BwIGUhW2F3/23zzGClbMuRv50gbarcRhVy1bMLu5R4b0CAkFLLNBY/8h1L3fLIIWK+QEzAkMe2xHmedkUM9mkTmIK4x//ZGAPilpN/ZNK1G/pF4PahrmRtY=
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