X71z40Xw6DURsNGDWRqI7ZDVn5UDkiyEFsUfwVCQoVJnPjBCngKGAxIth6pX+qEdQacsvnxRr4WYelL5cx9FxxM52XmU9xgjqR8YcEDQ4yur4KZPOjLEtASmPtQd3ZUMnDZ3NoO7GJj2q2ccxbW2aRDIcffX2xjD0K4SnSTVzUJVh/LHJPS5dxCN1Vp/jJ8RE4Qr4csz20rFBh/wIgG721RSLuR4aeL9Hs4WpsAc4e462tAlcD89hZY1EwlRs5niD0oc/7H4nwqGmAzbIT29rdi1hcZwpFSIZqwYsfTU/v36IDW16mYDFCKZhvVf9rSXmlW+uMh76EnMul9Zq1UVAnvM55+jwic1DPaLS+4ZlUaGNqyiD2p69IV0dQx2UHveXkqJTglluZEMBZohWuQw0SqAdC1Y8s5ijPJV3rmYdr/guulMI7VaV9C4ItI25BPaPxg4mE+8PMtiTdiK+nrUMHVtjEJnUqX0BMzUCZM9XXlh1lpx6V5HwqYeXV0i6zRMe5uBN9XnqO8Hbpir3oQ7AaDColdOgIFjMuK3d2sSJ8mnXHkqlWVlktDYezxN/BI0/3FrvBwiMXB8aKv8sdPll1f2USHi/13tMHmU+Cfb6H8LL3axcM3SzisG+yFFaoSst0gaDb8hem2cKWavvbLd2SvG5gTI6xXjRCuQDNaQBWLNCpzlKyvszSat8pBGMIKwEpR0PCbSMsFiRStHI6ppRFEk8M/HUAHF17rMKio6EMxJuv+ZSsa3s1nso/gP1Ganh3rE4HRPhEYLx0bPsVx2o3bN75mayD+nLBzX0duQ49lGz/hVPN3wS8nAGk5gRRYyiRjiR4anl37C3t7kSZJzDCnPMjuRW6K3JHeRrNsS9UQHPhkDY+g6foeO9x/yjy4zmRcHCncSc7cazWnkhoO003ZzqljyfT9FZKNMnd3ym/SEANvUxwTE0geIm6v7HGmLXWFcdfuHQLPRQC6oY64GQbidTIyCRR6XlwOxFenZsJzieFZBZ3iWdIj5WGkH7uEfM16T6bMExzX3jkuJGDAWlB+sXly+okemUMA6aYzbqBFJqSmzpkpkVBqYtvp1BtisIJMDCQkwTqwzUiQPUMIxMeeCnRQATmO4eyUBW2VyjEw9fOgR9sv4Nk8w9ZQZYyVxtgxZouRQGM8wkM8YsK3fXNrvv1eedsbPxlqly9awqG0r5hSqAfx1ayikClgtKdcAFWodJpn8LJtSqNIglzHYKnK3nVRZb0DEFkY+jQYPm+3CTxvV9IMd5eYkXEta0h2smz630eEWUijSLkzd/IrN23+wgTiRlVoaHTKMJZZ62NBBWVllwoZd40w8K3ups1bGg1vsW+pVuFuuZcWw3s/fZCxqI3uJSfWCiDeN1ao=
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