1Abtk3Ntv7oEG5Neo1IgwLaMzHbIicfnHPfoX+pMa76LjoaCsR/d0Ojh6oFoMVMJVrKLJ9LuizYmbPrTMrc8b0SYzILD0TOZuBq4m11k+hgBMQx3ThtpYi9eL+IULkdx9Cyys5GwpFIsjLI7Fgf+8jTTmd0cd4cKjAhmrVLbFYhJCPmq/xLLDxnOXkiFcI8+EfFLkIA4K08x4sEl/3tPxsiqfX9iaS39abgveUnnG8kAfHsfxiE15Iq0zWHDgeP85jDyGoIJ9bhFWfbizDQ+pqmOLOzErenpE0p8e4ZskLMkYxdG9Rt1HFHksOdKc8EDmGyiAHVCKCRBn/vyoRqAKiyth/KAUwCLe571t5MQA1xvc6MdrXt1UfvhEak/dVAMmZxCqrzRxxU7AeLqsSorwQiGYG57guHSZdDL+GbjA1UeJx1TKOzEG9N1rjBSI/fgzQUOc4LXWky73/AVDZbmKlsDUlmpRhb8/wmC2YDoC7nq41V1qd6xFdP9KVgLW7E9UC0Srw8DnnAyo5cqvRtPWMxKZ4MpMx1vVdtwvlFm9JbTEOxFG9XJpoSGtn5ePPr2VKEuqFdppQjlFo8wb6wmzSFHQC6p7NFUKO5Znnt5YJmok/oSJxkQunjNX2bOWIqzLFeeEAJYeXDJ7xfcA37dyiM92FDs92giTldypIJTTeYYdJ+X/Lly5wmxYl6VLuCL8szvnBsYHYVYc8AbYTj8s2ZiprZZJEH4CS9aCVxmW9Ya0VZ6jame/38X+bC6DZQonh4Ryks7uc2L8rpko+VjHeAAG8gvXJNe3T3zA3/JkaQWe+c15Qaw9v8R3Z8sUwr1XX6akG4Uu609xwst3zZXw4VIi2ubex+zQ33eM9qGWl+jqtyKzzdR+UjxH9paL1Aodh12tJJpI0Fu6HtgpmyGRlgrpy6CBKMAIeb8yUEHz5sg176FLIj1omX9Cepoi3s8RLKJAeOl7iKJN5/rfIkHNS1xKGW/p+w0P+hYC6TcZsMMeTK34m5bJvVumjS36Pl3vXPAK1EDGCYrpL1m9FTszo3MVzM3jWJTfFzF2wvtxsz6g3woaLpYIBwqlSq5P5StB2eMZvHmdbQzr4LxMUyGMAUkkF1tPtW2g68XcKyTv6252lTD5yB5bO86CruOUktr0WRu+uuBYl+zoJTvElJ84xKa7p5I7mxMYEaK7cE9z7slm82xkxCnAT5kobFeC7ML7MUkLTAq8/VoTJgCxn12EXPxwPihs0fK5KG+b9ydpT1EUi7NrrzbX5Ikt4eggkjs9pPmHO4gzDWWco7wsRneQ1JNXwHAFjck9XOM/Bwe5vuyJEuZm1RoycIRGTinelIB0glRRj89llzftfOASyZgEv8/kFehd5uxdKe7hec=
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