/UuDX/o5XzbUj7vg+Bn+R41MFDZexvOuTmHDNdsqjwJ5w5AoItj43bPc2qYD8DFYYs5q6aR+i5IIdhhGi6w8x/MU45uUbiD8fRlJbGy+nhiUNheCU4BhiA14oNHFfOs9l0kYZAcyJM38aihTT7Ce5bLbOmVyaiLfKCgd+AgQMh2av7OJRlfJsd/n4r8Blg9PgXqUiOMTwvNBNqtdO3cxjb2/GcZ2oZHHAw3ZW0sJkjewb/7nEk4QlwSmjbtXoi0tA4PHxst+V2+f7JkMdJmMnRYiqd25nVU4k0u6tptB1ncWKcR4YhJzLqcrJ81yiE6qFNSIzkoEXqhxHkYAVlEaEc6NbvdhILeNifVHxyx+AjAoK0Um5PIZyiZnf+h0/i5OdqHDPm4Gyx2MkNzGmfTjEAiC6fvBpvR6PZbtZlQYQ7ILNxVl4RBM0qNlE+dUmClEBiVHnussTe5gV35qZIeECXtzLOoSJQkXGX5YamtroIN1UM/CEfS59JWhF1p5GKcaAYCRE4l4qT59ZOfVRQ1UlpL7VzRMyDi/HHmqgxK1rhEJxUH17/uCVfa4hDE08IT7PZ25ZfoFvDtirXwgpl1MOGdynuVATzujsiEA1fpdya3Kx1HYBtvgl+UuvXbz1oonlMoKQyUpX3ZlRATgv/ZMCuAUXez7DcYWbF3y67hKuT2HGDwlZdOw3jflrCZhTU5jOk69pW7nmFCkD/VISxh2QW0jBYeDjqd8Mov8xsJ3gKQ6Q1peWhps2cKnJ6i/AgM+d9/WcaxuC5lkzPSAsz4B0lPe5PipbWABAA8J9pe8xC4ydFldhi5qba2WwtJTdDNkDypK9HtxVf+vvJa5zuekeN1qk7ded6QumvnbqxP8AhwpMqM7hIS2kSc3sPKEc+8EV7Ks3Q6cF4V7AqqJqn3rPcQjaL4q6rLlcJ2tbiGIYZoZudJ0pOrmfZLqZrZrHD0nzHOIsJeJOu2M5DI7cRZxvh/inmgNVmcLEtC0bdSsYt5ssnB0WqSXLY18d1ARHrl9XH3t5DnTPAMdbvOuR5byDnahnOfUqNQLuyrLVzHjqwCLFuxTY68RuGEMH0N7YHdGUl+N+Zu6emlPcRBUzpQxOjrt7fIF61C+0xnGxK4WXC8WPSlBWB12P8TK2pn5gvTzMb0Tyu/PhM8aZoVsonXL//rFNq/QHclm/b6rn9n76OChmmZYuaiWWI5A4qfJaYDThIlwtPSSDHBgKPNVawLXWqUX0l9mLDGx8RlwTbHEJxyYo1hz4qWM+7aZvMcrUayU2H9nNPyh6H+4wavL67RL8C6S9oQHerB21mbVrhSh4nNMwoqF4fcuOh01xyQAibNdZOxB7klwJWcUMSPCut5s6qwbpS6J8Zuj8sdm/nk=
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