47JXl2bM7Yq8gjQE06vl9edc6UlPu7mGBsTRrTI40RIaaRNIIrxf8NG1zkx4fmF5Lq8lgnvgOVPzXQtwmYvruSfOhXDL/7ghhSGU+r132Pd4IwJaD81bboGfkGx0vEOWFXLUMB/uwiSVfNFYuh+5Q+NcN8oHSHl3g3Ennp8IfI6qP9Y4DugsKVC92GXTFuHZLaTELBZA2LZMKwslGnFbHcti+2+uGvjSr4Nj5hm5FexzpOGhbxHx6suwTs0H8bLNOO5vhqIK52U/DBWcD8MbiULVNn1ojG/X7jYsixdWW3wHjb5uOgwYG0/lGcgSBY7gk4LofKkosSu4tr77QqutKkgzhzHHO+IfX2+MkksdBuPsCutXt7g3yMNBYOSjzJUsidZEOsCRJrckeMn3vwgLLpdc+vEiCb7A7hXcQUvsfbr5JC75i1Ab6+UlVfTnKPvQhTqrV/qelEYSsUD5h9F21NOWU1FxCyEPCNsGjRu7AAwQa7/5IvB9J0/x+i7wVeKjOgur02oakRTH6oZvgQTv32o4ExEa7bvzvgxBrFMGeUjiWYb8YTwcr5KedAr6LvOAH1D9i0XgA4MU/FPKGogoXoWxi//b1WaYaAtos8PFW05MKDBoFaEsS8NeJkF8uiY+Sx37w0IB8eekrXdlujz2Yb5PPX+JEqbrxc1hZWPkui0ZjMphQfD2DMEkpk9ppUEMRt0DZtWbQhm+0W9K1hSNl3lsbJWtiyQjZlMhVEzRA78QotKRQq2wlvWzikJ7w/+jW9Hbd6H5pKSmwh2slj9T60S6XHjcl2vRFE87kPly+G6w2mzvDDve0W8xM1GriuZS/OijTqtyY06QheSu/zpG392bABjOAXahUIFnzWNxy1iNsn+SuYWLx1J5xtuhFA3V0ymPq8qPm/2kjuU54zALttxbQiPg7iPdxkN2TKss5THQZIcJFkQTAW6SX4x3hPkIKOP4pqG/nIR10qGGJM9IDZ09tuLexpIyvW3o1CIfUWRvoSri5E/XSWCuz0gApO2UUYRNlKtZJJoHA5pvsxa1me+LiaYpsbRpTF9N+wEBD9rFesyVIgMvA0B+yAYwTGcPOqAhe8NNhb3XGhY+vUB/Da7qTx/aiKj1QhwGL1VJSsXbTiw9ftB9pO4zAPdnz/ECQH8MN8Zw6K8D7QhOqn26Zeta5XBUjUlW2lWVuX/VBrJgADhbhloyLuzCOY5PZJV++BsRM+jrDeyEEle+MjWsm4z0V5jgVrh1LuWd76rtX6uJ7WtlaqPxNSrvchSMgb8aw6Q9frkNWUrTlU+PScGT4WvDyXiAIN96hAlHBs84sM1eCDcVuMysRb7FEvJu7MLq2o6rAM+S5Wtmm8jojNtJYQCo3vSKDGyuymPnJHY=
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