0+FjkVyrtm3aacyrGyuNnNbLB05fbp3Jx2HcuidmB1uRio9/AaLfSs8kvGx7/4kLgl3UqxA+WVtQR7vabtJPZl+gNO47MP8VHqskjLFPuG17lgRUQycTR5EmtDV5HgAzHO3bKV49p+/w0ZMS6DjzEn6WWSb6jrk+/XQ0H3W4HVuLdDwJiEe9TUudOj5dhavuWMwTqx8rY6VPmzL12RnSrL+EjNIYFE+gckpKWyAcpOTit8lJpNjsPbPSAukeZX9wCSibOxYTPxJ4v0B632vLD2u8nXL5G05EDI8+g1scJadg9z0XTkw1XcmawEBk/cthle5Y9QimFWdqqsqHUV+I+TWtnmHrnqGmX2OX26s/pgztTkhpLRlPh46Y/avh32OMdXGv4b2+qoR7nu08aHizXB8yQc5Z2HBgAclY17Q+E1Fen9UC0oE49EVjwWwT823qjd0SaOX+Ad2U4oPsmkSoUicO7UGcfD3nlDvVKrJZ8wLTixvsaghDZxed89TnQqdqRJtTfj0KRzQK49EACUzipjlrdqAk5P1HdmCjC12+DHpwWkmVrJx3Tyed2vG977A9XKhmrlSnjjUD+2JxLYWbM2LUBnYn2XjonCXWdVRXbcdWeFlUZH2e66HeRLppZoJF/XO3CxPwgUIne2GZyzdB+XWVjiMoI/kb5w8fchjFP/TjWFD/BfFnRNdK7yJbBNXTWxa05Qo+C4bM8kWkNC/PwMuNNTxJuojB0eXVIB7q6UZNwf/6lqYmCx3veQpfbAy904XJZsnYwklsRFc7TnRizt8P3UbRjuGyag82DkCfflFudpBnbSpmTKGU6Vp8ep7PX0SJmb37t7XMwyLce/sLhfoAPQlAi2Rlh2s1sxFoGWOp9tRB988u35212HwkfOUTE8y8P6X3fvigqbW1lg4q39BjKGCxdDSS02wujGLtMwjKNsxn+LbT7YLQZG147Sc1kv/R1UecScuNMH9s053yI6THQXK3JVlvgnggsc0tczPuUG+7LvH6dAGUX+t/kkWnVJzjAQuJF991btlYt3sB5RDk8knePh55nkJ4TN+3WkSmBcn1Bm6oweYDtsWXksu96KWybnLHk8HJoRlBJGQbIs0vCDb1e/b8UuGc4RqYsi4WGstBG4lK7zKgt8frqipSEwVxQrU1dHtkTfoHX15MQPAS/zxzVJ4v6Yr4YNm9ZTSwqN2/qILuNadzw/EZxizytoCd6+GmnWkv6c4ITJBMMrmT5YRb54aRC+FQ8Dqlvc0NryunjUMHUkvNScLOKIxWpromyw3JPHLxv/R8pdnJZS8VUtvaDV27EB1ma4pucykNWV50pmstwAuGFMrUrQKoFLjcKnPFushYANQfcu01sR7RT4uHR2hA5qn6HfQ=
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