FEAXSviLzxtacnMhFV0ToctHtraYfFSkOk7ILPup7z2tbvvLbxNepm7XNUVVzRFnsn5alGXgGxmx+Vs8X5L29HuJR347mDAqAJWtOCqOhssV99rV5CssqQQx9Q/n1989mhcU/o5lNMl3XuOveF0jiPk53qgt5v79xIdVbPMbpiuuF+woz+8gea2FswRtG/I/cHnniXLR1WLDWGUjGsWolEpo98YCpLwQ1pU/fhkn6Ue3cjNB+s+x29/cSxoGGmUvhD1LR1NYGYxvzsWhZCzplQNI7V1Luq8wSWQPQLCDWH0VhrF983d60bbMavaWaMLhsfDooJehwcsOEPnOcVhBWij1eEvH9KwuN4ffMeYQkafNIL4gbFLn+9R9QaMvPawLAzZzpJGdm1gH3dede8ZoI7MjiwQ6BFd86B1aEhLIp7sIZ/CVV7TEnkQwyFYQFgmXFRZw0p+V6kCjWQ8SvIUsRBLcIkxq1C3vN9asQ7DfQXNRKK6i8mShD1yIfbVHFPda2izrNF8qGR6V2Jnp89phE2AGlO7Z69+pUB1hjLrxFaJS5hGcoZqMsaNhv+UkuX7uTfMQzIh0q4GnXdTVLAQpPsqXz4JhSTfKm5MT4o8IwBp6WnppRpSirVb2dkXc5ZekKdL9YAsHYaGLWZhxQrYp5PhVmUOqkMEa2k5ep3T/jswFlzKxT86AbwEmUBUyV7/YiHQ9fDFv26sGxXRP8Vlqi1xj58SVGRP6FH1THqq5peanX71xSAS5Peqws2LH96Xu1rdA/0Ol0/cXxom1BAh0dUNoFQiE56hMG2VbxUS5GwEL0N+hKIvIUlNuJlqZEC2ecKkebzjZd1HVXwT4DWEgeMqgvzM06KYi1pEcX5NAtSxvpbtzoi8DqGd6OcYKNVp+oQu31qWpkj3LZ4PYleLwpfvNdKfASeCxPQ4wYtjRx2fUKoonKAAH2t7KfneCdKrNByW0qcsHtaPttNc7/bGlqVYerGDAQAm4/jB/JC/xFRPIbSsSnh1zLcxljhESMs31XdkRZLhKkKKPoHNwpGXelhSKvTDHATqh5eWcYbBXyCxgH/Q3nfqEqr5uSzEjoKTJLgHnnoucDQq+TFr0XOX3O3vdZBy6JycFq36gLxJvYaxvHkLY4SZk7aEARnmhbm6NlJzmAaCFS2uOv1LQD7lr1ziHoh0FCTQeLjekN1TxKMbk2e6umiejXP20qy97Tii9LYY8p9eJHeO3IYToVXuubLdRnEvVrOID2M9C4S4vD+so9zNLg5GX/1vLZhzabn99TxVAW+XTHxuassA7jkR4u5KtrSnzOdmcN/YZxfeFMXvwO34Y52HPJd/BZbkXzkaDKzubbuqvq0b+W9glxElqHu7ZZ8H/z+JpyMMqnr4=
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