4dLWlt7Ubp4udT+ax8U89DgHN6bx8HuiFcOFDW0K5IFgcJlSO1//6HzFG++t93sSV5QYLCT1BVP0O33xJ/39FVFlZ4pwR3jPsv9x3+Xk9oEytsRXO9Bp4nBSEqvffcglpq8M7OC9VGTAfaw08eKjdwoMJ7+oSkmc/oU93+SGwdiKdUQg5dI/Ofu9Oi5AnDuYf9XlZoW1w61sQnXEMPaXhFbpFm5u5u5PnS/V9GIfeQSH+PbLGI4RdH6a+pvKEMYpdKZgM6mY/dPUrjlgZKDB6vSA5xqmOcmXMSOho7DkN3z5DZaQYWbXbIYr1SPGi9TFRFLW2GfzhgUcX2LPqeQ5ZyQwBwufSvMPKeaLQn1u4+7i8NaE5vnpXyzeD7hKiTVFCNoAMHR2PB3tpC/deQBpw8lL1RTU740SQN/KaFa7AqhsRjCTlPxR0p1+fgRprKTQlydP2lFLxci9c1PJ6Aoi5u+xZ8Q+GzPUjm97X8QqEQF076nNWlHU5tJ+mFuy2A3qcn+yb/p4C8bdvVujmO5J/MHzKz3qKZtRitKgB/jv0xUXY55u2SSascGSqkIMrQhOatt3oVMs1CptcTCNBeYW/Aiu2Nm3LJB/s7d4XpJO89dYfnO7EmTy4CnAKHemHaEH0AtUmMWR+w+I6tC6EUNk7mQcv55AEnB+eC7NkZ/307rPeJ/S9g6M+hC+RqIqr7SvB7xHpVEvxTtfffybMqeyQr9Vx0EXmdCYK974hjpzMBYfsuX/yjisz9TkwovbK5Twm2/WyjTVpITBfFLU8ZGwjLs0Zn3G0fIca3tUugSLuVqFTgQUAAErzkl1lBJ6JuhPPMgprYnM5ZpGHlZCO1C1kbmnlzO76XLd7OdUtHu62914g8L14U08aGrZCIi6V9COBiD5o4s0Uny6jpjHrs5Li/LbGgFijsSTFxQTGZPx9CMc7Z7hRqzrRDlUu9aHxCzhc0Zmf2EXFxGhniyxm+q6kmHn63IN9pjFddajAu2JWogGTI8RYJGnSbFvS5eRX+27sNEZRaxkUlmFg8c9hAV6SD0Hemh4/OKBOSfuB2VnHISR/iCkI/KHqfoyKesRwpZog1DnEVFgEHPqWcBXsMjDP5wcKkeh1jSbfUfu6MPriTwWw3hFNswV4U2yhe0APM2vj2TrmsKlFKHZVpX8TO/3PfZtX305XyMdmAzedStYj/jQbV+KaK11/uFibSq+QuFWPqQrlK8W9GmLdXJ3iVWhbi+Q/cE7INLaj8MDQNzaJKqBlwdcG4oL+6Y2eZwx2mmmLQhA3GtM8iWvJdwPQy1hpuY6ejyt2C6RT62IsnGly9Wx4cD3cviqmm/7PztutxYlfOVy1oH946N7mcBqa9QvvMojTFATTAtq4ojhnimEBqyGm4jC0DlKEu6QRr7UNRq5tjHU0A41YKnyt3h69TsPcAxUdFQEIKxLs6TRolMCQYkO2y3OreEgmKIHm1ID7UJVcJ08o0W7r8E8AdioYNsHr9BXr0bmcJy9d/FE09nIsND/y03jgsadC73hkSG4nnDf4KV3UJElqWc2Y852oLrLMl+Jp/FzAnfGkGpwnahjDXOMDomV3sX6UhRAAiyV7znCX7+jUAwBJU9BcxPugqTe5faSrCWkXZpOzxD/bqCDln6DaY2F/NBc1Qcs/fj/hIiQTaNuPyH1GoMBQsCPaHjbq2K2kti0FYVmA/pVOwY2oxsNZaPkc5sIsQUn5go=
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100