mcMH/cDaObFYOTKd0aWgqZLEWoUxMWkCatIXgqMhmN20cuiXjc0fhtZfcgqVXz/yGxUAIgM/Cpm6Glfoa0mNMIKLG3xF/IW17/mz+AXjQXFEdIguEqj+gZw2KXfFP+fCecZ0XI4aKT9/pH/RKrm191B3LWccQoZOi73vlPTaaylA/kLqFLo9MXLwq/XcX4Bm9Lph4NTE4leeaw7zGvJl8Cr7qx1q9le8lnvYLiqSPQb4O4ec/6seLalSTEHWKdzf8WYVsiGwR5Dg8G6z95qzDm2i76OCupN7+qZl+cS7u3Pmn8iyh/UgS3SuWDcKUAfAKiQwafhqLq7vFjhPkhZhfuc9rz7AueqNZpf8heF0DV+MCcgFy28XmLYhTV0SaTfeABqtCxQXqqr4ova5Abm8MITjsIlK6MYRPvmjc9aAHHq758QFMkUWm5YWI9nfvpeldULKwUYg2TVdpFFUdnrW+XvxGW9h02qLIZ0eugmzphlFRWLtoK3AOKy0mltgWfP8NBH7yTPKrZ+qW0kJf0xE56dgvwanuh+zgigShr+pet4q0lmqDBgulufdQqJauOBS4n7ryKsPgZhLs26lLQdv4jZmp/djuxD19qbiQwpJVwoHCWUeBH/pg5QtrFfuVbuNL8YNZ4WGyyT5wRw9YJIUZrpUoT4sJkhpfQovH7eAigCQ2KcFCFAvi9+UXqaklef6NX4adsxz7n8I6wXbLbSkJGn4B/vunzlwf364WMkHdNMZhlvNyM1MeUr8YI8NkQcoBgh5XPqqUL2w9EXYqD87QtJUfzcFpT4dOiLIo1MwwEdp71//nyFcLiEK0kE74BTnKUPnzi+fPZ58NoaLUDm76UxJAlu332/zlSVJvbPaYwnBMIIKZDi8yfmWlUwjhNX1mpEiDCU/fuYiTd3ldJzFi/YIylBpmpMf4FIe+LVk1yn7FZ2o1QZo8Ib9KN5E3QCmF2lpIYYZm6lsscEZU/ycyTq1upEo25d1wwFtIi9FwpsYt2KQTV1n3e6TS7oc732LMId4Ai+eUrLIszl1Wn3zXnnGg8QWhnb1lYb3DKtqoYci6YxOvq/Mi5XjXIpLN9pjlNCFpTH4V6YkZVFdgzMYE1DtDL1Ja3yuBBpFh9/n8XQJQP133GMiE0iymz1EqPapcLgN9Le0Fp2xYvsmocMq3Q0nStv2qKi181vMx2r7p0o3wclRmRCerRVTbbYBGKVX6hdf6fvveuWvyh70RZN7qO1w1dzE9Sw6KXEWAsrSTBjVk2OSeCffLcjyvbrLBcljftwrnAM0OM9usEGYae9ysng5GTjzcDrKeajJFxQESQXsE9GG/DM6di8706wr+Jaz8GCtbzm7PYHfDte5/efry1s0wuSs2oo7xj1WCYM=
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