qlYwPuwhem8yod5ohjp0jQcHbtfNTSHoUYcqHjJ7h92iZbdy1b+tLX8z1Wk0grX3mTHErC3mO5quD93dcoSUYs+ByH+bDOZiPB5IUlNKXCq6w2BefDV9cHP55zQcERi0XXZjkAEn5cF8tW+6PwB258moZu6h1WAOpJiDyIqNjRG2ZFEI+PNMmoETo58FBGn8RDMmpTLNV08JoypnMeuAGhiJ/phWAkl7ePjQfqdlld7kb+uKfipJOg/t08lao9pLUtC600qWUsWN6U5FnYg4vjbaYuV1Ju25bkL5ZwmOprmAcdRcjY1OdpRkyZzkzyOndiQMkipcL8QF0S03uWI9vCVFVdmN4sB/CK+dQ5CIMRDah31IhfqqaoH2362Ycg6t5YlmYoLm5QsHr5hRd0YlxYQ56v0PbSQEa1WNcLDOyg3RZiXBl14aQuBZPkhPSkOuhT7XOcocI5V6G8Tsf1F9kjTvpUprntPifcq0EgJG9aIDUdceVxgBs3MF93BVcJCap+etg2ou1tWOd3M0MfXBNnDsH+14CvRGes/iHRnLO+547LhsT82JutrPKy2Hi/KqFJ4WFENUvdqtI3zbiNz9BkX1n9v+5Am/Wv9m3DNi0I0E+HQCq6UQroaayeC1SvJdwIjBsAU+UCSNOz96xRq4T7jw/VDi74HYM05bDYBktKYXmNSqe9a054gSQYFp1JinDGrl2Vao4gCVsc+RZlMpDSttoew/vWERFhAZazEpGFEN8aKNo71/Kfo09z4ucQx5bIVbVZwgsHiEbyGeCGuv8PmFKryZTztNofTyXwCZsWjjpqb62ra259nIUPxYXYETX6oY9ykrPIAMyB93vqv5HDDcykUnihLc/FVKBJH7JX/mhxVgue5ff07epn8kA7lzXCs1frFEuY27dgxHB2gU/R09KZwsqd4K6mXn5KG7YeS0UNDhoZn3FKL5N5s6+z0w+avWWItM/5vYjQHubWhHlolxAyREuQv+uyn8Xm1Fufi1b4/uLeiJpPX1VLbLNN1KhtJKdcqzAu3724+IRMeOAgNmM8vJgFLLvw97zfY7QgoXua/nRoUgd5PXfoeZEUnYswj16rUUsIByzWh+btr0p/YSPHFCBK5RWaG9QlKd48AYCc/jRjQBWYtQR1quDYGblRkN8MqeEnE7DuytdCVfHfFlxKlnJBsBdNpTyZTMeH6/hHbirpxE8b2FZVYhi5Gq+BY6ImN9azntOUPIBBHSUk4CScjIHX3tIWeLKLIiXTuix5+t77ixrxuNo8LKrYuajWctMtEdjlUMOmHvojBLy9wuLaxKLyg3yVjSQSLTvvLO9hB29Ug4X9fUuUr3sXo58VnrE+V+8KoKnF90/kiuSh6tCRMQTx4XadeMDCk=
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