LGOCtQISOwvRHwLHSAy5Wgo3od2pabqtC18Kbkf0xXYJXmj2ZriKWBQQWkxd4YjJOWwkS7gei3ygRPNGeTfA3CX5r+ExInCvwO0cH7OhV2t+PrRwCChRQGiN4B5rp/eDCG8UWm2vUEU4JQlkdtMW8ktGZrw6YN0H11/Gj9Ybq/gYpzpX5l30TUgOnSfF8bxXgWbJRNCBbZtyWwzWaOP91EP9nnWWrz+HaGxDKo+pbwTgoHd8P91lwIrPK06bTPfv5PpCJIKjmXYTWfy5+OXRWXxKLudKEu0WyenUyV2kvxwtdIBcek1+MyatACu7KUd7iaB4cTjM9auU1r08cX0XADStQqMJcy0jgPm4QCoJSpg0famVXlo1zcnYz5CP7dlG/jzjbmzIZgsV3r5UiHbGTPQqPkTEDTlC95y6aoqzwSZJKABg1NxfasfTbe3SAd6R9a+Odh1c5QjW9DclX5IrT9Y5a6mV6CWSYWQ2kR3IhLATsC07K7Cis/vU4HhPVhYW4jpLEvhNgUHJKYHJRYawhAWACWtwFE3E+W1FoueA4NbOfW5Kc0sGnycFwlfSbpJAG3gSfsJI4DXE3u1mcuB+dyuQcrPyaS4d22eIUyinhWihxwtkkAlRdo14tL7j4bcrfOMctgSf0U2on8SAPS0zF4wN8PTQn7FdB3OZ5APX7sukcZUIn90W2sLYY3JAv/bpi3AgnlNkImjxLjYTnRQulALALDiiiNASZrJdjEE714AH39z8mCHiqveIhkjuA9knDcviRShKVsJ9NjrhnrX8WdjubumJHkRJWn0g9XYTzD49I3rComhQ5piUCI3bhscIMjpo+HB/pRvatPHDomf+IeECeNlGxGzu/br0enRl7j7gv4JJvCHUJ/5oHXroHce3M+ZIbFbj79N0/3MhzkKerqoJvDqTXFJ3EgxOPzmWe1aj8KU826t6vSafkK6su4QvGQS8mbhGLzGaIamFHyloYry+cj1iWR1pGlYzH4XkhJ8eVjYX+JxDti+tjGDOcokABl4wfAhjcPClaFdAwpByCpY+sAJTuR1uqcn5cOXSTFZ3Pk3G8+SyZ/k7qOVlKhlLEHPORZSMmqtF/Xf9Z1GfuRHyLucT/jML6P6r+3XumpUAE4TFm/vO7huJdGg162Cbsmq5mLQvd5ANtDGArJ3pmkRMaJjmzWS8zB/SP657rAkbBeGq4U1ouPkkj3uBTpwkztHyRGzva1gK5UhpUcRrm87XSiBzV5vrNtaOIzHhKSZWoBQeQoDvunOy/+FXqo//J5cizMlcJCeWp4TZuejGDHm2XQzjIrkV4aOH67+YmyuYXOBRZuzNjLMXkTFtXAk8rl4PqsdUbWLDneZw4q56Yss+tmT1xlmni/Ir5ps=
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