ANt3znNxLgujwuwWw6c6h2roKmZU2SE0KpUL5/lUNAXjQpPxBPppAf7y5cCraJf/NeGGhMyxaK43+zgxrMnY0f660VYiMxe/x+wOsFdKGN3+x8XClF03Mn5j0U2uo/4xv87FJDJJnJZEd7UE27tXidLOHNUMdHBPNn7bnziJfEVghwqrsVW6MFRwGDlWuFeWvNHAviACEOHLd74y137tHoNygB79z3VQgKtDhan3jv7gC5tM3IUrVrLqDptwTF+5ASBOMQfQtE2hpTYIOLtaphxypokSmxeS6b2iGmEBo+MM1ECF2S0i0IfR5C+ToEl8XoBMOfZkCpd7L4zCdxkYMeM+66qLqLB4MyFNvfqYdM5lYWWIRaG3lImpNoR1KSYg66rDZEBckAnsU2V58PMwZtp933KGEk6ijP3HXJzOkVNadSOxd2KU7uLX9bQj+iPQrBZAwqrdDJBRApRwuizcvFyC5z1xSTUJ5ZK+KAJDWIfjh4ozEQatvGzagpO7mP0hnWuZ/UU9LetlBnruEja5IVcu8KYuAfYjEK1MtPKDO6wY3P+03C7DSmkS0ZJVU741onyBPoA6JouqvGVI6ANQhwm1E9EB2XgpPqdfcNyLIdpRyyuG9CsJds69iL69ub/KifGDCOqivJwpBF079o+89LDpjrqnBGJr5yhlhseyWfpvxvoN5KjSIPbjWkgLeYyD0DV8v07Qje03ghrtulgkjM4gwq3+dpiTZ3r6DEokD2M37ERWU0tgenzK4mmMdnAFVKYD8rAEIBtiHyxlTRaksAp25DLEGKuZjNyouQZEhUOzD5d3bpmNZpKMzbEJtjbCLaGp7nGwuZlKk+VUiJmlv09GqYhkphSdFIGAa9YyTaoI/Qqe2nSGS3OmqMwvoSd6oopYLigbRwMm2ucOUnjX5tbVRQyVF0/pg1I8C/artbifotCTeoEdiqbu3S9X9O3WQO7sDHJgRJ7JuDIPKPDYYNCUbyUl+n5RWYq2JEvc2mp4wiTARgVW0mn5lkmQT3S8KuTauI97Wz/eU76Ihs7+wMHGSIrxV3sAG7zzDX9SXT4udfrVnrGbRVUGAbwcmv+fYco0wA9D68kdXTmPHv7Z7C+j53Fo1eK91E93hMjaRKvuIs6nxADZaWf9AQryTM+0Z77qlimU6ROni1M3qNZvl6vK3gk0hQluAuVtwVDLHsD+6CHNePwxvPa9J2WTyBPfAGhi4qPXuXsE0TtOaI+v867oQgHDkCAMrgNpu9MoZfjCDmH3GXWgXhFhD8jN907a07uEnicL3Q7tJwKZdCSJmwVwCcIloHXnOiNVsssstgF/GayWS419IFWls66MRDzVusnRIlBC9vW6odSMro33YVSZZmFoPrUgj4AenDI=
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