Td00ahOpJJ245VONR3Cz/UmGSbiKm3PG2IVJFQeXeDupXVt0sCB+rnRPpLKxyPM35PDzTmwFjsZAeXID/+PzC4STOOb2KKTxWl9OmSU3SagsmiGqNonsPHvHPFaTgx3RkMFcNcvm2EnHhXL8mtcdDWmoM3HMuJ8Bq0ZQkFgMXiqreGZvP5rgX1EZvM3fjWVrbt6VccXbKWN00kYLcuFqRBfsxhz2l++J8ANHdocHBeb6hA7tutvvusZ9jqXVYbP9Wa3+mxNwgt7JuT/2z5DiKubcErL2zg+OPaTCis7/z13neFPS3bV+hjV/cn64T+G0CgKwjYbwme4wJt5feT4LUuPSc0VElGVjuG2MR2RRlGednsUqFtTJi3LRQO5k/cAcXLN0kKHDy3sZQXIBvUDpMew2kZ8FBUmXssBxoLeFrEzc0fmPoBPqoPQ4QQ9eUWHHHUuZNToMT0Yfgskf2DrPQ+NLQtHC2UosvpS9lVEGsHjHmT6aOlCme44+wxBlFzjOuG8x+iM2C/VlGspBJNAiHuqr3g6KuWKQbwV5/niv85LfQ7mNOgje+J9Ambzxm89JTawvy+VwYw3hjmwZZ0sGVZRpV2e/vtKUrmYJIVkLqWe4RAOsd5tPvE9TAFES0ZY0b9YVuheVUmRvPkrY2+6fLcJiKWclNYyjjGw2L8ZfM9XhIWYKPPbXHhyaV4Jtrn7pb679nL8xnQn/Pcj6XnBDpGPvB/BmmnSiYBavSNqtPg3ahQ+2TXRVH8Zj06iXdIz7aOIK4qvZD4zbkIAaiz4oYNMWTSvdss4ao4UXaqYKd3k1jHKKVgWLvcTmVeIrXhXdWyMZketMCw/KpYllPEO94ZJzZH2OOVXyfL8UUCz+7L2M34f2OGonkv/MTkQvQxHyUvvzWwyf7WCLG7Ip40uNzqKKVypEWI3LM3XWbkpuF2tqKPH7sl7WCz+kKyFUDcJo/8TCMJ2XFToN7ZK6iPxtOaXOdm3p8GHU+eCFLCWqzgVy0feyRT790RVZ5qyt9bGO82N3iqe55BCx+fLuhffik2Kb2TL25GXNJs5i8KQWDiHEjYsyv8In95qBRUhSqUL9PsIkgWCRgtI4b1/AjpA7UjQeJoqQTOaBimjdFnMeEX4TBSZCWjlCQ7svWKRB7kSVH7vPpneIxUaVZdpkxcdni8/N+vRxlZboCwvsrlizkm74n2TZydtrAbMMr/jWA8OwWOPPhfWVPsHHb8bafESqo6ACi29X12k/0cZoU3io1iZQoom/+QfCneshKJtuI/F6ku1nkwLlSm7NXbZieX4RHq5l7SiX2ccYeVmZBkUWuveWFoTeRSkzLxkl8AquxSYP+xxB3wIs7HNWGSNHMpPXt7R9zi7LKYoClq+51a4=
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