uIar8mZo7rzeSUOrV6xCzHPz/WLsK7K8kWCDBa3V3AOm5MpdQJK2oOs1FyhIuVSm37tZUogjd+nkLICLI5KI94ZN8PQDaNv0WJxYARtPfvhFddeF7LudqZ5+8QmNQjoBN8bmHEW3LG8psyL6YAnfQaFSQVK0Uohj4mRTHGdvrcMggVDDaZfiN6RdKG0WnrIOaGRV/YaDdsqg8MiL3af6azu6aw07aZw7qgevzCy9b1GSH12/+/T/QuGXLTKdU+QtJtIrMtAV0RTp2VwyPbTCx0Jw6rLGhN2bxQRNvtHyuas+kVtHA3HLbuvbB3ryhtttoDtmxSZIvrUNF0F5/4ne8ooJasff+E6g3ddrZE6Qm+PgttWH14V/FtzBUdYjgshLoCRklVCh6DZJm1r4SauxENtXeDnoBlA7/B+x5h4AlRSZPspyQXFHMVJr2WASDzzlV0EhbN5lowczU1jzdAQoz6/tPeEEsAHS6KL1sMbO9qheIIxTdBLyXi8EqHFK79OXy7TSLg3olUaq6td81UP5pToMEYHZCtg9REdy3zgkmDf35SNGf8SCMerbcHvKiI1kPVXQhIQGWyDJH/ShAjmC3Qa3ZTVFzyrTlPuKkmB9FwdJdTqwspAZdnIZl64inWpKld7P7RmT3u/okqXEZlAidSA8u6xCauSLyWx3TO02s4Zt1fkbQYUNYxr/mM+ygxRPl0oTa6SvVZ4KeFTmFEqZtFgUNt9gCBtVjCEaF35d6l0Ch8J7CunKHLY5X69dNu95579rvcA8lZ3csVR4PK/kqXRwP3AJXOVnhK/rsKO747YYEQO6ucR9+zACcouQRdaCYjLKtR9t56tipfHGiGAe3wmPcd8mkOuHBWKrMTmVS9nArGMYBq7ZKCIK0vzxiqfVs9+VSH5tERDwH5YXQ+nBQwCV/dxFZRiQo5OUWONG3Z7twQ30HLb6+5Za9ft03yDck7dQEjOi2rA+uQgsMsbhmvISr24sH1KS+4Cv4VOwJ5sYLOknziCq2aCIlDvxbpbr9w+l4gfvT28MmQpyP22B5hgABx3JH43Up6+E8t2ATqTitOGEnKi9/pqiGF2uv4fyLLwDAGpQp3bQ9DAUx9WQTekiQjxLKhj8+qh00gk8LFlBiyaSxhymxOL0s41fpuLK4ByQ7gOqz4QJ0VOgQehYhT7EH02WFLTkxz17js2sLod0pUYDcvOQ1XH+7AwqCZljaub4YXWME1Q2WxEwUn1F6YRxeuX/7PlNjkd3/cqYRHCZleBHOLNBNrTSDZAIgk66numllUXHWOcoO9gDCWqZF+kHlRqDEdY4Z+esQ0L1QKeCFf9qf2trssMzC+s4UF4lWjyQJsRQD9n5PNCkN0A1iTh9snSR0g0Yez7EVeA=
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