MGHXS4/15kdVRBW1l4CKNGT4bsMbcAFdKLeuFLgmFiIPqDMBtSbPDmutwmIyQ12hHDn5GPWXUbx6KlGkmKy6jpXVLUbeSkNI/PFFnDMAXal/PJ3TL/NzwJZ2V4SlxkXOTuMVtTKyCSpOkyXDxKj2ZffiHh0szlYxGVolPjVRJH4YmV0dWXX4jaVjgzClJImA6qglXxGrd/ONBZT6gg5MokQd3ERaHNJA7yUmwxjDZXnW0YEFShe3QIMuOsGkdE8uFC+AihV5KQtOaEzs+ErTAVIPZjtGT4SWLCi7cCJwUXfrh3Sba/QMgM7aHnLeGylygtUvpc1QlSnDh5skQ3+5tZ1s71WAQqSfeqPvqMkiAQvaP6D22qBxlfSA0BJXBsf+evpTCpFT1rHiMyxKgce9WImMV3EDYlxSnqTPVy+9OJ1vRwUlTjpdEiWUf5lOJjNU9UGEfJp9SFPmEvfs91KUb26CNkynCMX6MpfPvN9Wg1oXcY+pnYh7sMA0asF+j60RScLTmU1jLZiaa+BdaziWKaMZzSWboFoc0piHiDBehKYoVu7aCWUkDfPPgOOtUqG2dFV/XOk8EvQx3JQZvhD+lS7DazsdkGoXxz3D0kiFjwIc7yMBREt8PvlKcXvy2ep51wi1y92IU3CwGJk67V/8CxdglxTbJ6RNDF9lE4NNCdompyGBFl2M7v/vexSLk+do68qVP5+se0BVqJEcXseeMDoCYCBF2jNiWukVqBFFmtDeCpnpDoQpwMaL7qm/5fbGc0zKLK1KDIujFsZsCm52Zg9S5nHTrMbOvRECvAn4xXUNb6Qj/xPClnB5vCvG+9BJVFFLb82da/V5/O22yMvBHEu98Rwxr6rUqNp8vL5rNd2yml61HCXVOxuyVy/ThtHRDeEWiEWH5MdUlCUdTkHLT0sdfKjmA91Z1IHZTN6/u4LpEwcK5Y2fElGTuEt32+L9FL30FcthNbNEiefcKlyrEgWyYSN92fqdMv6OhJ2spSgUVQaKv+hNc1w2qDdPYffNVQD9cOcFu23DmjsT/muW5yR+RLscuQHLMUoKJAEKnk5HKm0pQghav1ra8KB5abH5CFYEbxNiDZJldyvHcBHjF5haqz/I4s9pgQ2PFo8qn8VBxgg4FlsZgRjnCPqdinjeWnKw5yCBsHtNClHrz09plzn9KanvaGKzx9N/Fm87AXoaIscDTIUvNWckYSA3o1h2vbcJeZZPydskm+ooozVIFsYUWRnnZnbx+VFr8g0duBrj/6SW4sdWBCAxIjMuRO6iZTpOonYw7HS+CgNBEUysrDAiCEwElOJRZ1QgpcdMz+lWkbZBe3LQgmsBKdpT/Ja5ZzkkBftX2/9hWFekBlhDUCnze7Nhs/V7dkKIUrQ=
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