vPxTcFdSTVaGM8MG3Liucoha3jgFzQuwQqzPXUO2mNC7Put+Vq/19Ku4fCTmJ3KUpTdUIU2bL/mmnCSMqVUEKoc9n4aeurrqi4xKtYQpX39REH3ULYAvk0s7d1fl3TzE/o7xskznrCtyLaMCQXRc99JlqwgEeuVycjGhJN1FbAb9gawDDv/KMQ4dKPdDgl8oI77RU1R2N7cNWjsrGC2cUN0erZLNiD9KWKLlN27lu79xgHJLEY2JZgI+Jg0v9WFWovMgO4li3erqxQDCk18YBIMGyNRM2Byn8GNUXEOjY8yHO2k7JzDd7e7zs0JpxSRjBqPHl+5pHLr3sqxMi22cJ8PZve2oihqGZq/7Ok6LCEHH66b326w9ExTQgiyRNJvnDCO2iDwYqc3qbpqeqizCMW/hovtaasnibyh8IILbmH9zmfCFyimP4Qb7iorvSKrXLOGPR+MdwrCdW/hTPGzUJMwLNtQ/lm+/LL2HjxLHN1xvuDUd9RX4rAI1KJyPtzRZPkNMSe/Cdcbjk3qAJKw442To+/pwBTorY+ooDnd/Vq1JlcAL+STqLooOY06Wk4N3zyrGRtrFQXLzsxdKOjUXkngEdbhVkuVudKZNGZAMLI8PJM9XrLqP2XZhvDtQDFywf+vtRH8D39n/+YutEtY2qoeCHqYxV9oJrRAGDPLgnfY8rcqUi6tsfCR1WKjLEMzW37s/h7+i3cH5HoErWUsmFT4jqdG7zbB10Tn8h5GPIr9+Rsv+18TN8W9DO/Xw6BV34IqfzHt4Ri/8xjwYZEKgVQFxmEHQlTLN48kLLhN5ZoOC0EWr+sltbZQNWtWHmPxHq972++xZceDpSFZBUPpNFkFjENnPg+eZa/E3E5+evK7VoIMgl3SWKsE2Dr3Xu1lKXnvRCXtqOdFG/gYKXX3tg5z7Dp7oyjrjYeGjxiL7vFaXVr8y8JrtnUI53D7pmO96/nv6FD8KEv7aNLGybGuXer8q3VGgCmnMreN7EfDDbNFXB/WX9u6OsqYek7qHgFae/dDe4trTaxTURvMzaBaCvbH9nzSGrmQT8Cv8sGjczcScdTOfy56zoLXn9cSwfNdLvuDq+XxgEXJhjwbTgnIURLExhS0p1bl9n71VTyoiBRGhIPIr9n9TUiPUxo4ioyOZzrl3Zv6OaMgogmwghqufchk4JX0MnVH4Vk0jsRR9yQDqln1Rv7LQM4c6/2tntdiHhuy6fxTv3D8zVoq4q5qPJrpPPeQ1Oq4Kk/6YFg963YzgjjWSHAxeH+fxW3wIoJ9k+PWTDChufyz5YPMhrm+np7oMmDKRR00NHpkjaDzETm+pqYwsX3iBfr0jtyS+P/a3pIq6cgql0cZcgjXlhfN2oH/RxDHW1BA+vTR8ITY=
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