gXMNk8vcTmqYYueYPr7wx+6xhQDdRtv7pldJkb9MP/04al7pJsPMQ9QAGEl06NolpeqWadMmFnsWf4uV1EqL9u/wJu81guQWbBNsfV015gxWN1KlxQQF0IyDSCQeGY0W8w1FAoNMI0qRpzGmoc+ibXl8k1GYJOTHoJEwidhFSUMN2ctXY5VKyqgJjeY6VZLFKoAmakAtHUeOgvlu9xLbQbSzmNR1Dy8z8NLW+4CWXzH8dSZq9FyGAgfB6LdusYrR9fEKHLqfLnJQ/zbuaQjl0AoJJqy03CBayWS19L2ypf5ryhDgj8Bn6vsw4YUKCGDXCuKA1Ec/yt0Sng/HPQJQzqQ0BsRvqyVKqD9Wc9xVNI5mO+6yy7TZOCzdiBeKTUdrgSyEzxOp444tVYV5yZ2yJOfOPcOZHrQqJhsCxjQqIzGuoLsa0UTy3WzWAbERJYOwefdTIkUmBjrkOeU1jYk6ud+vImO898myDkBVOOSFFfo3yt20lYPTyhYrB5tU1nlwPntVNnvAOb0MlIuNzc8WA5Y1ESjkday7+03phbSRbOaMviNth/ajurQRBYvmYXCLI3/IIgB0gHn8Zbq9QUiHAPydLlmdr80Qmd2JILWTeZZYFQ+P93vtUTKVwzAmBts0BNedg9LzO3C18Wirs7U7p5jWTQtMvfKmep7nv2K9yng2fQ/Zpo0kQkNbT8ME9ysoYTEtr0GdMYGphRTCrqfcPYCvzh5oY1po4DbQGQAPd8b50Lz5y4rj8HHGHr1ajbE68OcHNhxh+3V8TNxyi3WTAHw3Wo/yom6I9qJ3w8y4AFSTvtzGc046ZqWwufyO7p6cuSnsE7rUeONIaOqPR2YfJt4C46V27xKZgspb3vQvvhxXZYaaNIUt11cFLu+ApWh8LSbWX55/HlhqWrN9XsQCfxLGFEpxL+0gVpeYd0Yc3ArhN27BOtc3SpBhfXT9qJU06o5EmZcEA8ImctnNj9HwvtwWtzGmR7xjYSObP0aU4UYXjkZCXJRu3wl3IGvpuWd08Hkm6M7yFo+RJFUgnCkpqLLBaKj1AJTPhyqoazSvR0pGF3SmPcAgMmPEqjm0GCB59TIFZeHadKXJg5SBDHeSOm1USIlywwr8Ea5HfMk7UsCzPGyapOY0ps1KKJ5B4XO+Eh7r3m1xYxdiJ0weLnbFVtZEn+NJAjDzlmXERGNa2hw668GNJgqgFuelz5A6/N88gStUXnLtabWw+c1xKzIMBjwPe0W894328oPQBf2xkQFsPys6vGWVIhv8piejXaXVxUsa47vPTIIJeudyUXbDiuALRbTm6F6RkUEQfNLflE6kgCWmRMR66vmXuvFP0x6DB7ytMSQxfUrgOhOX6H7cb1rk8SWvNBb9v4scEew=
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