a6NFruIoJsrcgOAJ4WpA6yv0umY9tz1mtq2YKw/YZse54gn2DKJLkLSwWfNbpgvnpYBy4n8GBvZMZtA6hcoHb7fbjgWgrefMoVkQzqM8WriA474zK8CUn1uaumVvER8iRmD41QqnH2j91kjcW4umxcU6MMrB2utGAq9qm+RBsDv1RRYSwG2t0Pw/889aINrTHUbyIa+UK4LrVh1R9NICKtQzIpgb9/Xd3Q5pvwneYCh9knLaZQ/BCbIf4EoEsApivSsONtkBDPWjb57NuaCkQNoyasVUYcJjPSijkTtvaUUHJ8deztdBYB7ddKG7Q5z8wXEWiYhUNhI+Pv6E8defd3/1XWK8tmnP+nFkdupTEttT/A5Uwra4nlH1kIQVE6Fpe0kyKNFsFr4zK6XOOCZxMMibMq0IRSrbTYTQMUNyar8mfZWXxrhWrNb8tsCQyDjUOHUXUARqLRLjHp6SfhJ3McPiDyaT8IKwSUdg9J80fW+Bi1jJSMFST12VvTigHqvjiAaYxizPgEpPC7L3aBcRCXsXOGkvHXQXO9wG+ptpmI+Vt/fVwGbgyl5vUOOUKCaoLTExP2doipg2zLQ0DduqFxMWZVrPz6Xuh+CVyWyVdHuKtX0/IxLpByWAJTNx+OG6/j7+tHptcTgVuG5TXgYO/M0IUiu1lNr6hfWH9TV2ZJ6q6O0mbB4rvB6rMRY8129DCkJ6zeJoZ/NJOWK6U4qTJOuufCvvxZm2Znr6bQaaTkglUIevAeTsKy12Wfr6jyvjTlOaVl28/Jf1AXguF9glsFhRC1nF1/Zo3iw7gOaQFkkt5y0KEEEfrpseqmbBmY6j/msap5TTCjvtcw5l5TDdnCNHHY9X3tF/ATNTgh/8Gf/voMrCdgk7nzzCSW01I3TUvoKv1Rdp8Gz5bVPpFXSGKt1Yn/QjwUC/qwRDo0EJhM4LVI9eA4yVsl2uUpbdw8tXscWXOefxDkd2fvg6KeyOfTzuwsWoUtMoSHGDNGI10cvvQHMbhdIxzkr8rmCn4bvIUfANh6AGhxj3TlM3iwuFr/9GS+EYLKTJs/hMjY+RYCvwAj+nNXoffu3fE4rdsHN1w8lN5kCii5uXHo8/w6yk4Y0jrYiIAhwjyaoM8PsE0yx8ZhhV5tO8Q1QO1Vw3a2YfB10YpASUOEfYzQgxhCUsd0eDufQwcEaaAHWC6YO730E0b87NRsASOwgCtpNbM6Abm8D+EHmrbcDCYZaPuxrGbxkNQU5qDZIRiNpOBNmD+3zhyNnxXnkDZWOL2+fNvRgFXRyaiEOBCag/xt1b7QDvIeuk2lNd3ASCw257P+V4qWmRCd/oSS8bLKSzuy+9/nnaoj9VGpVOOhNIToLugCDUt5JfCFxbv9lRhyM5f4I=
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