Hs+Du1NkjuuuXWsh7J4Y1cjlPBL0r48X4TEDBlluOP4OD2NcGZP7sJYDuhGZgAi2vQVvN2p/T1+Q1nE8strT7WkWKq4tfM4L2IL6LaoVUb/BXxGqqjoJtlCs8LQhg0mu6xTDey8KRP2vzMFBgWJs792Yz7tVP8QTaGA8BFWBkzePgC8KALwRSk1EJ17N2Y5PenNMqyT5AwXZj/LkZjtuQrMGUjRXygBeVss+8yA7YyQITrKsmxYIe1Z+IegrwssLZysAMtHgqopjo/hbALUadg8s6E7EpEkpctw16RAQCbzbIg7lOnP24FPxkAj19cGkkdCJfNOwjR4TzHvUoDRyypcCeA3Sl4TdgrsPkBtBwxF1sSHpY8BDrvU4SWJCPgsx+TlhDLa/AcGqxsUSA4kwtj3dpamgCFIBfnLBDWXa388G/lMt1Nws/jeHesHtW9kvruBw7bprGIcf+liSJCrkThfKmRp+qf6z0piZfA2yxjvCS+ButHxTsueu0WP9zWlhbz4Y0XoibDyA86enHtYYJ+YJdXeabA8ZdNss+CAY2Ikx6F3FlfMQg06CghJkLrCYi2i5jXqzqONdRene/+fJmJxNCU4i9WdTnPt166j2KR0vMrywYjC8XnmSjcfbiaZziM95+79kUtM820eSKhfRyde/LQg6TVMQ6zjhj5CQGCfES0L4OFJd6Oek8MUaE+75IoKMvS+eXKfujt51lWEQOKfpshBLPhiiuMMMpJ+j06UKOZ41xxdKHNWGMIDvGfEzLHPbJx/0d4CX3eD4jpKU3FApGCQ36ZplQJJe3aicClDoOXChDmi2aH9kVhyOs0++6XBOtCkRU99j5j00LL/dZDuvxpDATsbBb4xUTkMZH3BQsiEeCUQwVUKe7t4vhWdKRrRyTyucZl5hrvQnF3HengIMbkU+nDIk+koqDtsyYSXATzR07yIyE0I8WMLtzraYXYAbh7Q5luW2QiSoJA21wGNcUe8NeIfdtBPhGpdcZdjGGbf3aYandHN4o56I/Xg1bD2EPo8IvBBa4PSFoU8I4pi4xL4eQ2SARtYPx/vllo28dQVNsKq8yiiXyCiTrLVy5fItRV/iOblFClewjP7WlwSR6/SU8DKiFEz0MOuIz7k6AsfXculo8slaxzBuZP3IAdoTf1xvjhcOhsrCGwh2A6+OEbHVfBezHpo6qbtcovDxcnw3mevVatC9FA90cDNSPkB+S2Ff6tGkt4vNOqQDpFUUo6gvsAo1hwzC5gxDlGn8t4H4ONYxjiFGc2gasrODXXeqMyxk7tYNx2XnvUCFctO5nXJQcxJJzRta09fIfshmNdZs/iNPy/m0Z3ezcY4D8EI4oapnDT5vZaHaQ+UV1mnA35rofEzcxz258t8=
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