1 files changed, 2 insertions, 1 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index 25ce6006..ca45551c 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -432,7 +432,8 @@ RETURNS SETOF cds_issuers AS $$
                          JOIN bbg_markit_mapping b
                          ON a.company_id = b.company_id AND a.latestdate=b.date) map
                    JOIN bbg_issuers USING (company_id)
-                   LEFT JOIN defaulted ON map.company_id = id;
+                   LEFT JOIN (SELECT * FROM defaulted WHERE event_date <= $1 ) c
+                   ON map.company_id = id;
   END;
 $$ LANGUAGE plpgsql;