2sKZ2x2HzrMSiWUORTgBGrxs1waeV3Agh8H0NzU8c/KRaD01/mySlen4G0DVuaTHMAus2PAXuL3YLEMD6mMBsgmETX8k5JX0Kk9YtL8PUIo6H048C+dQpENpcomIlPum/FHq1X5HTWQ/1EP8vm4JwKkVU4q0biVhh/W8CUEqkNLf7iE4EVYpfwdBRe+T00bB6bNSk7KywJ2GhFKh4eqyizQ+t5m2jZu+brxriZZvkdHELWUbZ0OXXeWVJ7+gqyUQtM2KR1v+ejdYakZQzJ3Q36vs0eHL8otkSJ4Z+JmUeImNm8WmG2NtOBgreNL9IEcOHwAkqFrZ0Yp6plo7/KKluSC6BXqTo5xVIzhY0W825XRIPRLk6pDA8osa3WF7hlYJz0B2qb73kPWq4KR+HHiQNPAia/2rUoTeDb4ussPxvflsUqK6+mx3kgKmn2DnhxyJFnKXPH0dQwVqtaVzPJsaqbPF+5qkiy7chidQLixrJHtkW0k2eA4r/wLavhx4Pno831ppmGPAUAvm7mp1tzxk2/B4b5X2FVEacMOzvesHTEw3638lmAT/lAQhKSrGQMPBrRzTWm26rFkJCIitu9MnmGSbLO92SXE2IY9zNjcc6QAQv2iXysdRXKbCOLp+CwZVDnXTWAieLPf0a4IwOMbWIEW8giOEIdXaEeqSy/dtK5q7waRPO9X0QqOJKY6EddIS+CJS+WUJyuBbfPdyXhcYeYtkWOpTa3OpNQBLgyrIPcxTj5vWVUD6P9ALuDSywxWaPl5pjHr0vKHyOpfcOm86K6DZU08Y+2NHge14jYBrPqcLQEx079aWfUIC1iHpMUuiXFcoYBAG3mzK2RAYzOp4fSImcVCqc6G8+vOe5BVv+PfP1IAuQBiT906tISc8iH+5qHyOn79ijNb3WuMvmowv2J+V0CkrnCyANmIZJ2nQcvHQHEYnUD9MUdFLQ4dCbc2Iv4x5vCAoSa9XYg2vYSs4U6/XhB0pYgj+pJ4QPutrar8JbTmRZaP40KX7fcggElpTXGUonjtxq5n2KeVV8xsGCU59/uKG5mfJkeR0koUqn4WtrPeFuCMoJ7FKGCsp/VgK+LPIMOSGgBt3u0vkFLMx3a+a5fnaXbUaPvq9W7qwkbfFcdZyTtrXIZkrWQ+rsBH/r7PwbI+kFk8PHXbaQZR29fNpuc5Dw4pf2QUv3E0aIIlPMGKkxKgf0qHUwVn5RDS8S/PtkSfknNlCMsyLHUFejqJRhgGcnEjtNgBu+Qp5XAsoGlpX+SMXb0hRBx68GBjL4KudXzwypQ689ceQkxr4/bV0dFeWL/TZMYKV0xuPI8p7t6O+MGLJk8CrI2OsvGyRbBM8FY+tXkMtl6B/kuiUOi65Wk0qegnUqGC9UXw=
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