Ffi07I+oEBcvtHfhpiUaFsfq7uoChMSkrSAtqfp3dtANbPAqhG1cNHNcT7Cy20cwDXWnf6wqHdIzYqNNCU8jANZeExgo5zH1H0gZz1GWKqKtp6UAW0+RFRRBll2BsnYXhAASSj/UTgQdHMcQTRgqw6wQk67yA0EzelgyZOFUESVgoKj04KM4FpD9wPW/BP8lrzBXrBlrSanbMj0l/ZFXmCMH5w+EPHZvuCO1OdPbpL5EAkUCp6nwjz5twnYH1NYaP0U5GzntI7XiIrii6CqNDNVfnWzLnPDtMd0oDXNa8EwZf6bzReuPmY4Bw2MraNDNuAO13//4MOcKGYCW68vThQMG6BOSYlxpqbtL4b2HYWyXk+RBSBQhG1lREJ8X+fOZeSN1CaD4CETpQuu2TojH66flZKVmw6u7xsQHul3z+gqkt6LQyZc77MzUD3m3DpLdGFOZY+5M+ETe3spL8i6lInDSBSIP73q9EL8HJOpnnm6ng9rsutPH6ZZGm15hsOj/aKmr+1B1ja+mHECwwGXGmnTMJVa+NMbnYzly9RRAtCEE6Hn/uFmd8ukhm3g2/bhrS9cPKki7NsY2h59jDRu4zr+R9W72u/yl2jN5zKOqVF/oV8d1bhwOQZ0a/1Ng/VLN2NkgwSBXxQzuwh1sUN7/NgY/kaYnRzjnzvp0DLPfF80f5jKxcWh3nJ9E+w211Y1helFmxkZ8K/SIs3nscyKXJmbn3i4SEIVpBu3rcacEr9A83+Ay3TvwXyDMwk4k80leRTHOdhx7psxY5zzh16ftLUlCwxn8k19os8sY3NSmg4SVDIGOmTAqPGdiHY32xaHkucwTQzKSFPiotcdsxklMTR2cXMiea6xWDyqaqP8G5jtVC/uhLg0atk4uowlSUgmMmD3GcLmqz3P8s2vuDE4YYH7T+YQGflJicajMxJu2+44pS1Lt3PDArVxJTYlVmfcCK7qL1r3qFCkSXnzTTMeBD2ICTmQYQ0IDfFuI70GyYh6O43jVKrVyJP1x6ccr47CXaxIMMFb4LnI4r5/77yFj69W+Fg2PxIEWExNscBG3JRC6e5Zba0mU9BQYTxtQv/BvbkmstbKz8ln+QxN3iv9vDmYOoBO7vldQPYiVaD/p+uSXpsnnVpDrkjSR5a9ztf+mhjrut5HogTb6CnfMHgAFpR0xy+4Nuyb8NBOzd4sF9H7UIW4PqJ5fIoxmYN9wSk2HhgQvqFsjayEZ/MGA01624j51UL2i358UcnAsJB7Zg7K1xXjOIRZKYJxD4P5FoZUTiAi4ZKcjfNyQXiU6EwarDE70HzuPdRWbAwJGyNrKU17aEgAOVQuhA/oEYTxIW6kqTQ7XSoyk7bHNtMoGLyPAvnJI+Ncu4gOOetBaHEk=
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