5Z2sK1/8heQirgTMoIm+mR/4b4osgHbmSuyjXeZ6JX2XcWjPie8FnzSqvrCBqBiNz2eap3j84LSl0F4PA6mm1GPp9DApc2jiYyOf7ZI9N1XfcbIHUUqNdlv3VFwZlLB5NEELV3IJfejNN6+RPcxtnUPc3BrS4KT6LWPxDy4Au6TtKNtbmLCHgZe5023lv4LCE4tiyPsQETZOMLYm3rZKr5vR1eBVNKJSV385ndM49t81JXAN+Vbu4pGz8zlT+GDJB5cQgmIjDv9vHPYgeI4jw/EPQIXA95jX4x34Hm1SbTFUAt4ww83yJG6ZUGQyiylnlY5/QDRbJCECyBcduOiL3z9y6qOFEZeCvv+O4uVGoRzIRX2EQJ8iy0nBNohZehsCOMXqg6itjKXUOaMH/1sUP6M+KAReoO4uGmFZhcpQsYPgqb50Vjo5gcgCd+J3XHTPNpitKGehef0pF98oHUhoe13kssUenc19iuQLDKdPF7ePUn10NLkH2ghC7bQlFzF7ZC8Vju56UpVoRwNU2pPxilc3ExtlicaB1fRCo2JNB548n3XL8jzCCLmTurmrEWQkqe8iKbTar2hsfDQ/3qy/u/01ylUeuqYp8+6TeO49CjDFJm+pA+4iIHQiunMiQzG/4lOpHnwVCKAkClahGvsEzdlbw+TN/YNGW+N7YyU7qIhM0vJWDNGGy13Y1HLB4bDTmWnzfnJ6X4lM3XZVJrfi2RrgXWFTMRMpsnJjQBKpOHeTYJc1W+xfyK9nIVhNrF4gGlHh7vnnZsBviFco7JegNRB7zSJLLafagLJ+yv8XofamCtnffFuKCT3bJrlN92xYWPVXoM/RwWUlwT4TzID4blW735Lm07ovphkseSLHSw5QfwtiBN7A/6HjVxpGBJq1uN0bnvtY7yxLrUQccDOeYaMdBDx9FyngG28So2uw4ak0+97ufBmbvXSyEdRgUmu4W5NxkmSKcn6SYyuXKXLiK06GXfNusulTut8IHBO2XV2dKJzVgUPw0MrqlNcbIPM/WhK0D8vPzKEvEUKyOIzp1HIM1mzDKZ6Hc4IWgwGx6/5wOpazKpQAr1dBwktcGsj7M2k2BKA3S47BLoksKV9wuLFIv3IhvxFbp+qAK2v3JknYGpz6tqIQXy1v9duVFQTN8jI+6/t90F0FKtnmstsirNU6iE+6h5huWUPcjlltt0z6tB5N0Kq4G/9bd+PQqQn5g/6iPlwdLwlE3+WJh13FVXD5YxktjETgtH1iAdHhVHRB6OKMiMY76QSR0bBfiG7e8EKuqgMDOo5g4PkKbzN5p3sHB/3pn/ewK7usSBZqeEMswY6IRtFPpPbqjATC9k6IdgOQXhQ/UVBF2icgFKS3+/JG2FEW8Rj+BUkzhx0=
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