X-Git-Url: https://git.squeep.com/?a=blobdiff_plain;f=src%2Fdb%2Fpostgres%2Fsql%2Fschema%2F1.0.0%2Fapply.sql;h=24e955dbfc0c26423e998eff3870067164cecf89;hb=18eee8e467173aee380bd0727d7065469e706727;hp=2665882108cef64db73e9293442edac259020cff;hpb=9696c012e6b9a6c58904baa397ca0ebf78112316;p=websub-hub diff --git a/src/db/postgres/sql/schema/1.0.0/apply.sql b/src/db/postgres/sql/schema/1.0.0/apply.sql index 2665882..24e955d 100644 --- a/src/db/postgres/sql/schema/1.0.0/apply.sql +++ b/src/db/postgres/sql/schema/1.0.0/apply.sql @@ -174,7 +174,7 @@ BEGIN; SELECT * FROM verification WHERE - (topic_id, callback, created) IN (SELECT topic_id, callback, max(created) AS created FROM verification GROUP BY (topic_id, callback)) + (topic_id, callback, created) IN (SELECT topic_id, callback, max(created) AS created FROM verification GROUP BY topic_id, callback) AND (topic_id, callback) NOT IN (SELECT topic_id, callback FROM verification_in_progress_active) AND