sCZK66NHZWQmCSJ4JSPf7bMoE/3SCkwEc+me/219dC5n8urgEk18Bjt0E7W5ZdW8M/j7zew9w4gZ4K6JdIQtNzQrBwpy1dvrv2YozZp6CpCpWEP6g80ghaj3Vqeu0gOxfQBXaGD7JSv154DQGY6b70eyrbIpCMouTg480NjqU/aP1Po+xAwrDzXVlUApZMgqWBOJJ04tBUjiXt1cpOQGav24g6AdgA5r0HqFvBsnN9NFW3UJjm+7vuGtgxAd1SRPYRr9u0HAhs63cb1Jmow2XWMMURjZepsSt43gTU9XCe9e2YnSCEjVxfvsKo1mgbKsZjHbFeue5PzFQmJJgZUdBqr1RPRg8CDOkPvxPDEv7XkCIi7oZlB/94l203IrMrYHcTbnLCmXA3tulPSRkFyzKB/rXaVImoCxhsScfAy8s7UrUtTXqZ5CgBrbZ07+rBjTJv60f5Xmc/hlDs4oC+S6t7qIyH+NmbL5uS9F+9Aq+Z8FzTeFy/MJWNGmWUQdsFCo8BnluWXT2JaRrlvGL3aarqcRzk+0+onp0VwUPaNgCFjlSpdKEtaQCcfJ0fMv23bhbupG79x7z1k7CydREphywhMLZdEAGNu9C+p6DNZIsG0KRLV+xtP+gL6yj6DKrD4ZUBsceEJUrKDu+ujV6+ZA9FWIVZf4N+GdwKr6d7IrNA6vPzv9OTvM8M66BTFoT+k6Q7cW9Dy9d8JvQYn2Knf2FMyxu2CKsFrahL2RIoOpyK0VPjMAgQ7HmgX3lADZ5YTvVvnriU/kwSbTZP3Wa3qfs3mCDeBio9g/pXhsj6Am40IfC7isFMYIK8yc5s0fviVhu7Hg6Tj9c3/mMSiBHIlVLlgx472t9vjSXQFj+PkIfSOeOsrEqC/1oF+V6GZtwXYxOferkLD+M1QzstuhIRqGuA1Qr+8mrRc4MtwrCf/syU04RaEnlvCyd4CDiSmQ1beOjh4VLYG5V3hD2c5vX3eXJSUlRR9O/Pu/852hNDEZIb/S1DPz5I5D3yYZNkU2s4y64HzgYYR8Rgz+AEf2yZouicKC35SzsiNy5osKMHOh98DpOpSuqC7wmd3rLqIbyfAQtzNqKeggUiIUFNKZFCGw6TWMYY+vlpn5RWEPalH6MjHhMZeyKctoQjraeHGMm9c+wdsG5eV1zYlUPhtz+uO2aDi366MLmKLVJhKNBGATDcvMimrnC8ofX897MhV1jXU09hn596LNrYNB3ZW6E9eG7LA9PMmaGSAbkiOqLUVWY798qJWQLU+f2httPnK3+nv1F9Y2SY9FXbXxwbwdIKWHBgY5bRaBUvhZlrlcg/0rglP/d5wC2Q3ZravDhXpxBGLjxOp3btM5HjakuiFGU0QrTQGzT4EhDH3WDqr/9HA=
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