0FXyjDRJ/V99f/gQsTpFhZDsTHdhqCBYHDZPM4wR0vYnJAI6Idz+tEGlLQMAmc8+xPaaKBsv2IErqF/iydGt2Y9mKJ1xIju9NqCfhHvzir4WkwizvOD3Iu0/KRq0EUIYzU+jaKOCuoNzoFmD/84202lF2g0hz3Z+nv3STdbeG4u+3VXATd8e6jpqQrZJ9MxYaEBZX1Vf02ARrQULuUYe8cAmHspVNSRZ+clp81ZvQ6v/Nh8kVp+yMXTzvx+mSks3RkrMeElt6yMDREhHombM/D2xkJs82h06T362PlCc+YzSR+yF6NNxsmxF/DbbXlelApJMtUjf4iPVIjL9xK5ZNVemIcUcP731Z6QDI6FghTikU+3nvfIudLvSrBbOyyxCy5qVNHSxC08l7had0o8DHCpLbofMJE3hHBaFQKotmLd4SbVG7uP5Snc5u9MVFbHTp3oCRy1oR2aq6QRU2Kq08iCDJNLf3n1+MMuv2e6JTfCtjTBRyUkbJDW5zx3wpc7ihFlwTvB87qrqpNulUqT1swlKafzBkLAfXB0iKlTzidtGYBFLb/XA+3xiMvjGK//gGiAi/T+mIfdI1EAn35H0NNtoc1qD3VWosdPKPbd6HeKmqhe9k3pAWf8wp3OnvSl7VagEI2U3NkGODS+yx5+8C4ajMCi81rSaoAn2zxPcXWCM9p96/rjZ2TkHJ9qnHzhtGlPO6AS4uIEVzI+fTyfOEjatKYjIBlcpguaLW5oq00rNwhaqmMibfqInGAUcnwuvvbPrr1+brOyHoj4c5xDIoL/lK3MR0QSW5YIJxsnTxTjZz1Vv0rrmCWV37iRKhJ4JGp2Z3QLF9EYBlJ0ulipp+x8KFkOofJZ2O3PSKVCGN/R9bNhQFeZdL3fi8zPeQWa0aFRA7uktkM62+tDeUUJFmA/oPI7P7uCx5eJUSLuHEMoEYOT5r/Xla+JDktP/ZOmW92uc8tADCOfe5ejp9IjHwHDQNJKTwK5W/E5RPT8kal3uOiEH8/rHDtmSS1E1CBKbZ96RqbkL5iQ4rZ5MSQ9NkXQvdG/xM3z7xgEoc9k+0AdG/q5TzmTED2MfHPwNHH+9jV1zom0h1QzJbgVyerZTa0gLqsJHP14W7RcFHkNFVGb6ybWW79wfRLQr0XwNd3SWpbDWy1ix29PXpYP4hSnhoaKJVZsIcBPZQjKLChQvSYrp2hOcsJhD2iAp92DTD8Z6G1PxGuFY0XtigyM0vpWbW2i63gFQwGBB8EsDO8LkVBi7guWkbDKrJOR8utkf1AcwZjeAM7Nr5SMvTak9dvkvScN0K6rUnAFXEJvxULwiKmgA5jaiqoTHLbYV96fAhZJleuebvvVy1BepNwu+dblmaS5ODuaZVQvxa8YV0l0=
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