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

(-)a/C4/Category.pm (-2 / +1 lines)
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.categorycode as categorycode 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
- 

Return to bug 7919