Ys13N5JUGAuiMFvLnkMDvYNOUCvXyoZ+BB5FA4mqXDNQUIO/QJXL6OzHY7xnyNx9lQJ9oUxVO+1D5OFvM8eSoFJd6yaReyBx7WAB9qkXOa57A2tK+8UgePfAUs8C7mK5NiNmdYJNsoHkhRyJmcn+0BNOsLwGuun1sLuxfGPSxHxkr4v/tV01pqYKPcV8CU8b31EFS+65y7WvnDzDxqfqDNC048qKBoxb9Y41w/R+2glIpNqt0xORTIMXhm7mg6Hmo6vRSXvN2EDsBw8GMmMGhVG48ckeaTnhV6ITyxHpx8zCZtO0Z5rpAKM2fDLJFvd53E//G+gYOWToVtmQcQhqVy3/frF6kGzrrFWi4gRZFe7hppUxz0ceHO5kQs/ovbrxVdkxqvp3IQaBheqpYul1uhe+N7dcJtTyyIOCgwVEwiF72t0us/TBviPDCRAdaOvtYXHtmTO+IMCWMsZuP5/a1p4Bd9n+8eEU9kP3V2pPNJWYZ+22ejBeIgGEn+0hBEksE0q0KZO5439Se/rUD1MPAwJVPDTzkuX5q3RMJVfEqv64xXRIxbeFte001UZZkLuR79Q2bN82Be7Sb4Ws2vaAzOU6H7FLCPvbakjMpkJgjKCEnQl6PuXXlzNl24U/0023eZSZLmUZmA4S/M6bBo+j+mtphEsent0xwLFKlIDvEnglDI1KMccONrWJdkqZiX/2kxRpPVcaW14yOoIXkK52ALyh/VwkvsdqALfX+/9OjiKp2V0No8wQLu3GwG9PtI8SUnfX7mk9ku3QBjYsEpDTW1b7rGuiEXmL3uUEjv89ZNe6Hy1mpR/tDpPOmXOCAApRpB9KWdXvn+YbUabI2nF5sgVW7xmede5SCX4PAlsDAaVSqecg3psFIcWNz3y7+K2J9N8TyqxhNfKL+3Hqtmhs9IepSMA0HkS9bwqPc42rj0QZr180al022S8VIBpyAyFDtYS12sMkWq3os8n/keOWaGf91ruM/VCICBnejKofOaQwNbitytbkc+jbE0qXWc0Tb9NHooDvqQokyhgnz+cyiCQlFUnomU5RE8SfZ2gmgiED/6XIvYhXfJLi0zPSFZ1BHVXn24jg/gBh+HnVdnyIrDT9R1hUK+rFA+ikdqkF2sKEeZkP2yd+3H7Jsy8I+qdgvAMtFRTQv+qufSYGh52+KRmZ8xTkG9D9Dkpsrvn+f0WcET6WQFHxexgfFVHA0qbBYSOCSVsvUy40fpzwxCTDdNsyN8mQ7RPdlOvC/YPKIp3NJEPUZY3zHpfctY7hfvDZvTj2Hn0zX+L5COuMX7qMPu17tLPzjmUH/pugIbHURmWXA6TMIe8XZPx8IfKTX5qi4lveAo58Z8flJRM0dkVfbFwrjlaCGo4/zPJ9Sik=
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