View | Details | Raw Unified | Return to bug 14272
Collapse All | Expand All

(-)a/C4/NewsChannels.pm (-2 / +6 lines)
Lines 126-134 sub get_opac_new { Link Here
126
    my ($idnew) = @_;
126
    my ($idnew) = @_;
127
    my $dbh = C4::Context->dbh;
127
    my $dbh = C4::Context->dbh;
128
    my $query = q{
128
    my $query = q{
129
                  SELECT opac_news.*,branches.branchname
129
                  SELECT opac_news.*,branches.branchname,
130
                         timestamp AS newdate,
131
                         borrowers.title AS author_title,
132
                         borrowers.firstname AS author_firstname,
133
                         borrowers.surname AS author_surname
130
                  FROM opac_news LEFT JOIN branches
134
                  FROM opac_news LEFT JOIN branches
131
                      ON opac_news.branchcode=branches.branchcode
135
                      ON opac_news.branchcode=branches.branchcode
136
                  LEFT JOIN borrowers on borrowers.borrowernumber = opac_news.borrowernumber
132
                  WHERE opac_news.idnew = ?;
137
                  WHERE opac_news.idnew = ?;
133
                };
138
                };
134
    my $sth = $dbh->prepare($query);
139
    my $sth = $dbh->prepare($query);
135
- 

Return to bug 14272