#     my $sth = $dbh->prepare(

    my $lib= ($forlibrarian?'liblibrarian':'IFNULL(libopac,liblibrarian)');

    #         "SELECT COUNT(*) FROM marc_tag_structure WHERE frameworkcode=?");

    #     $sth->execute($frameworkcode);

    my $restags = $dbh->selectall_hashref(

    #     my ($total) = $sth->fetchrow;

        qq{SELECT frameworkcode,tagfield,$lib as lib,mandatory,repeatable 

    #     $frameworkcode = "" unless ( $total > 0 );

    my $sth = $dbh->prepare(

        "SELECT tagfield,liblibrarian,libopac,mandatory,repeatable 

        WHERE frameworkcode=? 

        ORDER BY frameworkcode,tagfield},

        ORDER BY tagfield"

        ["frameworkcode", "tagfield"],

    $sth = $dbh->prepare(

    my $ressubfields = $dbh->selectall_hashref(

        "SELECT tagfield,tagsubfield,liblibrarian,libopac,tab,mandatory,repeatable,authorised_value,authtypecode,value_builder,kohafield,seealso,hidden,isurl,link,defaultvalue 

        "SELECT frameworkcode,tagfield,tagsubfield,$lib as lib,tab,mandatory,repeatable,authorised_value,authtypecode,value_builder,kohafield,seealso,hidden,isurl,link,defaultvalue 

         WHERE  frameworkcode=? 

         ORDER BY frameworkcode,tagfield,tagsubfield",

         ORDER BY tagfield,tagsubfield

        ["frameworkcode", "tagfield","tagsubfield"],

        "

    $sth->execute($frameworkcode);

    return $res->{$frameworkcode};

    my $subfield;

    my $authorised_value;

    my $authtypecode;

    my $value_builder;

    my $kohafield;

    my $seealso;

    my $hidden;

    my $isurl;

    my $link;

    my $defaultvalue;

    while (

        (   $tag,          $subfield,      $liblibrarian, $libopac, $tab,    $mandatory, $repeatable, $authorised_value,

            $authtypecode, $value_builder, $kohafield,    $seealso, $hidden, $isurl,     $link,       $defaultvalue

        )

        = $sth->fetchrow

      ) {

        $res->{$tag}->{$subfield}->{lib}              = ( $forlibrarian or !$libopac ) ? $liblibrarian : $libopac;

        $res->{$tag}->{$subfield}->{tab}              = $tab;

        $res->{$tag}->{$subfield}->{mandatory}        = $mandatory;

        $res->{$tag}->{$subfield}->{repeatable}       = $repeatable;

        $res->{$tag}->{$subfield}->{authorised_value} = $authorised_value;

        $res->{$tag}->{$subfield}->{authtypecode}     = $authtypecode;

        $res->{$tag}->{$subfield}->{value_builder}    = $value_builder;

        $res->{$tag}->{$subfield}->{kohafield}        = $kohafield;

        $res->{$tag}->{$subfield}->{seealso}          = $seealso;

        $res->{$tag}->{$subfield}->{hidden}           = $hidden;

        $res->{$tag}->{$subfield}->{isurl}            = $isurl;

        $res->{$tag}->{$subfield}->{'link'}           = $link;

        $res->{$tag}->{$subfield}->{defaultvalue}     = $defaultvalue;

    }

    $marc_structure_cache->{$forlibrarian}->{$frameworkcode} = $res;

    return $res;