/4NzJgd6Y3Kc6PmIFfWnMjH815Ba7UFEcgpbbuOB6D+v4ck5BVZ27m0qYB7XdKwmphg6BYiJwbLI+0G4tKXSo7LTYYYLpUYOHEOm6OSkl8ofuegsgD+cz6+FACqC0c+tmhEj7+Y6Y85RKprqMAeyJDvjr4d/MiMNm6LiBMzZk+NLWZ6Rjz2YbdJ+FgSqtOHZGCsjdo4kz5XB2htIM+dmbABDltqJsjxWZszwT3xHewpZpYoP2fa8nMz8EBB7n63duRaGeryDtHSpKdMeNGMLHD78NFzLbTcFgpzsotEQImlw0ajZBp6SvA7F7cNSV4UQCAW9f3c7YHDzuGKDiXrPSLmthUDRLrP0vQEsqZzpJUyMJ+J94t5MpMNtNfK4NAFK/mvXVFBMmcf7Kollhk+MnTJMDAwrFJUaKiKhzu0Q6ntIgB7ES3i7xqwKhLL/yHPbcga1C/RG0txjtaPZ9TN/LCIOkYNaq7yL2mP/UK1vlUeoYgrXphIRCD+a1xXZ7GhToSozRlHT0eHRrTOR6aE6k+7JVip9xOxEYufZYyNrzq3i7N4Rj1QcfhV3gc/PpWqx3l0pbEPL00Pnj699kBJ4JpGYvV8LR0s+6iKNmfm0b3THAKRtFMqYBCBGg7t7jSC8vzDdp4VSOGOedDhL5bSM4Rf/aDiO0jhM03DTCBT4CRa8Q3Q7KhDNeHl9jL0/D4pCw2kspNPILS859hABaB4+h+bzC+7lJBsf8S3u8UcEfneulb1B5e9h47wFjxT9HhhW6l4FmiV2RARpyzbHt/LoAqBZAYJdDa3hD2KDL0Caz6Z/DfEfe0mansB+LLXGMik9p63sZvJxQOYULGwhi76PvzB3fmXIG1kS8VmdyJ35qcJPazbjzPOo2tMWEXt9CSHTiu+RSQj27DaieacRJ1x27KT2xwyjQngAUYENCoh0v08rbrMG2cn1fM5qsRhB/OKh8TBz/Vwte0zBmr2jNG08gIjtnw2FGZDl6YF/khlqipIugg34uTjcxmKF5SPOs4ZCyG7yqRbPpqnLRLm1JrRTQtDR/nKIK6KxE22/76s85cres75P085nQCUFVIxJnGYYpZW/YKejhHqWEr826CBEzrObVvTGMgzbkIETcHSU/fxyPbwEdfhTnyNZBtKegOWwzk+lwPQD2yZCff70lgTsKqgjkXH2ztQic8Mq8NsRI7TU2MmhdmVgv1RYsUPTPk86RU36o/Z0yn5bMqXnouM36yWeSMsd2NY7sBzlYCIsVId5c1PWygbf9+BBPbQ/12u6TfI/6Cv88iDYPsbBQmaYvjFgv+rZE2f1X/unwPY/hRBwgPv8lhpXmZ2VDbCXyZR1v6yzLsDKxIXueIaopz4o1DxLoK70o/SK59q3Voc=
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