C+6UstSDc2T4DYlQT4nu3RE8MqYlu6W7TC2+YD2FwozfgPP55p+svyG01W9NOHlcojhH/7a9BAN4B8fOOO3qX+OGCGtXlEFRKo93AG6bCFbQduhyDEQlPTujxiCx54grx697o9iMK4IL464A8y0/2gKcKlHiKd103BgFzhw6z1cs5wT7lQNfXkzm3kSQDJ7nVwZV0dHnbqJfz4kiOOXVE7EPROPfS7Yt+U+3EVGyWRHIn9QzBRpUvxR1+fQ8cH69saMMQdaRDVnW5lu+eXuHLGDmZEgzOvj+GuyxngRsx3R6vfhd2zoXOPncjy5nERQ3ChbLiBroQQUQr4AbwQ+0V6BBv0u73vmwDAR1RPTlkwwl3IHzY2cXsfKKVzMEWlAWxHVuf9mGgYl6lH3Jpn873cDuIUfMaXtMK4Ni5dOpIbwgCLCciGPJ/KpKYSpY0BbknzDAuhXz2GWq5QuvqBzyavwignM3ERUwNOiUEWYUcsoN66XNb6ebXxF3Hd/lh62F8FChbHjhBmeFTySbPN6WfLtolRSiufpoKA8SGu3Cad48DqJr4rBRDsmy6bpCQwDqZvdzejaqFUnA/sEZkwtKFvZOXCTHmivMmY/hZtZaRBEHnSlWFm531gmn+WtBHZ9vK6LWo+XkHmWQBdeNfOMZokL9aw6+cr6xdyxucXbmqLDsaXONZpIwByM3ylx0Cn/GTipL8NvfOzOzALqmzXfCyMN0T/s7YOK/ViUaCwn3Xm0TwY8Dwl0ErBTea3Bb2Glo+GMH6jsuzXE1aB96EW7HjOJacwsVugtNJk5ICITqVFFaYLYUzmlEqRBypS/MrZUP7YWgT4gEWinI43xCLFQD7luY8rIBH5Zq/VR/ojpWJFLHYissiP8c+8mkr5ds4UGJaFOK5+sSWVMinmzUPTLSLHUc8mySUfC9utekiZvNkjLapXDH5c40749uUYQegbT2TSPWUpT/WveoqgYdhqnw6kV3f8QPYxEVzfQGllmDds8irzoauUP+QMk+c8fW0T/xsH78Pz9iLDahDOMYtItIqN0pZ1HIPhXTUB4CSK9VDEYuKK/p19jGnBcM7lIEkaQSQdiLMDH2S0N5x9g/FEMAvX1qdS7gQBUAEPJEVL1iShz6Hq7GV26PIrpncy/ZNyfxZ8PAm+Z03OqzajHWcDqZK87rt2X3vPnGQ7ra5YUbN81jFYkHvHkMfdCnce5QQ/ccSMH3hkkYnoAFVX3E5kEP/nFQOOOgJe5fTv99kkqJElTADWYdVSi7aTO9EUlQw6ejYSGaIF+JGKHq+tbpkjvKGnpu8SqNWRX/+fUQSJtQ0HL9adcmTkHOhLck5C7nfaeBAXVD/N+6j7gXQ3FILwIF932hcrqdVvNNB2zXg1Y=
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