Lines 208-214
sub get_tag_rows {
Link Here
|
208 |
push @exe_args, $hash->{$key}; |
208 |
push @exe_args, $hash->{$key}; |
209 |
} |
209 |
} |
210 |
} |
210 |
} |
211 |
my $query = TAG_SELECT . ($wheres||'') . $limit; |
211 |
my $query = q| |
|
|
212 |
SELECT tall.tag_id, tall.borrowernumber, tall.biblionumber, tall.term, tall.language, tall.date_created, tapp.approved |
213 |
FROM tags_all tall |
214 |
LEFT JOIN tags_approval tapp ON tapp.term = tall.term |
215 |
|; |
216 |
$query .= ($wheres||'') . $limit; |
212 |
$debug and print STDERR "get_tag_rows query:\n $query\n", |
217 |
$debug and print STDERR "get_tag_rows query:\n $query\n", |
213 |
"get_tag_rows query args: ", join(',', @exe_args), "\n"; |
218 |
"get_tag_rows query args: ", join(',', @exe_args), "\n"; |
214 |
my $sth = C4::Context->dbh->prepare($query); |
219 |
my $sth = C4::Context->dbh->prepare($query); |