by/wO70F4pAq3Uinu1EGZ9RpKGx8JICKihnIaSi2NziKpK3LLrn1/rm0WaQlu52ABcstBvPEZpg9ebPe9GG5bPG/FpgxlkRdIwnmjyn0cBP/p+VBfg6KhtX0BhlAx+MQ1fR6+7BERrY4CwdKVqPCU3FeNDzwk8qPlT1HswyMkISZ79h41fLTKAJz8NDaf3pMvNhlav+2st+C4CQ4AhMrCdlasSAF/XvBhUIfiaKEjJlFZw7Ek9It3GSIL2r3Gzu2Napr5/1mfc4VW22iOMny06+Kbq8Md5C/FIlZmC0MbwzbQ5ZTULvHUhK9eTf2Z+sCBj4ozp1iFU66QUzJgsYZ7JvR+ecfEK81k69ZhNO/RsaaVifWBjQ2k8uU8gqBSz3S0+IEbpb84UdWTkM993V3w1BNNQ9lE4XU5i1VduRqTNzUY1UDueVARjA9rCz1jyxD+22vpUocXfLgTC3fV1YjXqJo0YmFVDCILexeZabYESPA1qDLaqIY33MGQnTv+Hi6wd9TuCRj5phOIhq2CCRTHouX5iIZz4hoQHDWmHbAhM5Vh5rPPZfqmSfRomJg0ln7y2Xo49G88HpNX/F7deKGFs8249bf4t8wX9TTKcQ0Fidqg30QfAT1MqxBxfYxqxRJyyQM6YGwNR/ZlqM90Z2OMqLY8U2TyyeIS2JC28qvVx9hAqSJQ4lPfvBLm6rlI1ujMCeTsMH2IpJ4TnkCg9D60tHcpYN2zOwsdy+joGzp5k46BNSdw/WyFIO/5d6FewavqiliYtnOt/BH5qPFFq85RiqxGp0ht4elWLzEvLeqCR9c+PnGBwz237mqDa0gMr+zVdvyalmVsOky1t9r02eYpnWwBDo3ChKWXSg5ypevOHMEZA0Vx6onDf+qOhKzu9GONHfMZZhdzNKxfmq1JHNohcOOtLKosTiWjGDSiKSwlS6EnS0XovcFuLoTuZ1CZKoMtGMAm4OL2vjvyr3e3X8wRYhfaz9+gwICMLu5KuTCY/Kwz03vxYKiFL5wWvRkwfXjQ2WClBwkr+FHcpt8RlBBI2DYLY6sgop5g+yd6hwe5HE8+39Hn+LKzOrOq6uHw/4WsRakQhisBhl2TxUj/N8XzHM5R6SHJjcxn+QzGt8/ekDQxwAMaVKwemrlfmNjP0eLtdOm3+hxuCZPxzMRntds/z4rJTseZP82VuzU+W3t1nsyA1iRN8tJcYG3BQTRH07SD0cBMgfi7FzdfoVLPCDvYiV+tOyQBI4f3Ix5c3yo8eQi2PDLrbBoWzSewWBZtS1OI1HyT577PF/LLKL3VK96CyJDX1qxkrQj1RqE+fNhJXfr2KWeAgCDUjqVyddnydfLxnlFCtoAzj7WVjTYE3UFuuu8RI2N51fmvMColwU=
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