From: Owen Leonard <[email protected]> Excluding entries in old_issues which have a NULL itemnumber
Signed-off-by: Magnus Enger <[email protected]> --- C4/Members.pm | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/C4/Members.pm b/C4/Members.pm index e03b40b..3185686 100644 --- a/C4/Members.pm +++ b/C4/Members.pm @@ -1115,7 +1115,7 @@ sub GetAllIssues { LEFT JOIN items on items.itemnumber=old_issues.itemnumber LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber LEFT JOIN biblioitems ON items.biblioitemnumber=biblioitems.biblioitemnumber - WHERE borrowernumber=? + WHERE borrowernumber=? AND old_issues.itemnumber IS NOT NULL order by $order"; if ( $limit != 0 ) { $query .= " limit $limit"; -- 1.7.4.1 _______________________________________________ Koha-patches mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
