bGa6EeFU+mFmhWn1tMGRRfsyv04Ry2h0Rk8OpH6TesTgzrUdnEeAw30Sf8/9rN8b7/hdC+XmiuqfDhMNq2DL8z/mMRqPIDruTBPzam+pvAcT/LtvR6LyXtdCZqsDH/kI9byVFYcfZ9Q5awkrysvMgtHPmMHi6pjsU6EzKK13pg78vxgNexlqtU7zF5pl2R+fh2zm+pFkM8C0nZZfeL6aLJWpnm+jjKbAgpqZVD6oxIgS/7nonUzootpX4/YbrmKigNex3MtRMj+Jd8Pq8+s496aKMYump5Vqcn8dz7gHfgB6KlC0eyA8YSMVyDWSyMnAWdj0pNDqinwWs+le8LD7+GhheFg5m8DNjAY3u+P8C90FqBM00q41bBu/Hj30U49LUzZaYC3mNo7d1FSSJdmHPvQ2mtsJyFbmaSfRIEZInwTs/jitsvhsBfuUnXpunlZQEwE2bfG/Fx1LrF7snI5AX0HVazhuGGEy+4o7F1Ov2FdKPqxku/bcby+lkDU1cCUMSXmqSuyo89lVVTw1dlFFznAp7gAvQhTukLEvQeS8AcUgF/UT9JKVrb6KLebugPQyzF7YADvFqIXOmB/TPrl0wtWWgI2OXsaotMucldyvkRTHaWXoxvChdAwqKzvb1sRnG56aQ0WpI62AV866EaU+R1uW3KV0Kfegdsa+6l6xdvjtLPyrczXP9cbeO+Hz1mvG35KOMMEeEfOWcmpYHXicfHhOb1f3Xc/qZ7meT0EwN1PiRQpws36YfpFMGo9ChVfYlKdfPqfwGU8YE+l+qOUoc1gDHQUpMMt2XFEA7Y1eRIF1SqBQVNIZGzzen+1+ZB6sAN18IqHDSAxpuMd/v7C4+DTSP5aH9lpKdppIaTLhn7zNnEDR4injy8vEElm/jCLEWPmy3LivESZtY7uaLJGvqpvFitHqvc88e0VJadyU3WgxtG5+jTStG+tBeeJg5uUTl7FEo5pHsYMF4iNw1UsSe9Gax1Q/XNeaSyN+GlplvOeFmxOZ4Uy3qtfdIZK6mSoULQxfxquwmZmjrb7ivkcjqF0lsCuGHVq/9FKGJNhqI908tsnyDOY6B2Pa7+58Vz6P+uzQyFJBOX+sgaHHFawX4nVYjzMsCeDR8BhLcgIEGWrybLll8Q2M1JaTzRiSSGa1cUTgV3c2cA0HSpvCo6hse+vBdtATYgkjrZ+WRF2+IfqYuj8WlcOLHc7SXxs8En4ahYmEw3jpDCR56PoI1g1PqsHaJ3Lb8MdTOSwnbjXviG331VWeqm2c4daFZkHqYJsC2LwrSTtV7Nfe2opWQNJpCEb/UbqSwC4AE8AS3Ym6EhDeVh1KUPCmAdQQ5UlKJjyFFiYk+yvW4Sm3CREiHEvxiFjCSlFY5eP41ratjPU=
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