g+QdzXOtLl5fzTgBHIEpZCd8kOPDJIqQXzGoxxJ02RSgAswiVv+BhPiP6vLVGFt30XSeNMLgjO9VAm/p4+tULixdsyFYtwmY4/Z0VcI5LdUkXTJEqK9cZXfxpcmPeIJF3A181RSVKnf47HY7IbfCj7SSjj1To+/nzd5yp8PNbBaQoNZsG772K0OgO2f7TBs7IflcLcbTp19HeTmpM4rRPEqNULTrLxfcxey2GHAhwx8n8AxLHNeD/XphZ3pfYVTYMQyoC+zX77liOzkW0u/RD1chr1xnhw4R/enH5VWljthDpPTjaVBqNDMB69fiPm4PSDrjSEUnhRfDzrTchee8DDzThmbSpuPD5DaAarUEOchbjzCEtCXCwotDS53zDbRumkM1cXrcw4LnU2VtQFGJU6uWBSOd8PEjanw3i7vXEKxszhEWtU+mDqV3sodlyX6w6rxhLU87pK//rCjhg4jCuuLsc44blif0MXJeC0kUuftn/nbSrswumSjMqKjPrtU2VOV0Dh4X48kN5HWFxfvfMgs1cEA9OAXBYRBo02MdMqVCAiJQN91la8QrYIXYO9V34z/kWwwcb22+v3uwXfoPX/rmvWBWvfNI7FddRed+2Rjg1aHDGdjGpay5eDh8/eKytbnEpKfd4o+79R6MrV8R9OrwrbhRYh9i6XRbLUi4MfWgMZ7Mx1s3BTUr/Toxo9KaG0DkYfXrdILO5o7y1O+HTEhq1aw4zs3uzs56KQMxW6LYZ14+qpMG3hF0yAalLQD1czNewJWfk4iWiVtJlSmkgM0p6yJAXoxQqFI3o64hrOodcxJJfeo1zvpwzkEwgEw719TMhNeo8yhl+u0/cGMvsg+XcnUngVGAEIwC42/5KLtsJPbNF+rn1NrPnoWiUZKWcXWCHAtrr3L/qSpVHZ1CEJg2ZxPORbjZngpXZ0Lyfw4BAsvKWABr27uvnQf4xygzXQJmMGOPhmrx9+cCZlvwIteI6zy6c+Z7vo7WVmn6YrqDRyBgn6qZLZo+QJyRrIW89S0ydMhXk9PmRP25ggzJTXF1+kH8m0ndRp7kuDsfHqaCx/jZCzwxRDeYaYVqXcqlCvxtyONJ4FI306BsyGBJ++Sogx9pkdM1wBVpFeC+JTXb83pDWBqB1kXVOVhPSsX8KVrwHk9mi5foxp0mIY5e3h8h7zsFC6LZOM/sjT+gJ8RkvNFHd/yop3EK8dEwZqo/BXnj/zXbOk6Mu/2+gF9qrz0mpuGC2SpZKYj+f4jhPzKBBL839g3F9om3zQQzBDE/iQbCYIFWvFqYfRKIke0x02OdCFLMtGMBQovau4Uvl525jBDuloLl4cbud/RR7tJSB5R1mwby5wLCfLSVhtQ97gygABfApfa3Fzfl5Kc=
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