BCNdSdUgYZleq6fIBzvNPmBZosSvAkV6sC3Q3P5EZUFowQNmuH7KbbP0MVEhSr+Ijtx8RUBnLoZ+a4C8H3nFIK97/e4WvKLRVBpEmjFdmZdsG8cbt/eZKhLNjoG40WICDl2/efJBppgCKGVJGJdcXKI4i9cukXU9sXQrSn5KdRSi597DUJKHW3Q/YJGnVnWOejGaKL9aTeq5D/uh7bL/r4lG6dW006heowD+7YWcxebIWcyTC01xKGm5WklhYvl9jAKSBwLgQL2N57npad5GkW4LEeFI39sK2yqWvexxIceiStD0x+6LYiA5lFuhJqpeK3p0U1pDyWT26kb84t0kMMwXE5x3c6QM4yeMEU6LcK9nF0IwwhTFhY6uufRWUNvQ+rI/ZeTU89+DwVJJR9iOodI3IQ2M2dBeb0Shnox4bE+1//Fm4IeUDtc3walEPRN8dfcJoUaIQeIcEnPJIVZHKo6rUJRdgoe3FdINn/JfUYfk1hM1YDVs8TrZPyE0Gq3iX0H4J9IpZ8DG2OeiByClsasW1phISJEhhxPUAk9AOEGSDoJTcWgXeZRVcPZ+iUf/LRTxrDHiV+TO5sai0MMe6XLhrA2sFHfDNBDopnW3FfYUMJ1CHLZlOmIUKS930P6OtJBMG4HGMlHzKjhBQ/uKEBXXajmnyOA5V2aqX5Dul3t4rSX3kC/2sXNXdzsWnZwNk2PdjlgjMsY7Bm0MIq/5SRlfHCeAy3d1BOQa2OAxwbxFJ1W23rWHCUZjWHTLlfRbHZEyzTbhlRvVFPJQb279k2JDuoZE6yqyxOi+qJsKP7X5s0PNoExpwPr6zaedWj2vmWpK2et01YftbJFwLMso6sGacsAM0GZmaHtDIH2mMCvYwWjyBP581v4G357Hg2/9ClMVSQBmi/p6ym5nYedyvBAAPGqKrSVUiWK1TlSa0V7G3S9ojqUT7e4SRFd/4ru+freTZX2pUGZKejez75YWmPZ4XggOD/4J4Q17XYVVRMZwukyUeyIsAFf1I9oU/HMQyvvbCMcRhC/7MurYCoS/iY65G875X/JRRLtvjuszNQSaCrRZlVWu8+EvKMB0ZOpre3G9DyqmOlbapISzmxZvY8MLD/7wL4/psOKN3aZphyBewvZrjM3XAG3/wpvCfIZoqNvPPNBhqcuKYc5WLhmZUYRNc1R24umVfa5b2pvzie2OQOlWaNL4qwkSSW38Pxgc+hoxlOq+3Dm8k0JbRlQzADaZxLOj4Q26XOQJNGotQqwS0i9HNNOng1gkRG7EI9vzAmIbVo8o0QLT3K8QN5vluv41t7swzEozvagflCE+QefLISEJaDMnzmt/Y97sooo31I46iOtmyNsBLzJ58ME4bIGCKcbunGNQ7hUOjtw=
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