DziuD4rlTzPQFGjmrDP7RvWWlUzgMjZBruCTGEy71+Rg5fzSOLgb7tlVhmuevYfIUctR8Rc76/Grb1I7NvlGPRTI8CL7zfGOlLD5o4tzfSHSpA4cdiZe9QbkNeg4YwL6FvP2dU2zkwVFSWpBomMq+VjY5PXsCBN9aY/YZEwRN/zT4MJboDqiQw8T1bF87yURDPXpcNKqA3khDwPDG70blDyCdIv3/KStu7KQvuQj5kJ8qR+nFg+W4XWicf898pvhI0KpTYDflu+Y799PWmmwmY0V5ARJGPrPXHtzMJZqtn0fYuS6lWwq7Y3zrEcph2bKha7UjSo6Yp8jHwbabmvBkKLPKIfy4+4aGyPqWDBYpL4LWJiKQTz8mnoI5Ps/Jr1j9UHWmTKityl6jtxbU7FtN8Xno19kIjrJR0oBjj4ZdI1D/jH+/qd9PQOBslpM1JarplJHbZuRVRcinXF0ugiUC32v6kg0KHJLvdn8pk0nlKgdhCgw2AGkMCk5uZlu1NQi3MQJxqKN/eNl9IVu2vx1QnfBv+Z8H33o+YTXxAp41dOE92/jlSHpyz0hMW+ouLpdpNB5yU4XFeuyDeoF+o14VXC+NkjsLE3T9OWDsBWrShEkpFWqin2Cvxo4TEd5kb+7bvSS3Ya4+LkXexF4Y1/K15I6wOVw9luWeXwL5rRYXBHYRjDZfOF8RISNxoPOJApbcuxwcoYB6DLEPpIbQAHi7lBX7OvuWrVqrPgPlMFlUrgbISwqVqvnQwtSRhm8VsuErSM7xCIxym3Bfbgv1WYk3gbBkTO2kI8p2RPQJJzoqXt+0gpLq13toM0SQbcVCXwAFlZ3R4oaWlQtDpyB3liKQjGeRWclBJL/ysP9UF+XqJnLbGZoW8mmxs70eumTM1EWEOonBFx9TeWmxSqkmJp3gC4mNXIQy8966sWSvrqPGOapHUNpdd7o+5/6UJtNDSgZOb6X+VG/NSnrU9wBn9uhMRjF28ieFlZ2fxiMmpNXtt0UT27sEfeizGV+p8tYhdnOhKYBXMeOedGhxG4fK8L0XPiSujNnm+bvEXuJvmlnztAjh5pG9l7B+owlDxlNkdf1sqKfgoxFXrmipLz330E8AuiOZ4HEf5gZ5K1TfVIYM5Ev/QW1zHQEik/TAzihEA1bIs/WZcPCy/8dIp4mJNVb8vY/qdt/19BtY3v5g+Ix6+9FT6ujNjUyzBgI3Bv4cywen/GvMLkyCNy2iZmQa55KFeeMnDQxf9P2k0K54eMYHZ/XTUVuDO9t9uR1/7qZAL39PrEAsOcZviKpEJGI/2QY9wDp9yPvQ5eoyGUGVvtf6i6yOu9/vqPpZfAxcNQBoVAxNKBK7JkwRYfIy/n2AgpxmQWljzwwj20eM0lcdQQ=
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