UogTqIi/ZSv20hZ16hayt6P7vZEb3A8sA6tIlLB/ErMBVDLMiNHpWUiR0RJnMK8qf2kPLy2Gwdun4uIwKAeveeTF8vqReJu8W/XdJRANw39y2p1tPR9dDYknDeSOnu8DJifbvoKur3PWy9o6U6OKITM3wgD6DbFukHcyPqwpyftJbaRqn2RQWl2e3gIgVQM5Sz9JjtEFHLS8KgJIrDAtTbxK7Hy+/QCVWpV2HG9Paz2WnkkTtUB1qHRbEKpNCzfpfnnOhI0X7M2mFbcYgd2Re4OCtrV1OO8EXvoT/txgawxUuGk00pBO2IA3hqqZ8wjbpyA5Omo0z5j3Q8xDpE5CbiuB0i8fwX20yY8iHRPhk6GMmQT5+3xutff5UVIPGPwSBpIMffzKb2SKWmqNUHtp6fllqf250jFYNWhrGZ+0zuUzlhks8L5g9RKTXaHUKeTGSILphF/kdvG1lNBoU+uCouk3NOlS5/RQySYvPq9SG8UbTAsTSU3v2WXFWMbb4nbCu0zS9P+wxis3+er62ouY0V8uoPQwhsQkvdbLw/qWG4s2M+BDGip/KDbH2godhTCUw+5JEG2clawejpT4uhu4iAs/2aASS6SVdYa4r5mmK8k38H7vY350g7e0Yceelxhkm1VqcmoQsrv3XJs6APWUdAFYU3ldYBXZuQfjAvx9wYrDO3l4jDI3oxF8nWEuRefCZ7zyVtXjZSWRtc7GC3fSAxpU2o7W40z4vKxgggdAnxeR0IG4UCQYZ0Mrz1Ewh3BDn8EhbF6WkajHZVCrLujbzJOS4dgWDpOBawocCT5Yep5IsIuSfIbi/OhhU0VtWFpz2Hnn4EPCwV3V+CMTmnVEqndnLGbE7xopO9mXdAsP0fJ3vS+1j/2qyevTcl/U+7Baw15+vWaun7kheaH7ZGOS/qBNrgV0QmGhep2ZwWBD/lzpCv4GqRT0Txe/kVvwryP6FreTWgf0TWqwCdNluS4nXqodm68AlJAh31MijP0OE68bcbPPCC+FS5UEOHSc2z/RcsJRn1WSAlpb5DyOfKRtqLG6GESkm+R8Rc50gmL+xqT2cG7Z2bAWfXNUXRi0ABU8nbWjWu5YURKDca92+bB7PuY+hhm+t0GmFtJxoYG2NcLlgGs4I/ULwJDoQstRK1hJGQcdc9ZOhTXAHfR6eVVXmNT9c17K0M1PGf1worXoxYYq/N+tDBNsO02djJkVQtyO5RAvS+IOoAflre4WVtEvRY3V9Ih1kqU+VjeF2YFFls6BZNXPW4n/SYxxz/sb72fE9KwkRUoPQbb8xTboBK58fHNDxsIv/xec+bcHGgjnVY5lhl0I5DZ0uWIUzB0fPxrzo2E2Z83BhCSExeo4sYpExerGvGrgfOvNUVuXSWI=
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