T8YPcLMDhrV98Myu8bjUEL4eQZumKW+D0Z+2NJUq0SiTOw/TfM0bU/shukJuZPAmWz8uliMEiHbhy0uqDg4Wl/ZbmECi31+pLGshrwyTLhYJmeR+Bflp43J0IYEJdfdNWh+tKgZi/fyHJyirJFXo/RtkrNpIxi2NNciOaSJt/nLLnXkYyQhoBfZ610c9Ts30fF0+lmNjYFh0DB/2wWvLD3poX3wO+xuAbM+G2Iv9DicI6UL2qR8habyMuxTMvZdgoTsElN5SAosxkBXLvV9zU9Olc9ynM+piHncUOXdHiaThA+sKbQuUFODj8DMvJxzCPwPahCyondVfv4bsEncdln/6aloafAqxreiLupzRZbghKkegj7wR1yy2aqz7uQoxm/2MCgfXeL+KQ6/6CitMrB4+yfmB1GukZZI4vMumYl6DwTk7EYouM9wBWuHYRmc1vh7NCf9NOjsI9EkAHZDbvmT2GoorRPL3NEDiwlakBXL7w95nZybNVSwXoaa0Sxc559BOUJc+uXEAvJz5cpKdicNGy94IpZMIVfqAksl9gxOT9OHZw3qIcxYKCXcwv5+6pxTEAYVnJ1FfMMBRfN28Nnb5jmKxRHJr5tCcZgGuu4sPzfzHCgYexHZ0fX5DtSUIv5vJLmoT2x5kPZ+eomJEcBtKFmXNspH/yyr6aRReO9+kBGNezeGOmNEbf74APnZQY0S55vgVETls//IoiclVHID981ZX5nPvGgAI0yTGSfPQKPaaLhXn+H3Wax/adQJlv9zuTk9ljxiOZQa+fpne+X3FtRkthsAVC2Fr9zxGtxvllo2K81BORA1B21rum/wJ3Y2hTQB50UB99QEVzGSP5e2ozFzNeuqySYpTGsgfd9LYHxe/RlAKClXztoUV6BisVpHZ6smDwRV/kyKgzbS4kWLNpEoV5aX+yIy8wVibceD6osqmVyQ1hTv/SoZ0bIrs6d32sJkkluH2CtDyi4HOnh79pxNXgQfPbb8LiiAVO1BOasX4ZY7oB0fB9O89J+DXwei0ho+x7fVhD86DawGvLa7HccIVIYJ82GxUdLZNH0hisXW2mK90isUnzb+BLoV/2CPGiwWCDjKc3lJthzf6w7sXl3FuyMoMpQ31VVC0X2Dztk0tt/KLCliG+1R+MNHGWLxLuiXZpB/w9Jwow0g4rLKh6mUOt23SERIWtaRjK2X3QNIfz1FvFoKBigcrlQBGI44NFszmcR5mdSwwvdjtnrWHw//cTQ42BXqF61IBHnqmsE1LluKbAt/utOyBEwmr9NV/hD7a11LhFwCEluP7aQ6sXJUBqjhepqgsjikcTgWSc2xmgvfFMIYVMPPCy9OYZeeNSxUD//7qmpopxQ29q6i+IJWypX+7QkBHHbQ=
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