apTT5MK8JdyuP8yBlK5kVWHolqwY4jMvpCjw60Li6/pMIAI6X0JjDSkio8kKXOnYgc1dY3qveNNpKIpYt3rTEVGDorAtq5nlDYwWg1gLUexF+vQ6TNFVQnHCj9FTalW2P9eNd1/mrwC7ldSahNM7KxsdLhM5AdGk/p/TwtjyqZk3Kz5lOtbOHG+Xev2dPBS9YtAjXoLABFcxOVbfa3yrWTC74QIBywsM7g80FkZljLExVz6fVZYLCm4Pf6bO5O49GLvDhyKRijikJUpvTAVU91lxMCkQ7Yp71L95PESNbprdd1QQsFOTzBWa6TerL+T9uBuQfgOZ7IBhwpgoyV1XxuEfcxY1eab1fcH6jDKwXIEbTri7cCbv0WHFj0THZ8KEXHapEVljk35LVSyAN36fwCzwnJBFdCwv756rTQ950zu5yCu7xF+sA6MIOQpd2Vn4yrwzhKIx9Jzwj8R8hMp14Rg9vNMUhVAf0OQEQb3YpbexQK2QY7cHSw5m8x2XCYNd0L6ljVhGJGXt1bfr9fjbQh+kp+w8gm0yKTDoZMSGuhaPOby+izhNSYatlCOwcCBC3Jp/HZWVBLIQzBqEW7KiMtdGyegnjXEBijVDxxGt2Eg7kCZhZKfTuMlDYsZFEYOWJmUMzSEJUMx8oCGJQWxZWfnDM6NLWfdRZJ+qm1OD3KNOUg6GbQtbXzD0hJ8G7CZhIJz2O4+ZYZQKRBcu+w7oa+OGmH7cvxrxATB3nGmjeQbEGQay5qrXsi62kZ2UHidescRzaIO7JHyvRKqdWOZ0+VRFvQcFuTCxIz2pShoCs5bCx6o1pftUVlxRaDyS6ZZzeHU65JGXAnMnh+hAn8zA8rgW5g4eO8NDYhSg8yVzmH7o6Y5CMFxKVBuiSbdo7QKkv+nAIYkHu7603G5kIMMaws4Jn7niIt5mSayJgw0ubMBwsdRQKEQlBYHsd5o5fGPjE339DdXseePQlsJmLcIHW14AEXV5vOMMtv+95ouZdYj2+wlI5JfnBJ2dryBS08dE7yylKRTHL12dUhVVC4czKyIarnHkfo4S6TujLiZ4WwKe/umJ+nXXCJ6nYjrV6XRfQOQNLrGixOTC+47QuVuyswstVsOljCGPoOAQIKjBSYftsz7PqglptgL97yXJjUB5lDJbhG9I4efHEF3ERx/u1qjMv0yua3nA7EfJfe2ZpDDGkr2K0yr4N6p1mS4kagbagFrsBfCrPnoDXGSdHfc1dGULdGeuUiXScKFzyB40k4qDXpYauuYSUDIAYpBaE+OXUnI0cGLUkmT7Lz6MsT0nfypVMi5uOero/W7AL9/lpYZPR8JnR5I9Dac8+jwme6ydJWlbeDg7+WYa5n0sJlLKKUsF9sUMeXrruOvkbuA=
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