SPWAj9KF0rEKQlUrkoX+AZeMU+3KJ7qyv2RyW/1d9ZCuFaQfIn3ktYoRWHKnLoil0lr3Ymn0gRPW6ODBWLt6CUrWHl8iREkS9bEX9mD46EONp5DGukU8p8zX12G7rwbmKBrJQJ4oznIjCefgnUbD6x4etpfS96/jqP6XpkqyG10AWqoZ/NwqsjfWsrwFxihQP1s6IUqfbpilPAa0UcNsG0V1grRXM0otpXPvNdlbPmyKs0EAWMEqljB6ZxmaheXamoTcRuWJ1tOAMFD3b8k8GbmYjEe/KG1ei2AUlfaAVm+wcyaWJy9J+Ol6pB/anQIXQr0aSn2rQr3Qpn7eDSz6xJeBJTtU3k0CtG0cCCuCJgZAeDHQ3nzSsOJY+LOMRig5GS1eg4Z90Jmp7IMNCsGlhlBRqFm8lnf/TUPGkU++2cHuNNlvwCYIv07RHH53jcYLG5At1PlXLV4XFgYVfgGxOPDHs4mfPOaEy2ydl9YCh7NThx40NSIAEW2fveVjLyUT9Z0w72MaC9nK4VvSIy0udciTYbyDtsW9Yxbxt2KFd05PzitOTEovgqNCq0DLoikLFK9etFbycukiMxW2f0ehtH2wT4O6VmHPMMbtFVYhcn+6PHZF+YOeNNPAjdvKklbIdaXo69BvChZ8K1aMPtfM1KL/AOEWUmYgmVwy04as6Cuf0zH7uDFNaW/wTjf/ryMY46Weewys199x5vrhz8uaAQHxr7qSdT3Gqp2Cqsvph5GnvQ0Y1JKMcNZ37EQYdUWNW1ME15ypVk6LJmsrrBjXZXN7eV7jPTQvRY/KIr5rEjg69o/ZCwL3MG8KaF3kOlFNmxENTWA9BYv6uzEUrA3Hmou0K30e730j9M53NtjXLw9lj+RN2+24OmB6b8oNKs0U8wo/p801DiOh0AUUHQ+Uz3VqhdcHJ0eRO+qpDXxY5nSvyjpRCcbyxkoR+4rLcCofX55xzx9mJ9yms242RV2MF09A0Sd5OeqGCe/HEVRCEX7ejllJjbKL50itmUe94y1vBHsfyOTV28lfjj42CFEB7lZ5AdMpN2/mEwaeA7DfH0ZIMp7wIv1CHDH1wBezCgLtmyrQ8q1/33KHj6JdB0a9Beda2a4Pma3drcL3jmxDaSEhKeS+cwONIWw5AqzOEAp+HOOxAlcQOAZaRNg9eHKnvhjIJgScwNScP2MR1suqj3F2JXdW9wRdXTjQ1dVoTWWSU/PD0eJXGVxPd1HXj0x0VDzpnbOwc96gD2PQI7FkgIVuDzZLnI8D7RjU2be1OxF7tc6sMEwCCA87wiyQEzQ6O0ebYBX1xi5HG7iNuSbSNHogBHAmcp+PRj/Kfc4JMax6SWDwKKgeumJO/fJXjPG9aADETQu3Pim79JlkEoY=
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