CxHimrCloGoo8fBe1/umJ9hEU+YRImeOo+gjEx6Pkm+wRfW+2j0BhHl+CG5a0kyVWj51niIFxMAV2+/4/AJpsnTt+mEY1FmFeWOFzvM9uEhDtgd/Y7a7XYGJSA6lNlLD9DZnOkmQH9Yg1mVzO8qSe0LqxA7XVcY/Hv8ODKP5joT0i3C5w2Q6ZqhQH7txZiO+V7ZT5mn/Yh9haGkMxnL/ywYdXHdIqlDTLfVrPJb2ynnlvBPm+/W1nU8cwrEmc7xh0Jlyvasy0xPHDArTuWFrjwCwRXmnkcSLaupb1e0ZOZtatOoAJUIJOxinQQj4YRMMAMylIE0PTCxIx0jNfA19bZKISqJIFPirTYg5dbUCTfslhx0RWO85/hyg1xRhkDHHYQ28Rel7lUTTC7GDlDn5yUYkX3TU5Z8azAiZueA34hTM0jFuWM16XBLAkWa7oICCv1+2a2EFfGvKaqfzh5EzcLjCSAXOe2RK7v3EzGIej4Buvfoj5+bLW2DM45qUNtimOMLK0xkqWYpxSj14piop63hymmnMmV4GV9fsm7KZfngSQEEn88bQvR4JlVeS23+zGW6JuMS3hcBS0s+vtr+XvddeRRG0ybdFJXGFAiBNllEGMH0tmX7h2aUnpafi5k66XxpXidv9IGkwkvcBF5T5Z0YrE+yZ2rPz7cJil6JPjcMyzkUmALVqKB+V+Ka1NyTI66yovL6fexNmfn1EHdzHlcEUMK/dv1K5SPcjyfvB/5ydV5HFms6/AhotMtTIP6FBIshP4waQ0SLnB1x1wddXRfSA3vsB8IemeRK0RhzyW1XvfpHjCpI/F4i3aLzEZ0lunFWMIKQvF04UBQeBr9GMyDdOhQE9mtuwkl1DG0zSScI/BTxuKvqT1xMrcwRZlcDkp+1D6p5U8EDPmxNT+m7xIBb6ozdaWQW2e7+S2WURK0aAScZELrIHymnLq7J3rQ0BqsaQKCCL0B29GVIwkZnIJa7b788otzhIE0VAvIWBYRsTGApek661bcfCs+e7soXSsvFOf6cgA1ryayFxNztUD3ojMUVeZGkm1YqWQLFjDqrWkGjnkF8yeZtExenoEK9PibN7yoS/OMIx4AGLNeuiFA85x5Of4RhOyRhAVhnznVHS5GRbvCqcanXKrQhSiQT+G6A9I/3O701/mcm+1NMotJdl8TEXiFVUY5QJjd8OTt3qO4dgCdavBvrEz9g0B96QxcRHcvpzdIiyLdoKg1TVIyv+Q5gHUo6+LBj69EPgo3lNP3Z6o+KaiOuHfEuvZWKYFRGN8NTfG0Wbz1l/CURViK3GB3iNw4hLPrXsiE2mmPJF7XgBbmmE0sODaFG9BigAv/aoMP0LMplHd9CHGWX2oonw+ZGDP8FnLXp8B9M=
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