QIkLhSuVWnj++ciu+qHoUwT+7o9zZoOuIijmmihi3CC+6tZsnQwt1Q13cQHKU0kagaTq3Zs1V3dng49Z+e68ZFPBVhepLPoAQYDqCRbDjprVGzmdQR4QK4WMHeuiZRS/RqyRztTCCJN7cwWMKV+7dnd71r1vurSS5S1iEcG4uFGEjVioCyRLoxr5geaLDiYNKdhvV5EnJhieWR3QYrJ0ZgGZAMc3eSxYcvCMnGAa9gBvABJtoi46gHd6QMp5FyijkXhNTLa++v8HSJkVUYmTlCpU28MZieA2Hk4jNYXF5Tk7vrOkKMpUyB7PvNWevOv2mkyRerQuJ5FZcK/31EdrTP6RCBIThE31IfN3qRO+jXeRmNLERM1I5lnN9XRMtkZqFiLkjpei+Kus2ciHXqhdA/c9bZ+U0V9Oy3I8TDHUketJ8lYxg5BSuSl5HyJ5SOCFcyGwpqk4KFd0GTW7kvSu+USvE53n1T18F1jcRaENTuOFwKkSSy/3FJN49edbBuT8NEzM2P7uaGkkjKuD65+oJivGkKjK32QXYOeWB+TTzsW6LtFQ5hzo6MLyKcm4jqidOROW74uI/k3vhSBX2vQ9T0FVjFAYyXO/W0KH4goNesHibWNSnJGtcCCXPaQNYbia76ajr1Yfatb4Ny26/2vKuJ626nIgt7vATPfCXg9ZQHQfWxYHgO+UtVoDySYQ8YoMO35Hw7xWWUCA1TkUJM8jVb01MFZ0V7avi9hZp1kclxfeekAIAlbZiE6H1JwNzabAF3rgup+jtXy0ezN6He8s7euMomd2MnegT2T3x5AXK6VeuM+W8C1PsjxqFeHpjSKLc+EzEOVxBn4ghNGwmb2sKfKmd5oC2p7Vb9KjawfWQ9trJnZQppv9cvJIwL/tDlLwK0UtGZGgbR72RjhfZfFBEYXbsWf98mBVaFinwjcRfeorWPMzwDxKBTCcJfoFwHZ5qLJCA73ra0dRJ/fwY2RhLK16lOsBdsc2cjEKh1mJbiYEcQlG6m/HIk0PhVa1jmbc7x6mlpmnbjIP/fdzkbSWDbKWoIZ2XtvKL/a1fGHqap1LmTvNIojqtvlhB1hrQpeEmBk30NJz86Su+80OTYtHhdgJgtrpxJhpJqOfJr9SLWtwvTZ76odutDEhZ1MJhW77iN4O/uxbZgNCrYNVsDPApS2noMIdvfLyfgS1yNbytNW1l8s9kvX+bkNt2EnYIRIgrbFTTd2q1bEsMyT5mhEilW3i6KcPP8dLCSaTh2Jy7DFNytgDl0JksqFLR/jnTnC8Vxm/YbXy39BcjCb/NUphAc0H09autBg1N6WZdLfOwp2aC+mdsLV8WYnCpDBE7s7/hoovpIPlt6rjz+bfpHgsXeKcihY3V+83c6H4rZ0=
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