projects
/
koha_fer
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Bug 11030 - Add 359, 947 and 969 fields in french unimarc_complete framework - followup
[koha_fer]
/
C4
/
Category.pm
diff --git
a/C4/Category.pm
b/C4/Category.pm
index
fcb3ed8
..
255db2b
100644
(file)
--- a/
C4/Category.pm
+++ b/
C4/Category.pm
@@
-79,7
+79,7
@@
sub all {
my $dbh = C4::Context->dbh;
# The categories table is small enough for
# `SELECT *` to be harmless.
my $dbh = C4::Context->dbh;
# The categories table is small enough for
# `SELECT *` to be harmless.
- my $query = "SELECT * FROM categories";
+ my $query = "SELECT
categories.
* FROM categories";
$query .= qq{
LEFT JOIN categories_branches ON categories_branches.categorycode = categories.categorycode
WHERE categories_branches.branchcode = ? OR categories_branches.branchcode IS NULL
$query .= qq{
LEFT JOIN categories_branches ON categories_branches.categorycode = categories.categorycode
WHERE categories_branches.branchcode = ? OR categories_branches.branchcode IS NULL