vNeHBycplBKERPumf+BMTJeWhT28P3d0x5/6UT2qzUr6Zoa/szRT0EsWFFJEsF/g0Kdoe8eINT9My4YWc9mJv1ob3EeTA3y3jCBeFtgnKboATm78nU7RmE5eY4jRx3EiOzNfwm8fYb/XIjQxPU0169lnXvI4BAtVigttNE61tYfAiCfAOOawyoj5J9kZNq95miLtNMp8AVMOGM8q17pQwmF3MR4+2dFp/YYrYszTGynDRRSBwU1kW6u1GaIpo7qj5YFS2OwPOArKybhhz/XmOJNA5PGD4G/3WtGmMRyUkfDHokSem9HtNHXja2dexOlRaco1Zr+TPZkPxCG2KUt46uxQVGwRMahZ29GxF5I8mwX4N6SJUm5Fvr9O6wgXCqvjvF619G0Aom54Qtq7BIr2kx8QwW9WVmWNhVBDmcPiZzKj0sfakLrEdVOJBBeH1S81ewZPX2GGSJ7S4HDb3wPrpngbNYh+CtZ20NaI8NEMzPwPJQBOw7fSCU+WADbeshr+gfcPrH+UlELTGXqj/JyfFCKEt1d782CrOP/gjcIHFthT7GPNAB6Ice9clTsioIFYgOzEQxKtZ7SMUFxJ5XHf6N9LdHl9CTy0BlpocLFZBr/UG0gE2tTTcs5gVCO0BFogfmqC/Hh7Sq6LBb3UNINs14+l2UyvsfQugTjvoJ1xU0F/6isozvnvokoz+9fpqKfEyQEUILPrk36K/VBX4iHHd+rxfuui7RoF7Y0eu7DjIA/TBM6GL+GzF1x/HdcR1HR8ShJ0zj5PQOw4RrhsKyd9MRwiqyR4NKMRm6Bbfji3RzWpJZ0Tlj8yIIwnduct21QXKlmrahZBRIxiG8f67no7pg9A/LoYwt06DncPuGCPtsfSEx/dk3G0Wp1HdZRjvPFgpnFGjA4KhmyeMp/ixGSKT0jm6DYwWaK8Z7p5kSnLhL0rvKEN9+sUHBARB6KZS1pDMidp5odovHZLXYhC8DDSAYY0njjCaPjoNqkyc9FgqqUhAExOS1tVhBOHsdqjjFaiRIoyC9SSeQIlVw5C/gJDAnYjYF9zKVPgQyFU+usCqKSNC4t2N0MvOTeKCYj1VwxHE82Su/p3OfhbdSjgSWWw6MR+jk39RigoU58Yg8zqKyUTNMv+Opg0CZMcgrW8CKrN9tHYS1YMWeXrmJ8/hmU7lxIs1O6c4cgQ7Z7ZAlTkcpd5HhgBpxptIz60jVLYPobbmVHAerwGzRLxs6ruqXAFqWZHQmpNh+1MY91uDHz+jJK8L2cyyo0ohNZGS1O9/GgBd2X9RqKjtIjdK0uEcajx3U7G0VSNTSH4nHPeGMyM8nZxZjGRfUy5wCHTpCVk2LYvCkeXoD9WGGfFgs4vRtvGG9ZsLn+S3kruu6U7cMw=
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