wA0/jYAwieHGp8v/IeByvjkE56UirxQA1fCKzwRRPU0irjVVk8h+gdp4LZ+nBHciAQz+jtuIwivXIWJguRnu7gs1OxJmbGMk6Q/Wi8JDTVZ+7FzxByrEnwcMn54qEvSTs3V2Jye/d+F7itpRclnTf0idzorBPk6CdxJUnHpyafMC8xE43MOMUB95u3rW0cpUo++CRpu2us/iKkbAtzdJ4GPWEV6M0mzcByFoNyQQQf7RRJZ2W5aKOk3lK82jSHUtxl7l2gC4E1/qnC2dFjX12/UWZYNZqWzS0wC179lMLR1lKp87bdK5UiBHP6DKNtjwTSE/Gb9Gme+ZXMcfInLBNX4B9h+oBEKnv1uqQCj7fue05jhcpPwUvAvBycRBVfVn0aTMeKOmvwGZDYf4X2Z8AFhdFztwS8kIXsNRK0BspRQ35lyWhj2bA78rgW1kwfJ5n8wKgkmb8MiGDUbwSyReVNMhLvEkMWsx5aO5tHoV2EYOCzqefiivAh+zDdxWNpeys1YQckIE7vcaWtWva7mbHzeFPZCQ+CX2m1PI86nvJ9RSjJbhL5Hj/l4i6pgL74h7cWLDdJF8yu9+cODMK+surFjxH1RNLqRYKiwnGYAwmx0zA9vSLbgFvaMhN1RGptN6jPyi/pc+fm6Q8ZXI7eIiW4BCDB6RAqiqFy4ZWmfAl6HMcH0YlXOZSuPW8l/RwmX2mZRvkZclQb+6XiWn/ht0pOIervnbiePawc8/nnnNYf6p/QUrOnRf9O9zXGaiIATgdsSaclv7fFDr7YRj4LKyI0cw/qybcXn30ZM1FMm5gKcL0mhHGCtJaYCG1+0Y4u+Q1U0eXQPfy0ZV0Peqp7eC6A9DLy8HDZt5LE9TM1rRU1D0Tx2hpQjiwzzADDRwW/TiYmSZz0zF93Is4OVUUmigHIzhIhwT5M0H1u8f7VjQIenXteuAJm2XsZ0sJTkNyJ+J03dmn4L7+Jrd1Iah8Br/rYkWEzd8jsUZ9mgO04Cgtpe66u4OGlPATnU7pYqG3TQvlnRnSuniFmZZTLsyleqJs6McLtGmefMQaI+Gg3K/FxfUQXBSozmAAlERUthXd4grOsZLZuhYRTyalLIc4y/1B1RljdBqBJJUg2O0A+4dq0QALQInL107D5rPfv1ZTb9Y0/NxEkpiTUwBnPVb7ySiZnx0RHABFz72bKUthtWxECXvb0XE0r8rFSb7jywSIDiBzf1OAqn2h9sS5e4mMm70cvgCLdufa3p3q0huUu/Xv09klreeDfOO7ppPMRMz79P0pJRHNP0AFFcJlokht6xUFS/Ewe4SAKTxC/5K95Vr7P56s7F2okg3RYMPwx66vkNd1mr6jCVL78RIaPSVZLhjq49SjqriMAVf1kQAYWM=
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