AN968HtRlp2kEmd66YLCIK3MmXLGYDN7JYQ9R1Nl9HvWy1I4xnOw1BgruzvXzAtmkoHkMrd+JFVa0NmTrIOWhe5Q2CpwUdyRJ9rUh91CfNLxFi3TPM0wE1QTXX4mfO4lIQJNzZQ8o1bWMGkfYv8H2ZjyyuEPpb4E05Vb87PctO8c9U1GO6/XPOJGmjMjvVVAcrDue9Wsy1YRjVBYlC8wtF6GK5bZxnIuwOHXj/UPNh25S6lJ6AEl5JooMJO0290xuOegNVyyH1YmY30oo8n5kVh2vTj7sI0mr60px+9D/xdwMex0O04sKZTfRuoUTIBRFLC1MHFLAQ2dB6tUmmFa9wwJM2FIpVVDIXQ+Pabgz1Rby/r5EYBN7Bwbjfls4fWF9aGyjvUbxNaYdmIgKtLYpLQiu4vZDKF5UkT7FEp+c20mXj5CrsvvNt48VCksdEmKduV7Ibq6rZUP0dCpR3Wb0A5RtRsn8ZhrelMapH7YskJeRWZFbavkPKx6hMC2PMKOlXH1miStIRKz3vJ2E/z+tmNXCEb5O/0B3sGKw7BN0oi15GaAgOFzDeP/EFLb+A0XUXcQtk8t1V6J9qXoRU05m/sNeKJm3MrRbMlCNj4AZmuv8iwUIO0/p01OPKWOUX9Qq+LW7suEPsXyMIPtdwPapQqeu+VpbebQqVXfNC9FhpFeZP6yjwwa01X+pgj2Hi+K4IXvM966sWC3OiLv8Mz26uqCf0OEVjq94B0dW6Y6Ozu5a9Iil3vm5lVzFWJ08spAzsTfr0/89DvS6xyibq/iCb2BDf3SYm68jRYKcRRsnFaXs0zGtnBkdR9DAXQDKC3YC/cdzzqaXmJHvH4YlviMUza4mlThKlPsf+tJX6PxbzK78tiUpGFBnyFEuXwB0rhkSYvFkOfiZ9fQKNF7AcAd4dFk6jqx7Kf9hVLcL6WO4SO4YGAIv8uJ+iO8dGSMchDuRsiUeS+RMqoN8B1DuBSP7OXKLL05RMeFTRgSK5Zxjo/DTGPdwIs+dt5YGMT3UL9w77v1db7eSz7khU2VuZcUjC1esoUbNzzClK0W2RFbXvL+BRAG45F1vOnv+s52uJv3UpyEHa4ZiYvkk5VRvGPFar0gCQSdIqeSW2IZNnSl+ZOksSGGRn3NpCPw4c87LdGOAaVAjNmGzk7oMhHOBdm9oNv8rQupmMn5qVdrf5G66egi0jBid5GqShy28l6Dbqj3iv2EYkKqGNK4z5RNREKIGxlxvHtB82DPhyjEqNInsu2koorLX4ZNWRXovSr42UlgLB9771KHln6Q/zgf8VGn81/ftjNPemTwRKoX+d3Y+SCMxMx1OwyM65rAv7oZMszfDtomSXlSdvM8Cy1VitkBU2tjtUA02l5BYAeDll0=
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