pyxfVB3DdzjXT3H0RFoiYu7sFQIf8qO7K+mPWPHDZy1Ra6L7eK+ozM56DVcH/5tFtmGmq/MR7lyKxyUNWh1j3Gza4Fif+87BJf1IvWnQFwGTGbpUvYfBSAlvgYUxkxq33ZPC3lorZ7ffrNZKqb1iBmjsWjhuOQ5TbzrENC5Y73sbVzCm/XnJIw6RwIWXFFpanH1eRECaHRp2i00ajJu7GWDBcIALYaQ5p0W4drqbwfnKQEiwxRxPSPL3YAl8fwK3Xxal79/q39lx7OFSyZre+pW80LqyN4Nk1uvUnyJ1ZzR3kigoRIKK+DuSN9drRZqmP9EkyOeyMvEkOlxUZknbYOaxfxi8bM4XHLR4rjkJwNlgJmk3lc+iYZ6BAhttZ1ANYxzvF8lnX815ckflUtX1kYLga6i73ClMLArCQAYVelR6O4s4tmqmpPEpxZmeMxoBb9fEEccwjeVo3Zycy1p6ezEwFnQ0avjluuTB+ZbEJ8QAL3gXvdK6m1pH7MLWrx0L1JmyPqtXS6HjQvn14FJIBpxnQGOnUfBGniAWOvr3iM9M1K1XguYpHwurNCaLP3+VXK4opilDT6g3RVZ5052GNNcM6mvxbc88oft206YFtol8mbgONELHBHxk6HkudeRxwcii9EUKZs9fCDL67rvq6xHDf6aGmg/gg8uw0I8nFkUm4n1Onw5hPq03cP8Acmek1V7MAByz/dK6QZXZn1JxPxxJWI8ED/7rh/TkuvLs+/uewayEm+WWqpFvaEaWHl4RWqEQrWDrE/XNTM4PyK8ajXlo+NxRbggxxbwJJ5tc4LwiLzDt8daKg01WvxeUCDeiEMC22nPIZj0htt6oR1kEKgJLEaLDvTFqRgbKqkRQDQs9KGJ8xFfgLHIDCqKsChVBgbOOi2FgtgP7ytAe/W8kZeHYR57SIRsU0xGbQpcG1bZhp9YjN3rAFtKrqjE2v4GHhVBMVgaqCngqiij7U7zD5eYDBR0NmPgsbxXwFgGmKeT6smH+36go85FgubS3025fVOufznqW3Ne3rbdIFMohp4k+K17l59iqisDLquqQP8Rhe/4fMH4HY/cqVPjYjUc5PyPbXNIBlDVOFpA2mQoiUGFwk1PnQi6OiuBVrxt8tZnNiEBw4rjaYtLxG9Tv31gUKKCkZMWkxFUJZZjcRfIiskQ3sOx6CS1ynLCkAWbEe92S7tnGApSh/MCmk2zehOIotlIT6E8tRbngOFmKnsc1JmKzQvpXrRQypRyl3JsZZL/JaPVjoIYfAE8JsxQ3qm8L2v43yjK2OsMqV0xP78wp5rVZY5uuVCwt556SqS36uSCRC4EWlb/IsfpwSBo1jOocytMr5ICpYi8nKQqtSaY3dE3bP2CRbuPenSUQNLg=
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