S7Kf5mLGfpTT8J28hZp2IfJH0g3vPFCdG4vch1HBiun0Xr+UvTfStRc5z4vxlOgmTqkJTa8Ae3wkDWflktogxMmKvDjbO9PjKmsWYGGln7LUDV32aUTs8iZNVLqG0vPRS+MDNZ8j0mB3gGEYTYetOsCA2O4EualQicRWQDEomT2wdZaQCInwC5YvMg+PbfIvosbhE+lAzI2BcBTgDrh+V6d0K4527mvs++l08+4DOmAl8qr7KrNMyaD1DuX7MmW1H+q9VvN7OzCOREMiqtrTdnu1G1hN5a9D2/uGMm02SHn7cYRSVtMFSGirhDExxv8wN5q0GV5dkKpQPuDu3tgZdo9WlrhEA2jgBuPmJQnxZ8UszoipmGIZyCGFv8fcBkhVepq/N1WdR07S/aN0f5cdID9SPBCv8Yu7tE0Y06k+R4EHc/uiToc6d0Ze4zlrCNI/NUH48hq3UTefxhY28reZyH+CMtKntOxvKu6fbilleMycKEGX/aGfpR4eHPaxt5IdmcuHDf03ByUfEpyUegBnULXcMZytByLOgPiCzUvREdSv8U95kSkCexwJS82loxoaegJbdnZ9RbPqeAUwPPj72BYPRvOZjYHRBqXRwwm0Us+ZrWBouqbxtsTR5yb7fFLQZybSjJAbPwPviTf7iuuLGWPgoniEA5zqvoKtzzGfLg6R6mxCu+rJBdBp+laZGKRyAFJH+hv1icKA7M5riRMBCd8ra5Q/debt6jQRaGR7Uj22wbg25vD+xf13LMNnzEvkKurcwHPVQ4VMF4qKNsdGP4POrD1BsP8jBjZYRvlviPzLKuwu55NhUKKWoI5GqpIvkAKtRb0gjK+qk6c8nDLjcYOMHkcbO/vjLXXykc5v12ZWU4M65Ml2j2jZ4ou8w8Ob31YfD3HokPYRm90/BEaSV0JqNWGw++fDLbHcvS58K3GKGcwwdfJKL/0rTIDHUlYbZGebKT/mXHajNtmGpXKv5hZMDYDkTpAugKe1qKGpPCKRzs4PaRVDphTnwxfy5V6nGetyKZCBznsdx8ZQr6cXdtONsLPthqWb4m1307pM9UtTrKn6rN2Z3dXxF/Ulxh0Vhs1PbtjQHs8/JksIXqJrFDZBIHQzhNUOoaxMA0nio0OxWhFC8XUBUOEHGOCVLpLsnwYgmwvS+emSrobE+ZUc+Q22zhpbOcxBiad8cthzb951AMm0KoHcrLzqwXPCwMEwZVXcVF7/euBS0wWxMcQul7qdCmOWBNRo73DQ7/0VRAHXZdfDAcewOWwc0dcKJUYY0NWyzr3nYfFRzQdur6dpvrqZVMNzRIJrjXezAgbovelyadd4o9dDkM1zqCD55FIMj3aACZLdIm1wkvmhkxCLPNjnH/kjRvO2BCvIvg8=
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