X-Git-Url: http://koha-dev.rot13.org:8081/gitweb/?a=blobdiff_plain;f=about.pl;fp=about.pl;h=a814acc88f5a9a0cb29c855c8e28527651346c06;hb=1131bb687f14fef7b4cb5f3b194711e85f9227af;hp=992bc771f40b8b075121df8ab476e606761b5a24;hpb=1c3e7f78b536bd5103e8ae563a45872b85b531bc;p=srvgit diff --git a/about.pl b/about.pl index 992bc771f4..a814acc88f 100755 --- a/about.pl +++ b/about.pl @@ -496,17 +496,13 @@ $template->param( 'bad_yaml_prefs' => \@bad_yaml_prefs ) if @bad_yaml_prefs; { my $dbh = C4::Context->dbh; my ($bad_relationships_count) = $dbh->selectall_arrayref(q{ - SELECT COUNT(*) - FROM ( - SELECT relationship FROM borrower_relationships WHERE relationship='_bad_data' + SELECT COUNT(*) FROM borrower_relationships WHERE relationship='_bad_data' }); $bad_relationships_count = $bad_relationships_count->[0]->[0]; my $existing_relationships = $dbh->selectall_arrayref(q{ - SELECT DISTINCT(relationship) - FROM ( - SELECT relationship FROM borrower_relationships WHERE relationship IS NOT NULL + SELECT DISTINCT(relationship) FROM borrower_relationships WHERE relationship IS NOT NULL }); my %valid_relationships = map { $_ => 1 } split( /,|\|/, C4::Context->preference('borrowerRelationship') );