|
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); |