diff options
| author | Struan Donald <struan@fury.ukcod.org.uk> | 2011-06-01 17:53:20 +0100 |
|---|---|---|
| committer | Struan Donald <struan@fury.ukcod.org.uk> | 2011-06-01 17:53:20 +0100 |
| commit | d646c8512a4d5003075e7c10a4207dd5a383abf3 (patch) | |
| tree | ce41e68cc98ab17194fe98decbac60ed6faacebc | |
| parent | b3746b6d37d7214c016cf9f39bcec8847b379721 (diff) | |
only pull the fields we need out of users
| -rw-r--r-- | perllib/Problems.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/perllib/Problems.pm b/perllib/Problems.pm index 02ac2b384..432c89fdc 100644 --- a/perllib/Problems.pm +++ b/perllib/Problems.pm @@ -550,7 +550,7 @@ sub timeline_alerts { if ($cobrand) { $cobrand_clause = " and cobrand = '$cobrand'"; } - my $alerts = select_all("select *, + my $alerts = select_all("select alert.*, users.email, users.name, extract(epoch from whensubscribed) as whensubscribed from alert, users where alert.user_id = users.id |