61TFeUul0ITIl9TvvNcU0pz+R1UVMEwkrdX/tL3qd3mlZiApX92OCt5j23ldm6mUZnrcfD2mDteaIEf7We4uVXgpnfqqx0gTBxxyUs//YipkLLN34/YyS035ifyDSXeN8uP1qtGTiFaavzVuXFeyV3Zp7IPqEBua8hfmPuoUNjCZd622IJv+dCKmTZOzfnA8HDtHUyuZHfMnh6QDif7VAad0tuKM6gxsSVkz4haTKukT51bEV2rLVpwdKOBlbaTJagCgFf42aMeuZZlTxboCtDjfgnNtEU0a2t5omV+AvKmNTZYX++EsosgBGX9g/D63o9ycipFebDbfvmHLffV2yoqTY6QoUnXm7gcv6UUkioPRf+jKkNTyFejJ2B62L99CeeipBfUWA15ZtNCrAyNBP99Xv+T7xG/i+m8S9OMWAUQJHekQCUG19zWXFc7m05o3E52KJF1C2WaRbJKbI5Cl4WUFZQ7r25GwuqPL2PhENJyQhb3QU/NeXbxW1jN/1/A/41Paa9l/ALAeld0LOzH/p3zoKKsi2RdaEN5F6Po5pvvbAjrDVvrhYJfDwV3SVJzJHl8s6+9c1ZUURlZPhwIRWQiwChlrrbo76q2GghisttrPvYg+JQ2KbFbP3ck5EPZYr88Qm0a4MXAVn2wB64rSnbf3Gkr0DQLSqzxDnLOeWbeMzxk4MFIUfGqrfLTLCgQzDoPjVvw8sF8XR5YKUXU53KfjzSMwSvKBGCb4zpB8VOrzN5bZRSNkbytA6J/QMpZNukGXreyVhj1EdmVZtZUJba2uqYpG82PkDKcRqppxMmeA+XDMVQMnQluIcBRm/2vjcD1OxvVkack2yAhKrRYyY6bdgap6bnFhdanxdIrxnRm125TqRIkjU/QuGsAaFJCLWUqs8lJRd4L9vyZtAjJYY5rj/z/WNIX+uIOf6kdxUoj+XDp4v9Abihdk0+b50tIb4KGmQg0qKXzRg2OeDYcUs93ctsJBfdVgGjlEnRi20s5wZ6Ei46uwmpaPxpwWIdtqVt2KO4BtJSghmHiTHmEMN/J2huFbDCYTl+LWjT/41QJTFIJITcnCnC144nAneh35MmRtFCij147Xi/oNVZGE/9KlFGv9XAaA9zoRpvvhQ5PH6PkJ6cKEBorBU6aNX6lnHAwfcDCsPIKVpqEHD3WV0V1CBBqgoAyxeFiQmOf4VFBGlOrFB0J74V9EGzirOI5KE4qps/rEvEzYaasZoic/1iZN2S9J54tTfNWwbJRKHVmum4jFy4U9hsPYm+CZFmOFjqu8h8unaF9moZPDz4DXPjESccon9jt3NnIhM8v0FKQAzzcYcuEyw5LvAOLtxHyHXOJVtpH0TeNAZ9Ff77mkjAuOq4EkBBQRh2wCMgU=
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