oTMeEq3eGJHNsZh/Ibddr17XglgswkJGyBW5jzXtptqWNi5YAzJczup7HbmnwxePtKKfeMBEStbAuE0TnDsgC+n7lRhai8N95etyTflJ/y470j4acc+INqyj5JeNFo5Ty4bS45xqdgDxrpDZN63hAMWZw/iIXngTCUcCUPx/kXebkwMVRkFfg1YOhNvIyV4wZJr7hwMDvLApbNT2he0LRxyC390r2l2fgMGXQatCllz9cXvOUd1M6VKfkvfwlkFKckFUvrdUBNUj9CrcSTEX8lYo9zlww8igUgDBrTT51AYuFChKraHCrVz63hqc+kmt0KHNSpOtRYZQUdKdnyVhBgKFTyhdegI0ZKC/KXbztFedPF9SvUBPeDNKr3GFcTZEy2ptXvdUllC0MTbxPvtA+KeR8Fh3ahuYjGHEifdgAQ4N7lxoTgk0ut5pnnwrziroRcpDOYr8gdDv0/pNwk0km0Pxoe6bBoQK3yKPWkPsCdaN6imXoSfmpDT25FiWm1UkzwnvPKbjYDfH03f34xkFN4JFbP+NNdWRYh+3OPZZ2d5NzAOvIgV8/Sg6d1nwCuvPReSF9CeHQjUu2yLQt6Iz3zDaN5WCC6IF1fGqRMShzUDacnppobEW5XuNCMOZK1vBO6H2zDQoBsPaLPNMfdsvoWNdX+fagGRYy3YEIWVdWJPeh9DEC9DVRDN3OQ62sUTUoWnGwpFU2TRA1icHrllrGtqVFza77155JCOODW9eVD8zn6AvY3Fy8Z7flpd8+ZWvCMgQQuf2Z5Zi02ETnaV8WE7qWzsk1MIvn8vyHmhffzsL0QY1AzuC+c7Lg+kn8ra8iBTiOakSgJTwNnJNqS4L2XYIuwU7TDBTkiwt55/sWm8Mpb0f/elXP+qvWTbT9Q70B5xnOj+qwKTewqQTpnek8rtq57QzOlInpjt+ghghqEye1azdwNbyo6jKyrGlI1XiwX316nuw3b3Qyd57kp0lz9eNpRV4Uje6vNKaELcaGcsWTI7uFez5Gy4GDpLR2mitrqGIgTBART9uBhkihCFen3dR9epG+t4oUqY+R83jU1yU5FMOkRxQ1Lp7o27FfGupm8GKO6zc62YDOLcIedXuSkux8pQ1jXw/jDiGSHI0AiB4wd0srLoxvQYbSu1CuFuZiaZsl3Ttwv4pAhJJZhot+Y8vgm2D0ixbZ4Gf7LVq3O6ZLGibnBEK/nEwJrNReNzxWQ2zyQY2oQ4SsVdKHi5a2m3q3QBKtrofTxtOHWsuZGRXu8XQ2fiayhWwkwGrH6wosWDZTxffnmb5tPEDdk/7B4cdwq5CpxMGW+ukU5h2JDDX0i7MUWCbCUACVZAU29ZvsEAhVJgK68EEGIlnqegahAOWvXi78uiWFRCW1kg=
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