8q3W5NToB8BZVDu561zlM0n2YBaKzEIz0Lcy4mUgvFEhJkXFFAro36kx+kO8u5e9ajUUn8QW48g9E2i4Cc3jSiRDQLURO/WG/wz14qvjHzQhteQ9EqEuYrqdTPcteWTG+EBjaBDo9VHZIusbCECPvt23Reyw8KMbV7uAGFGuhEadwQEN98JcmAMPQmTk6fQHnS1CVrmyn8O0wyUTcBM+K1IPT/D0HJpmjv3zWUOhfVZJD/F/dImoCSqYnXN+hVH5J2pATdVwfHGjn/cezCO1iSGQQN6W1DauDXF5RqAfffTp/mbaxK/LlxEcbWR4jHdWsQNr6O3DyL9XmG8B9bw2nkwxBU2geFQr0E4yKhOQZ1c+3vHR+rN11ko3T2uS3qaUJ9OQX5n8WwkjDadfROZvIuK1GJ3uKTp8+NrHZ05JEkA4aRI9lwZbiIpYq7WyVfuvjV9rsKp18v1ddgTKCm2vxkT5zTME/cjLNGlQOPceHFe1nAVZnQFQy1gf6ZDa4fv298zA8EwGvtgx/h1Y6ECAv2N3b+20JZPZPOJLRinq4Mz0ze9kSO14hzMkUNJmQ3lmSXysBX1RdQQl6nyEn02DOXmayvpz3ky2U28hVEf/PlhTeKbRnVo3hu6Ksm6FUo5HLhISMOLGfnGnfXwriDS4rKowVRQRzehUfmntILimP8Dll4mGjKgnGXN3QZIrkP+Au1DI2CLldbAl7uCuTejL26NiumHbGeHKDPBc4DRDdK8USuyRfMsXg5oAeJqaEMT9IQDjYgELDO35uRC4aTJbW5fhx5vuzMXTBTmcohZW5LuMdDIYXzx6Hwgn5dQFB+6f4/i5pEuE5nH5OSIcc64LgxXck+s2LRl9kQkzX3vR5pfHcWk3C0cMAkgjTtY7I/QPS97+OQIOOjkZ/m8vRI/PHZinF+jM81GBR2cRuUNyYc0wx6iIShFS8MrcTIhelzFQtEdliU6PyxofFsn94YMe9jIxRGQNyJrvES205ZHO4XJ+Jahi96teo9m5V4K/8t3CId1De0QLCFNQ4lL2u9kSo3HMJkQdoTYsMiUIfHAietxHOFLV7i8V65YLH/s81feTsGd3Ubufejx9LxKc2OI9Ckjj62jZ1+KwG5fDAwV7t6SIzP+u0l8sJpE2sAPQLLDjL/KdY0wzOtTZHb2Bgn1iNf9QC7lfkicY5ACSUK5RyAK60W1Znfa9pmEaXWO9dQIdt30rxKyMyxLiR8x6hnL8faNTlbRsXLdkLNNz1JDPS874LxNl5BuxESjWQRSve6t4iN35rX56Hi+e42VOsJ4155eQ1WXsxd9kvg6Yil1qH/wsJYTfsgTMLKKDdd4HT4q8KdwlAe9ngeyClL2UrDbM9KRwAXVewJ6e7ZVSZPk=
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