+s5NrE0OcEv+oEkSF9H7uhMs6JJF0354MsO1v/BdUuJYakEeCnYNMBdVdOzI7yPx8jIqoJu5tUljoi25e1P4ctkJbqn9M+ZIKycd9WIZFG9gj4kk95/Nr8wIWc/vyGJoxxcyMlYl0G4dNyS82iQYUKKBihY7s8HbEMxfLqKjs1Ie6jpfehR2wwQ45j6j2lIhRfw6VIWZEmR3h48nyd0HTON5YVL9qPGdtqj+he+Wdcy8Nlcc747znFxJ+LlEq6bAFj4xCTT0YV46rlcCiSFrgVbg3s19T02bdwo8QKNWNGpCM1HmhRxlnoml5KtrWm/4pRvcq9XRVYOiOr3xCE6TphWH9HCMQJhl5gcZe+KI9sVOcMAtmzXrXi8qt1IW1HsJguOZk8IQRY7XOZUX1B4RMSXwXDHKc3BDFHmXYqYtzYcczoOdvsceOYD1P9C+4bwAmcSEFymSJD6mSyM40j3iWriufI0kx0l5WPzegoY3fGfSN3md5YHdiNfJbAFH+p41poZUhMf/vYBjN7uu31LisERtfcsBdQavWLqhi3LDjXIvWnsrbdwZ0HFSzIBX6Hj4ahm+bbd0VZzHYVB94TYbca0XdcOUFQwwrk2un2O/p9QMsuTiI3ztWhgcYo1yKHlGKZYcohAgzP0fi8IqnjLJLOYjT1dsxVV9D4Y7TRyvHeUh/deEB/cyhFOXchxdKTIgD99vOPa0SVQgHfaVLuZJ6UAELvRktbvbBadLkOcAmIy7e21zc6EAYZ471QRNO6f8msAPm9O+CkcXeOXYYQndBjZ4oAVlUUgstCJ9wIeqrvzCwcQjY8zqMFH4GBqiLAiocDet1PYgQICLDxUKIx+fFu9EB5SQbTwN1DjZKORZHlgeX+h8GqacZnc0Nkl+vyc5zJLRaJmbftCNEZNwbl39RPTzY0VHAgdC+ecLcIXIOTqLuwApxDyH6zNfu1yLEwhElI0Lrga5k5VNQbYeyM2NfCLAtaNvBOnfbjAdYla+ytFHLlpdwtSjOlpDShNjsi9ZAuYyG7oeYew5OKHuU9OoQKz+toOcWvC9oPs99R8t1H2llF3e5Q5go8EGh16bBdUiHg8+p/8a3KgvnPzJnyd+Um00Rt+9zSiqSpCVExgcAGz/Lq35OlzDQLh0oCd+K/QX0/Lqwjr+b5Bmqlmzm1DwBKUTK+3SKaDyKLP4G/p6ZAJBk2AfTeUEDSg9fiwOtSMRcD/AA6uAU8BWagvRF4DQRNmKzuMt7PaWx1WadIufZr5mUvYUxHoj+vvZGXJajl/zI62kGMUBMZqKNEj8AT8aNu6Aup8Ow1/YMN00SNxqOfoffYrSP7pho0XzqBi0cBrZ7i82l5ThFq/+nt5HLZAGn374wgGqp0MQp58yvUw=
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