iRzFUfsa81jA9fRvqoxXU2k5aWiAwJ35n/+fhUO69x/bfB4WCWrEx7ql5FIssjqRfuG0YEFBOxe/G+SZccwc/4lKFHhqoM7TcanHO6YwWdKhYCDuTbbbh94LoKceZICK4lkASMz+Mi0ZytgqTBg63EIYDe0DP8cac5Th7A0Yyas8uYC+NlWKIt5aQNv6DnXVuIJ+qZRLgPJ8MfaBRmgdBtCeE/ZCWoc2B9ThM/r7+M9f7K+1uJJZQEwWk4nvpP7lYLLsXhkyZ47suNGerXi3/NMz5vdiD0w+EUFmWEwbcjORa9k0/eKrjKF/Zl1saUeeMXprzdvt/6or8sFkrYnrg1cDNIqh30LjafSKJ9k7OgrhzUHj2A0enY58cdnClxkezhR5sucg2T4HEu7bUR6sUuVvcc4f6yUMPQtIxH8LSvZU3v3X/A+US3ZtiZj0+sEuD9PPGrYOMYZwx+W9WDOpgQ+xe7n7vZUp5Lg3gogiFBvD114cJQZAZQBOlQ7qGOkbwPI8/6SOxZryWzm685Sjo5vlVPQURRc4rOHzTteep3qzEmEDZiIm2XB8+EZ6RZXVIL8yVjx2OL0ap0dRdP5QGrZ0HI0g2QVFSAkYP42HarM5nl+DCo/U/r3XD7Qme5UGuohrMYYgFaaBp1y8paFmtdASoPjI1a8tReB6IldjHvszrgnlvWqlxBAKA9VWfd/fFjye7lA9RmXGC8OyCBhhxKr9CjaCO/gfRhfgcwQlM8tUP8s3sflX9IfB5zl3aSlwad2AbqftMihuJwxZj44HqGuA292gsNMWbnfP9mwbT8Ae2ZZ1iAlBWWAVsmm2b6LZJLymqUB1ZpLv2GChS3Tlr+XUmYKFzCzenLkhf0ZEAPm0sWZ9SkJQhEqPZ90n4SNLpWmzL9bGnBYfwTQmA5XEeTgJQPMmmX93B6uFCcifvi4YsOgvtBKk7KnZdXxRpNvrr53Y7Y/V5zKnPCjgatIW7FCr8x3FNNHvwUvBdC2L+T/hu622CxySUUCXHgS22mF3XUtIQhecyUF5WEe0p0XAa56QuaExrCPtXbXgKu/7R8zgpawrtoI3iTXxUErLYfZFNXEQZkp77WCWjbxg7sh4GfyLw/3wU6N91GBYj6hrrHSmaeQ0Wp7AudxQSNqT/y7uLXaP9LJ+4b8e6ZW5P8ssd/FLimtlSqgxx8maDLmDt5FeAIo/ETG+f1NoUbPDu+Bl6kZZgGh0ZTNCLQa5Uznbm//MoTK2jzcHqlORmsoyapKu3PLKenSxTFDTxjmqsj4xHLBegdiFQhCElbcGWDce2qrueSrSgODhQ8fI/A4wm3/jgk2jAb+fdi9QcRxe9kmuPwV+AhmqmHdjmxIrYLQsuS07FoZbRhXr9kkL3Mk=
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