java/code/src/com/redhat/rhn/common/db/datasource/xml/Task_queries.xml | 12 +++++-----
1 file changed, 6 insertions(+), 6 deletions(-)
New commits:
commit 06541d2ef7cb34674c76e1c45c3ecbc17d68e61f
Author: Justin Sherrill <jsherril(a)redhat.com>
Date: Wed Sep 22 14:11:13 2010 -0400
634230 - fixing slowness in email sending
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Task_queries.xml
b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Task_queries.xml
index 7d4d08d..9f48fdd 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Task_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Task_queries.xml
@@ -374,13 +374,13 @@ ORDER BY next_action DESC
INSERT INTO rhnPaidErrataTempCache
(user_id, server_id, errata_id)
SELECT urn.user_id, snv.server_id, snv.errata_id
- FROM rhnServerNeededView snv
- JOIN rhnUserReceiveNotifications urn
- ON snv.org_id = urn.org_id
- AND snv.server_id = urn.server_id
- WHERE snv.channel_id = :channel_id
+ FROM rhnServerNeededCache snv inner join
+ rhnUserReceiveNotifications urn ON snv.server_id = urn.server_id
+ inner join rhnServer S on S.id = snv.server_id inner join
+ rhnServerChannel sc on sc.server_id = S.id
+ WHERE sc.channel_id = :channel_id
AND snv.errata_id = :errata_id
- AND snv.org_id = :org_id
+ AND S.org_id = :org_id
</query>
</write-mode>
Show replies by date