# HG changeset patch
# User jbe
# Date 1459709864 -7200
# Node ID 10b90162e982b9ae6028ba5d21632a3c8edcee25
# Parent  91e3d31c1de21ce1bd2d4dfe5704252e060bf84b
Corrected comparison operator in view "newsletter_to_send"

diff -r 91e3d31c1de2 -r 10b90162e982 core.sql
--- a/core.sql	Sun Apr 03 20:54:45 2016 +0200
+++ b/core.sql	Sun Apr 03 20:57:44 2016 +0200
@@ -2633,7 +2633,7 @@
   LEFT JOIN "subscription" ON
     "subscription"."member_id" = "member"."id" AND
     "subscription"."unit_id" = "newsletter"."unit_id"
-  WHERE "newsletter"."published" >= now()
+  WHERE "newsletter"."published" <= now()
   AND "newsletter"."sent" ISNULL
   AND "member"."locked" = FALSE
   AND (
diff -r 91e3d31c1de2 -r 10b90162e982 update/core-update.v3.1.0-v3.2.0.sql
--- a/update/core-update.v3.1.0-v3.2.0.sql	Sun Apr 03 20:54:45 2016 +0200
+++ b/update/core-update.v3.1.0-v3.2.0.sql	Sun Apr 03 20:57:44 2016 +0200
@@ -285,7 +285,7 @@
   LEFT JOIN "subscription" ON
     "subscription"."member_id" = "member"."id" AND
     "subscription"."unit_id" = "newsletter"."unit_id"
-  WHERE "newsletter"."published" >= now()
+  WHERE "newsletter"."published" <= now()
   AND "newsletter"."sent" ISNULL
   AND "member"."locked" = FALSE
   AND (