+YirxAIn+j5KqcB66goZLDSzxtY4CfDx9h+wAmux1daS6ukhSV5otMY3Wx6cBW+EeAAGMKOvQQA1MpW1lyBVAJyflqQStWB6JqBw2DZ3dbX6oqel+SGMxoDqqcXBlBUvJsGYilo7OkF4OOpGorvZtJ5k4BztgaUi618rp0RmGqjjE0y/YGR/Dpj/tBw0LGUGSi/HmyH7YjCGV/bv9ohlzhSYgp7gBNT/soJt4nSr23Wx0qJI5JS2LYvSKdbJIXL7sBzeXm6tX/9h3ZvBr2EUU2cOzQTTq6F1O0rwe2Anes/cfpADIpt4A9QK8Qi7GoOMCLrUB5ygpHFqVaPEVzkbni+s+2ZTgo2R+ldYZ37kt7auDupO6zRyzRRx7TE+e8zdKR/67G2WcbAfzP9H+Wb/c9sNwYKI5/V1HjEcaLTAJoec6sezUl0tb6TlwCj6QmFsigzscDAywHGoNSquItADjtB+sAvYfxosCyy2D/8o6HSkGyrr900/H/TH5lHenS+TemA+OPtBHTjoD/6zWMffA2c+l33qjZ7ntbSglSL0mt27YNi89GiLSVEqg5IWdhMpghQaYFpQlKXm7pW9MEy06R0OxwjYyn7rGNgUULFMHeUKga0JvqhgK+d9kTjmXx2Au7W3jLNXwJiP5PG5+g/iaiJXymobahC808QIr+uEbvavvIHDUd179ZBXelwK2wPDAGhd2CXxcxCq5VjJs7w9yocY3TPvtGmmSDqrWkAwzOMRCHn8MseIV2Y8/AHmurLD3IpVj6lM3QWcl1KS2SSPtA/4Bne5qe+zBV52y8QZEB0qrbI6Uq6++ILLrX881ibw/IYmxEZZLbEgBrOPdDCAIh53jrrHfeEviwdmhFQo8CpS5oCKUT6zc8Q7BunCmKH0KRPIZbv9atZTu9gaxUj6VfteJSrPZEnlMTjq+baww0lH1HyBGQnoU7264y3RSWHs00yOWFROKinNiLPu4RNi4xAYAer1MopvH/RDKqFJcF9/FgFNiKwtRHwzVb6YRGLkLrRnOIGH8/nr9tZ+7zC2Z7CWs1VZBwEk5Lh1GSIfUv7yxZGpTU8KHIVIybLPe94rAUaqdVj36VAjU/Hwjj7+n1IJVoja6LV8risfK+vRRmbGc2l76uGztygSFzxMctB2B3ZZMC1JWmGQW1YRP6VUdy5mM/g958khhSvAmZB8tkEtnTxVH7Xc7vFjGp0GJfXXu5iHlFQHUyY+KiAjtgd32mYXO7Q5cB7t0qnzwZjup278pBkvNili8fpbVsT3JZEDXSi16uwUeeseqZ9zzpElV4dCwhT1m8QvpOBy54yVjFE8La/Cy4QoKVgxopUPBgzfILIZ4TnEs1QyZRkWwVkJ7VouwSoUI+xulzP78zw=
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