X-Git-Url: https://git.squeep.com/?a=blobdiff_plain;f=src%2Fdb%2Fpostgres%2Fsql%2Fschema%2F1.0.0%2Fapply.sql;h=24e955dbfc0c26423e998eff3870067164cecf89;hb=009a27af38e750695d11e6699c1d20928ed5f73d;hp=2665882108cef64db73e9293442edac259020cff;hpb=a0d01a7dbd5ff438095980c491ddc548ee29e96a;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