PoC/+7Pu4KmMt2xLSKh97oNuakXSzkBehrrbR8/gV68fUocXEWL3FGGRl4La6ovaHw40dmeynxlP7nwbkKsCwaaLRXw1Yue2v7jvUA4wBr7U74mDTUjy6fk7eBC1XLhmOdv06lpv75PYi8WvYSTQSkFNmRwQWP9qkgpSh9IY8lwhlKPF3OsakAdA1jONdY1pBXNz3PUgPoNn5HvBPcIND09EIm+Vl/yup1BHzh9+PXzsFloWJOfAI3zoz4G66zIyiU2WAwVG+k2dD4M3VYDsppTLzfxIENLYZdkc+fTO8dU67YDAwSmHD4h6F9Niexk0f8w1f4z42ftQGbLU0oc5ROEfbYTNpBiNbw1BLx/G8Q1cVoHxtgJN0QeYABt3s7+FySKo+NJrVJozHamdLwybPW6UyI/u5ahj6lNYyQBFfvwETGTwVY+DDPASpQoP8DoRZSpsEKIYQMvlwCz1t2fxnuWc3OeHL0Lm28lWIwKi00H/wPBvUx50RKK3oki3Z5Ovp8gu0Cx5djMo2dqaKN+iswD8eZHUUSuv/D38licZv+BBxdF7cO/1j4hGiWfV6UebUkWbP702xmYdvuGa4xE71p+vUB3SzgNRv3TS4Ao9oXo9azBis5U9LThgRLmK+Ad2qGOdRRx4+fXvivNcGTpDYCh/wc3SLX8j1cWuxdLfwdRgSjzLPecnPyde0w1p37gPaY4CrPPUfSO/ckGEfz3itpVoaZ5l06v+5JI4eY1FgF1IQc890ouBKLL6s7U7YEbTLBPNCp9vCgb+/CbJYRujrNoeMNzM9pS1oH5O5BWzCLQKLyvj1QLAKRSyaW69F1kl0dg+sAQ888ftMlSTJzmyIwCgReM587L9rKYkw8nsaU8Dql1rTeUaAtCOylQI/A/svmg/IYlGTeWh3DGeelzIfI864cLIX458/fjDD52/exYw1rXqjzYN8PkEiHJsty3POFSNHK+mPQDgj5vTWw+DGNib0qUehOWeDamXrF+kuLuNG0wklb6DYHkoQoENEUhd48nKfl0+hK2rC99QDa7/EXWiO//RDLt1WvRs/tayQPo2gghmhNCb/ZQP6IZ0s7wK1i0W8LojoL8M5lTmI49sJTu8OEMHffyEn6q1Vhk9ZGRXhvwZl1OjTIiIwvC8kY1oIHfkoUfXsWz2bDCv3m991kQfiHe1zQyqyJKI3we+IG7AzDPewVDTUeEcXTMvjqTkasKmhJ1DEATyD6GZpGlfxDRarWSp9y8NhdZECK+QeebiwbRm4VflhFurrImWfGCkURHuYbi7lv/3zcDFh7675WUEPXdJSv6ePNYsFewFXNTfF6607TojZhOvMeTxiQbUDur80BOHsO+wcG40DEY6ab5Dq15Mvrr/yd8F8j4=
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