+DS9f3fbatobLDvxMpHjSyzyITF+irdZsT/2d1jLkwOd4euo2sYiKlKpbyxbuwY4fYeGyYcC/tvlz4E5PmCvwCACWVMuepaklptunlZWir8rloQ0wVWblM20IAXPaJeDz2dM3xDifIR0e4ecqtQEEBLyNwRZ1OmMnNNd/TH8eoulK/BnuVa+FBzXachuCFBX4QS2qsCvs7Fo8sPUDNRiuYh112k5pKe766PiaFdLN+sCtPR0/CQtS/dUxR4sSEYDvwPjr+Q2SRNr4UazrYE+zfnOUmF0Jx5BWpRJPlkKC1SYhqAwpyJELB1CXAV/6+UhQ7NJgloeTNaYboeHtbAZkaYcvP56Oax4D581BV0zPw9SdyroGZz1L62ScVEE4WFtde7cbU2D3ShMwTrLJnHMh32BirA1a4uryGKiwgAIGI1BHD2TFz74cQE3iblqeV+VQSxDAa6x7vYmfKxyzcv+kDJbV8ql+B0B5Rc5jS144yJ0FDx6bdZwwjQE68AecmTm530GYT7qm3vrw4ldonXbBVdd6BMljctvZ6cZcyCvx/1m/d9ufwk0i5T2akF4CJ+fPCRbWP7pJ46ElzHkacplapy2z7kYQuyGphpZHzd4uXcccmmt/AXvFOQOQcb5S7wfNwo2AGQpt+gsHjTzy9vn6Mn5zNa3OqapcR51hmX8+9CXYZlWO3j5Me9xt8PN9gyV9YhD+5/rAGYgvu5rZFism5A3BUchp84iNZ2znAoJBRdNvKvMgmhwACKiZEkLBt5hVP4EDpRncetgXlirSmFgEyu68K8lDyE0exqCRuv7IDBot5FAGd7U9cTyzES+lrHR0qvlCZyS6Y2TZ4cPAXUJ3y1+BMzK/2VOFXEz5rRgRol/DNgpJmtPtJwZxwurwIvq3cgAokPl4MbXAGwius+cnpKqE55MQZpo98F5P3GZeuEmBzoFvUXoBtAPJjemkTIfupcThHHa7jmmeNE93fvelqU2qNTwoJnx+7rpXj6nEswSdDi8yCoLAHMhcIgDd4f2N4L0xasnB8Ic6S09fsMqc+ioDK2/s7QCHP825xuY1PjAZM0NrkoVc8ocSNnT7vsbxrVbVv4tWuURjcTCB8I8dDyDzmFeLYg5etNR/ycOTdaG81Ag3jw8XCUwOxIRyiz6eWXMI5q1ArJpAaRSJqnROOncJ8SC1ytcmy52QZORGQn/sIhqqXsXBTJmbFy3/NmhtL64tckTwnatFJTrrEXJNDcd2YpPq9X/9ZQ5aG1KIlYX9hPr0qpRVMkVdWCIw3D5sfvnp4PaNLncvUEuAJtTXwWj5HeSsG7NaqpoXZF97di0mHPBT7KomxmDd8HUN0myg6OEnMhgyJM/etoPNqPkt/9Y29cvLwteQgXN85A=
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