@@ -, +, @@ record when doing full reindex --> without patch the deleted records are indexed and shown when --> with this patch the deleted records are not indexed --- misc/migration_tools/rebuild_zebra.pl | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) --- a/misc/migration_tools/rebuild_zebra.pl +++ a/misc/migration_tools/rebuild_zebra.pl @@ -480,7 +480,8 @@ sub select_all_biblios { $table = 'biblioitems' unless grep { /^$table$/ } @tables_allowed_for_select; my $strsth = qq{ SELECT biblionumber FROM $table }; - $strsth.=qq{ WHERE $where } if ($where); + $strsth.=qq{ WHERE $where AND deleted_on IS NULL} if ($where); + $strsth.=qq{ WHERE deleted_on IS NULL} unless ($where); $strsth.=qq{ LIMIT $length } if ($length && !$offset); $strsth.=qq{ LIMIT $offset,$length } if ($offset); my $sth = $dbh->prepare($strsth); --