Aq4se3UpBMbIvKF3Lfmo5xeiqxlM8kkk+r/4R+dPdYkmqZLL4YfC/84Ti/YpOGfGkPI74ok82uUU7lTFpFXRg6CZ+9bAxcCIvB9TdwXoKAXmy6EEHWKGOoNaiJB/UBlmIUhWDBsfYAmeFz/Xt7IBW40Jo7sOmszoldXH0PyDt+tkA0J4vLVwSDDVs67WPkrg7Y/PyejrnY4MLdTK2igJkx14xiYa3hS3gPk4hSgtgjLZ9UqgA5kjUUuygzE6+CwZPIVWtdx4JGq9/thybVa4n0JIKCfEFCQ2UW8gKy60W4D0z0vKXmAiRQxUAyNRECVuEh+SOaksLfUc/WMBRU97wjpXnvvZOFH/Y1anCIFAPOT6PO4Yw01dnUFIniLPaRG6h5EW8x6ReTeE/PWlvkjBk8mDr4IKLVLXjv+pEIk867c8EiiU0VwtHpBnPOwesW0/9gpRCep45nmub7Fl4hAS4FxxmEOhen8KW8JAv5UGTt7+IwN2N8p5EF49uOmUx/8XgVJjgQNCV6ALPS90jR3or+qWw+iqbFO69ydrS/cOtTaDC36UKnkd6qq/1nRS2iAnXbUAf4TpkvdD/UjB/RJKDeePsYK2QcBpg58KenolMWQ5W06VW1cUrJ2a7A5so35KYbSnbSO4TpaUUlhsB/aLKlFOEG1V1JoFJv0pV2LqFEG42Ca7kDPcvSrRN1jQ6tgQZVcA062QMPSVX3Z36vyRUCtP5Mv3DCmPKIViLdQFo8qyfU4ZvsYKURoVs5RAT8Rk8Ri7w8yhncjitr17qlkEwcgbC8QWUKDHRztIX3jEZcOvq32moyP/20h5qOtIkorWLgenDuAls1lFYtMGeIzdVMbcYesHo2a9a1UR/rhGebhgE6F5GoCHvmkt8hf1Pf62SDxECxYBTzEpQcWXW70UB7NmtLzX71Q2kgh7cCjSw/PxMc1WBuu5K0nd4aGCL+9Ia7ojUV63fQwggZQTKSwyRA6R9YHcRRSZQGwkXHTKsgqjnAnV5vx7co5szTKktJmNJoymHdIIDDm9d7RYQmdcnZyDHdkArEfhk2WzywPCverq5+hRIog6dOchZSiraS9ZCHJAeYgqEQJBBX9H2k6/PdkzN1NNSjHAMXBhXNcziwzs+tDvDJPuXJxnejwgfVESIOUxVsd3VjSd7PIaRIsb/XrIwZuZpj/j/VzkTUB55hgDJW+cH+t7D8qQG2OjooI7l6JxdFNxwXEtg5lO2n+/qYiKIbhIElQ9tGkPVGXlI9ORyEcjJcSta3As0Vw5LmCBI06pdviCqW7GBRN5siw1RMVX0IqMQdW1DZKxoOcEkN8c52BcE0kkMLUtSnD8YJ3MXCxsUxIN6MgKjuNibodFW6mteGW40t7Wji1pIJo=
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