Lines 79-85
sub all {
Link Here
|
79 |
my $dbh = C4::Context->dbh; |
79 |
my $dbh = C4::Context->dbh; |
80 |
# The categories table is small enough for |
80 |
# The categories table is small enough for |
81 |
# `SELECT *` to be harmless. |
81 |
# `SELECT *` to be harmless. |
82 |
my $query = "SELECT * FROM categories"; |
82 |
my $query = "SELECT categories.* FROM categories"; |
83 |
$query .= qq{ |
83 |
$query .= qq{ |
84 |
LEFT JOIN categories_branches ON categories_branches.categorycode = categories.categorycode |
84 |
LEFT JOIN categories_branches ON categories_branches.categorycode = categories.categorycode |
85 |
WHERE categories_branches.branchcode = ? OR categories_branches.branchcode IS NULL |
85 |
WHERE categories_branches.branchcode = ? OR categories_branches.branchcode IS NULL |
86 |
- |
|
|