xFNaIgl/2Kuya4aNx8m6wD/q/XaU5HbIv+ArxLZr/EAWAR0eq5NOjGQLZn+8pW0/LonSBADUFxVWnZIzkzuV0+J45lnbDTW1yc+b0z2/4ZmFBu3yEowf04H68IZjKpV9kK5ZM5ktep7WPBEZVy5fi4Ik7brb1jwz4L5C9DJXVaQbSxfTXpz23AH/yLGjfANIK6aMJhigHHuXRXsmvULoeF4HtiOxussx4bi6wHPbUniFVIoNr0aNIDe4+jkyXn7D28Gg4i76rZxjNQMvMeCGFeWZ0KZyAHS5kr4y5hNE0tOiTIyIeapbZrguQdpIKTjRS2YhSWP2e3gZjOyDDmwyr4cme3sdZGa58ODCsO3IENZc7HhNnUk/1uQp1lp8AIrd7JIjiH/bVtl1q/kpDgXPy65gxC257OwShEV+Ht46V+G5dwff5Blxf/9b0lYA3bxv7AppFo0lBz1VEMhVuaKNTiZgEChqapTMIgw4PXcVkz+bdw+ldYfBv2VXliFYE/h3g70p9hYYutRfSXkPWAmH88RygFOI/ky9tRBC7oLfQn1L1tVQkYS49xtIZPeAV6RO8d5hzVtCx6ZR+71rhasGDKLSO0XupuFdgc/i52mDfbdlSs5AvPWiuLpdKcj5hC87tP65pa8O2hrGXry+9oT1RDaz7uKnMpaqCQHkOrFTIemmSmuEbj9XY8rc4b94nupzlPYBjjL+TqEULnS6aJRU6auDasllAaxVICqpcZZlsdYOR+0s6aFJFTb5ElXBjWvXEagO3s+L4M1gBfzUBpb/eJgg5PFfbo4RD7ug1rk0VFpMJbrmauv74rpEc2woFOs1/neCvZZdf/egDsmqeiHvAWGGGLMlDKIEcFBd2RmSLt7WvX9sdw4D/g9uO6EXZN6EXSm87ym41CkXgCbmRSdnTKWo/y5dQ8twgRE9xN5AltHeW6XBYbLFla3PA+YtcTfqAntON1sewKni6iNogNxAB/j9fH8x2rhs1MZF9krCz9AmSVM6z/US1Y7SPdBRr0X1JVaiEC4z1R1d3i066z3n/M+Qxmn1Xjq16yQr1yFXvCzMO8U/iQJUAV4SOg4eL6ZkzquYQWKLmb70pqLHcVNSDEONuIHsncPK41Ob68Jm2tniHgIaSo908SLrzZNpSAB+AVkscvRL+PwD4YA6uATVYCEY2DXhiuGmEWXFjolsBVb6Ct3I64YFNOr4kjlrlrvByqvlMiLamD+DqpD+e7lKkZ2ejp4u5GIjnxsbdvgYGuR1GidyThHilMYZmoR/NwCn8YkA2Vu/4DtJK2W0zk5M3mFOLNUMQrk+UEi7lrUyKKSCXiaR8TTmBorolXr4WlP2L4qGqTfckXG84KdX7msKSV3AnI3kzHiogmKQhI8=
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