1 files changed, 2 insertions, 2 deletions
diff --git a/sql/serenitasdb.sql b/sql/serenitasdb.sql
index 96a9d8c0..b6bae65b 100644
--- a/sql/serenitasdb.sql
+++ b/sql/serenitasdb.sql
@@ -686,11 +686,11 @@ $$
           RETURN QUERY
           SELECT * FROM tranche_quotes WHERE index=pg_index_type::index_type AND series= pg_series
           AND tenor=pg_tenor::tenor AND quotedate=best_quote.quotedate AND detach-attach!=5::smallint AND
-          quotesource=best_quote.quotesource ORDER BY attach ASC;
+          quotesource=best_quote.quotesource AND NOT deleted ORDER BY attach ASC;
        ELSE
           RETURN QUERY
           SELECT * FROM tranche_quotes WHERE index=pg_index_type::index_type AND series=pg_series
-          AND tenor=pg_tenor::tenor AND quotedate=best_quote.quotedate AND quotesource=best_quote.quotesource
+          AND tenor=pg_tenor::tenor AND quotedate=best_quote.quotedate AND quotesource=best_quote.quotesource AND NOT deleted
           ORDER BY attach asc;
        END IF;
        END;