EU6C+xU5YYt35tAK+D/j6P1JMTj2Vw4UKOuZ5wqCuqT3y41pyBo9rblk5u2S42crcQ6T85lx8o5La/eXFz1ssxq56kwSA5DOWdtk7q3y90zasi+Ir8q5ryTpWBmiAGGlCV68OsxngRdwDIVPWv1tEjRoFeMBFI7XnYDlk9Qe8T0AbUt7idbtKDClmqvpxVoLAmiqNg0YNiJpVN5/83fChLPq1DqpbYbNJgWKEZJWv30ndYnUprJc4vDp3puaCmhkNlzv6iQayuXs1HUXzZyaAHTv34pnp4MswqcMNkM/gFTzHMKl3LunYmut3v0SljJR2mefc9yoFg38OFiXP98Yc/i1y+SGwbSE29xItIX+si29NG008RmLjl21XfFuh7fakaCho7q5wwR1EHuJJLfvMsQgb9Gr3/DeGprtM8xYHopMkIaGiMRE3vnKvTlLU7GNRZcnL2pFlQj0xFFBFlb47txTrl3bTTXnGVt0GReKlLxaVQ1hUEfMhXVQP9c2AbscsldWJlELbv1BM0v7i3iB9Hhr1WQKvn8RJ61AcmCMp1kxR97TiYBl86ayaQcof0YpgyrhZb8LQOyAlh+3kT0b6TOLPspUzOUzh4Lp4YZvB1e/Ujn+qSkMYQYv1wCjFyVsEMUUzNK9u64+zZGppa6nuk1p1YDQSBqhNHgwUzCROCQafXN16CyUZXeucuV4kQJ5qmGeSJIVfRAABdPGdywfgzhrS2YGVo93NXve6Xh/srlfaiirV6XW+YNw+oqujAiBoZIceZVIcP7iwguHs6sjWNANJzcx3i6To6eIQteIFcikEaIUDrLoASJI6z+MEYJjjIlbuVvj6fAr/VVbSgCkx2dC4ZU8Q+bHSGs4Keb5RsqMHLq1lF8wnlMVGLirC+f0cmVYZ42g1nX2n7vCLAooYgBs0aOCfmjv2gSuYsjxxHGgo/eKqupWgxKOHk2+ZjJrSv3K1G2cSAVRh+HYwA/8FCcYDcHgyLyZgpP+stuwXSWBNb976TlFwMMOo10Kl6NTR8oCGL/rHASXp2NYIRB3ct6hQfHmcJ7SM4Sp/g11uayX0yLlpkJCEVFehjHpqXkkaulIPPFaQL16AJ1LuKExapIVz0HaJBjcyitYBfFI+qtprAObeKQDYoGtBbqcHc3VPPoo+Zvu7hlPLC2pBlZrBT8WK51XVKOXqnkz6cXko6JtPF4zcWhwwdI/HgrcYfmkUqcjvvMtcfxuAPbo6KGJQb7xWO3bNsoEYyZQCEDoV5E36ssVWKIDbJEIdY77EmdP7AVVrrBoGOS+GVb3NJkrrRVEMDgBGOWCuB5zJsijpplqun3HlvM5mqOsRYhpe+dNs8TBEbqRBdxjy7OTpd9bt+RCECIBRlh3shDMAH4=
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