wQEQ9wtrt7EFAWv+B4APOFIQejlVPFxRJ13h25FQP+Qhhym/WiWACVPXelQ7BZcGBadUL6hoO50LDCtv0JXYqeL9+wssZkQnw6k79DFAzGf5UQNeL+QMGEQSFEJ7eby9GsnFUnl0gWcEFQ9SRCH/JbAOxDYn7k8Zs3Q98wm0n/mm5Li+Vmhf8b34ooxjt2d7jI6Z2sVFVO5Kb+gXRL1xIR5nar5xnpzVIM3CV5zaInYP/z14Tr5ekGkWvn1O3jZI5W+Qz90sjCzBKO5lWFCZ8GkAbyr75EDhzQ9Yom+aaO9SGbBR6/m45tm+1x2qFYUSXPgb+ZNbzEQwdHR4drw6J4vRLVnufssp8d0dJnLOjymPqi7ZR3ciU/UOreGW4NjyYBkpmbF1zdfqP3MxYpoNnZKD940ikPo83bePhuHmjjaLR9ZCZzZ7VDKj3ho3Xgt/B/odhh3RbntpEL9R73fPUWzFzgteKCQS3dAGB1amqF7vVdhJ+jszx6PsYsTEzWu0rQs+A6lNP2nzt+Aj8XNO+FOl6gVn1eRcb7Y9/76UjMlIXmxTj6lJIlocKnQ338kB9ZU9+6m4bcaazxygkakVU/GoFEA1apiemMxUjKnl3lxAtCAEZE3mxp4UGEjhzDpFUZeMdbh+gjFYCrptZgOXxjFRAdvCEVOJKzucNMI/eC4x5YefJpUHKWhJdeuXNhYbU78djNWymucSIE3ejjrNfIL97oArqQ2kXQza4s4tjIiWdZAGYMcxwdKquJF1VKGt8PIzb9T5jr4k83SZq7U2f0EsspBV5XL3ZGnxnedZy0KY1bFLPRuHhBvgKej0PQkaLuzPaYLoEDWyS5Ibkkrl6cZurQDHWIj5i9ABO/2WKthu4TRginwIAaXUCc9CWDz68fd56L8xcnsEhgA7x7FmuprWEGPyBUV4oLKSweSkgW6O5FSrEWUaVWTOaSI6ih5K6xgM9kqOIOE90r48BQJmGgsQ7mx6va1P6YgEQeS4G06WZIo78qgIKvAEuFL7sS5LK+B1kTUEVyuqOnCTCr/wB9qb1pej45/gDuAU7mgAyAvvVkTYiNglZsRBDrXTl8+mx1u9XYDSbdPunOANnYaFDEKP3+m5JMlDwmekIMrn6W6rRsOPgreACFuFIfqdPVzyqsdemS+xFGipm3eQL0tgF0L/CZMLJMQBDy0GG5GH21wmB4j5fSDbpOv+JZ+3Of3pciJ3JO09gIwMKAylheC209Rgq4HoPvnYVTIZmJJVUVfXe7lXDoaLsZzApnlTCmBqIdGAC6xI46OVUDusGLTqC8uwPXc4n3R5o02sgR68qeyCrrcsKIi4u7HtEb7lHCw3lyBeEL9oUnPKpcmdiuKEoXAyeJ55++BQMvH/OR4=
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