raktW+FdThdPHFFxbkx6WVVCn6ido/kr8EcjDhM/5KKMxNiPKnEAoQ259JGgGZKhWnbBDh4YXWjvO5ctFUMu8qGvSgucdtFeVMB6giPE5oOUy9Z5CPsymBeAv2nlzNPzhvRZmlEdPVfdRWeyX18oBECy2VR7p1q4LxJzfGPFiguYNwJyBmo4PA3EiKt5/+y5kym3nOpc1LuSUozqIWBLaNRmWkajCPa9NUqO5Kf9imovhN+xetgvd5izomFrg6Eg7xyQCcF5K1DCaMpqPGJy3wlwe4+P+Nr2Ma1dqGAFKEKXs4GgSOh7m44LZebTYn2PnNtgDgxj2Id8iYhZCAxIO+yin0IB1ByG0oaILENnlS77SYuNGg5XQVJ5CGtaIgae5QcqyFbXcgJWi9WlUw9rGswgWa2o7z+uT+1/oYpoTRsRyEQo/jab6SOTZkg5TCwfGDny4n4OZo9orf2ZroMFcKG8wE7WrXAOy3ngS7Zftcp6Sf7DWRNnm6aZGtM4HYFbGjukzAdnKZRqHBASe4VxAJZ0WPWaQmSJoBNmM4DhGWkVoXuvEuwIg4Oc8snQkVk34Uw0KE++7K1Xa0ea23DUboG30vTOMxXAJGlu4xDE0ZLKDn8yfSj9zOaTGsMNPUdcevjAyvSzJ/HnWeNaQUHtilQ/ceZVl6z77QiyQ4GCQM6WVtRkUMrxrkK7x1OHc8Ut0HxPgl0xR0+jonKhaNzFAiDhDXGjq0CFNvtOK07gIBpTwpzTSSVa7w25TyBlE85fqrwERq5jTuJ2Hd5czJqfwpe2EAJw+BxAqs/KZngZ+c64UTN5aB0QCL0dyocvzefIohr/kUkW4338YGYKXs4EqrEdagTdshytfrWb6MGAokeSmdWqM3ZfSIwXPEh+0O7nBQjBa3i0XMCtPHm5oQrU5Jzwgh9KSuF7TugBmidyqLw5hODNaR/bJRIHFF6zjHVZ9XVLrLNZdSsjLApVkPFP8N7lMjioJVouBsjJ8q9XxDA8qye1KJO7/pRKV2b06wRZFHxKaRaPZ33dS4eEWcMtJ1pBISt+X6H2BzeOrgoaEYyjWH9Esu23XEXOqODWRNKgF2DYgp42cJIOLtLPu7suM5BSNHxxniQxTMmL+WMHZeUYFDRYH9R+dJwImy49aG8oZfMH3yLZtr6UYJrcPhJK/ELb2rf0CGhEgzs+z5MdLEPbUBgfduOGF3V05wwAO1kyDSu12TW1Z6Bc6/kioen9vP6b/oUBnZCmQSjKo4AOxPOyyzs5Wl2/0oL9HuoZ+cn9XQnlFQmF1W94nqRDZ+cgU7Aqx3szoOm4JmhFU/I//5GOZFD3YNxRjgqGkrpTuuXTIBz5BWt8tKS1/+zkrEShZfLnEfG1avB6uQsQg0w=
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