kUbQ/ClzXyDAxfNG7A7t5a+XI2ZnZbiekuXzGshYuhX4B8/vScDx+GEqzmTMh04U5H2S3pHxyTPMqOelOZEDOhQ3EDjBHYo9QAb/kFVOSeZ0iOXjJZzSPB6HdVDTVI+zbHfZRMiF43cZS7AswQlkjhNIDBzlyeK91C/j6T77xZM6hSA/L7+int4XfL4LlGAe+l2IjF6l7uQ+4griqFx0bO60hOnrYNTeAdqAQUszZPqxXyVLQZq7O4IiFOkWE9oFAzgSOIjtWCUtohmE3IsZTJZPrjiaCiHLHePencPfl+5fKZwnTifXjURVPJbqdG9mLgLySx6FRh9NsaB8gK9bA5PMxGyUuWDirnpjvV+kDdgE+JvoGCoJgBDjNZR3cT3KmDmLKaK+N9vgvEMl2t6bGtYPmOwM1giC8SBZZ0LQM/ayaCsU6bOKhD4ETi7Jb6MvSIMjN5eI+KmiAsigxXvVGdQ1VAHBpSYmXQFdoSwx74ot4o4xLoN0aQr1beXuUlp6pEw07Bl0SU3VYX0Bh1771hf6lgs7zyf05UEMh/Zt6dI/oRFQT5AumWGDGE1u7GGjx56667fevltBI03EMqCAwflUnBSldaIKGuO80+mVn3eiwWt4dR4D4uXCYZX+aKGjXid0vesgJjFeNg8ADWyY3dbfp6F3F1Va8HlRoa9A4BUy9JU5IDJL3BAL+EvLqdESzNEAPjrF1i1qEAew7qjVAsUP7UEaad3tsMV/BZny1SILQDJeXFkyaiQrnjL9HZQgvddmbipmUx1EzZ+xoyxcgLptLTkk4Mf0hywukgoe559c1pu38Rmquvgbe6tjM7wkKrAw0KEU5Ihgbt1MgWGFUgnI+3+W6nsc5aU37XTcoZb4mvYnKNEpHZrEXvOdQZeSHpkc0iiUUDFF6Qh/qCO4319g77Wun01dm+JUDCjBEDzWw5wyWiZJdBrlKtyVSgMcUXXh3/LYTrdfGx2t6IK1KuSCOg7icpDzcgNfg8oeEiqX9MD2u3RG7aGmqT+Q1EXNOgwJLRSkANhtI2RuqjWuYsoYVNjgxTd1Aq+KJKzSvesDsXpD72EjWTY4OULK50Z62Qi+kRw+eeTFZ1PnhzqT8vqgC5IV5//bm7KIHvpqfJdp8UqrYoyCwGUUiz/h3Dbu+TRyMzg0QqJnm07F7nIBMrdwjDQf64bdkmphJC94xr/pVobWJEDMw7s1xl+Md2ZxxUMCHp6nqXLowTrqhLThhRyXVS33v1UA4bvXVZoHgXnAPT6E2/X5ZYL4hgXyw15+Z4GUqqCH+tfdg/1DlJ7xo3Irse7/8gRUWzcJr2XZpoTcPpKQpM9L3FWJtiA6kR/zfulZHbptOfKcevKglqUAj1ITQXYNjNjxFlrqwFY=
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