Plg1Y0DdQ8QEd056iHdamSR5TWFI8FRg3Nhw+bhyYxPb/KAEcLbL95uNDPDc8ANPpCrIx8v+OK218kbMYQ4annN+R3erjVO7HZ8EGAPzRJfF0q4SRegvN2MEqmlJBCYtZ7imNDHE7lcyiRX/2Rp6SCQdqwS1n2D1Drrvfm+PuFthhuUo2mY8qbh4LieE+GAa7YCvstyYJsiq7Oj6mw9F5VKaSXJ+4TszUIV97T15zB1kHq8MdYvMf8CiEhKmTgrSXrsajwAg9hL26EOsTSY9YyenmcFlokM1UBt0BbRQjov+tYka8gcdzAH8kY+Vjw+80pe4lFrvbuNe5+c1U7WnZujJAQ91he3SojAP1vVF2xy0CBOjoh2Vu5h4mXCKH6JjJbKQwZgbvtUH9n7eOY95SpCzhBaOwOgOXtN2Fr8ImKKJTEhG7B4s+AqID1V+sR+7SiNhFz+7r+nEJ5vdcJ+ZJMYLSJQH8EVr1wp9odYfycUgNBtHOS5czRovKFOltJbg7nmEY5GDLVhcFn4fYXdc+taEviSECfXabTU4+1Iv2Omo3nt1tStTCwzVg4Et5fSqL4krOIzV68ZxUoqG7ODh/e+xqAfM52e9iH6EuF30DvjkF/PyC3KSfstoWWZ4SNsGj9QqfYY58/tfLhTclXQoqZzMdKsM2y9j/JpRxJdhmV2tj0j2Eh5c2+yR1e1VyhXZnuxqKYdWHkgchkw+DIPREiHiKRR3WwoSm3Xsz5xWCgGxXZFV5cj2PvSMsZGJ2Pk+U3obExy1R5q5AM6ddGQyDYhqOLF2gwuxWr+qU2qZnK+hKf51gL9TBRd8MQDAkF/4bSuD/drBgIl6/t/8bdnxKrqBUYM3Ph4ExdoEZDJGvC5uh4jFYwR6uhAturo9QnUW9Hro1Q3fBtZ/hCe+oqC345lAGQySRHq2l8FztNHDO4o/+GLWz5SUmNP2L4mZCUduz588DSaSTEhHvwBlYrdmtajMFT8oXj/ZaGbPryH7npucn95GdQJMm60GFkbdydMwxyMPfx9kkKRGrkdgP+nbfDbEnZYBm4p3a3LYaDXxFS0VMGUThnc4ux+IShCdHnWNVpEyC4uDT39xUuwZ/1VxnVQgYObOMvsC/oxMcqI2HOjOVcLNmn+DK0tgDM7ZLApN7741Y2zng4g43Ln0icTAWfFQakhXDGT17pWebuGXADys5KjkJDRqLEy/VX620yIyK1Lpjgu6cbof764Ft7nxDz6kGujJ2/Urtazp82yfKOmHJ60e5clsTTZP5hV2dw0ZU3r+rF3rqw8DPPqSdIe40jI72tgmsk9fimBBOJCOhZ4biXz678fSin0hxf7302fCzHiuziAwHXuJOn1NMGG/dbUb47gtXVtRd2to3sg=
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