2PO0JsdM9VA9+AUnYYYBxDvNyJZy9M/gRHkAW+i05CFmzf6EpG0t8Mc4xsTUJviNXI5GvLjc3bTTeGStHCFtGIxabNIU/ZTIONANVwn19ZKQA67feZenOlBtLLZvbPpwgecAN45izK88uNYaErvdVEBOfa/g0dPFDMSQdhKWvVYemDKneWyFQWz78sbNlhmJWj9oCv3jSTLFlu8y/pIbePVelTyH+PjDWr7df+tz0CfOEUt+M3PO2cLCesjOruEtYLBpWf1QWSwLuB8gZlc59eFwNOcW4vN5Bcm77/GeILjgbHtEB/GmHf/u0Xv8sa79yfVBsgBDF58BUJx5QAM5ii4yz8oaRU08TOpH7PD1pSlUtHAQ3MZQqH1KBStakhRKEWYmjuROL4sz7vCmmyReVJUim5p/WRs4zYNugikLtQIZrlOlmKdelNJfluEjZVKhlMF4VjpI2Jy0Ygfs/8kHcjxZo6r5zgZ7k67js4+S+OHkspIkYt5CbJ7RYLQOsCbMXjjuDISBhYlcAv9bF/KJ/L8be0JqHUarCzjOZxIsB6VzkrovfUBNe1FWZqKlLZTuSCHcbHZUa3vB/3mJSRbh28XFaA3zLh8eZU7vnLxDl3H/Lk6vQYIx+M8tX9gMbG/EnS7LPaBYnZ32ptk1R2Qb9QWSG1quZoZF9DsVqJcXWft78p755jzaLmBv1Z2wapev/dqChtY+sjMEDKzf1IZ1ouhcMa2Qk+XrrwmQ2woBh65C0iljKGYBZDfEx/Piu8cHV8bv+2zTMBeaGM2/8bv7cPNQT2ZyOra/uJpv8qX0R7viqgPah4JZwCb59iW+aHIz5xyJfRaum+Ap+6OmBtQBdTZgWiTqhjqcyFgFhHlXTnENqQZJWMrZT33RVwgxCMu49s7ohb7TdCxGPMntt9dLGK2pKlHMuQ71P3by8yl0AxHJh9wfTEG83XhcM0sqyGmkqkE4jLXFiHOosE9/HWqsX/+S0mJTfDCL5epB9yP7kRWggpn1XO7E/7DaCX5+ikLi2ZhWKN+MlBnMuhypMX3X0peJhVI19ahU0jZ6ERwpHaouGegVyzR+W8Og3zsHMKF09gm1JINzOYMugmFXj4O7d74O9Dgvwdm1o3jm9sYFhGB+0oBPoNWHkxwYGJU6A86XxnTuwU6rntDQhmSBLI7cmVGKbXSWcq+6Gc64zFB63gfEk4VURZeDbMusWIKNF+Z7ur8e89GQ1khTxaaW7HM1AkXvCcoIn8SzB8pX0jnff6E27EKA0rZ7ESkTEN/5tx1GGwsutocV7PdseyeMyBYX4mReGSNozyqgsKhoxIBmaL/LXROyyt5UObwr4KsZyFqSRekZ94B0M2YJg3F1g5po401Wk2o6HyucL/BOjcE=
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