{

    my $dbh       = C4::Context->dbh;

    my $patrons = $dbh->selectall_arrayref(

        q|select b.borrowernumber from borrowers b join deletedborrowers db on b.borrowernumber=db.borrowernumber|,

        { Slice => {} }

    );

    my $biblios = $dbh->selectall_arrayref(

        q|select b.biblionumber from biblio b join deletedbiblio db on b.biblionumber=db.biblionumber|,

        { Slice => {} }

    );

    my $checkouts = $dbh->selectall_arrayref(

        q|select i.issue_id from issues i join old_issues oi on i.issue_id=oi.issue_id|,

        { Slice => {} }

    );

    my $holds = $dbh->selectall_arrayref(

        q|select r.reserve_id from reserves r join old_reserves o on r.reserve_id=o.reserve_id|,

        { Slice => {} }

    );

    if ( @$patrons or @$biblios or @$checkouts or @$holds ) {

        $template->param(

            has_ai_issues => 1,

            ai_patrons    => $patrons,

            ai_biblios    => $biblios,

            ai_checkouts  => $checkouts,

            ai_holds      => $holds,

        );

    }

}

        [% IF has_ai_issues %]

            <h2>Data problems</h2>

            <p>

            The following tables have problems with their auto_increment values which may lead to data lost. You should not ignore this warning.

            The problem is that innodb does not keep auto_increment across SQL server restarts (it is only set in memory).

            So on server startup the auto_increment values are set to max(table.id)+1.

            </p>

            <p>

            See the <a href="https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix">related wiki page</a> to know how to avoid this problem.

            </p>

            [% IF ai_patrons %]

                <h3>Patrons</h3>

                The following ids exist in both the borrowers and deletedborrowers table:

                [% FOR p IN ai_patrons %][% p.borrowernumber %][% UNLESS loop.last %], [% END %][% END %]

            [% END %]

            [% IF ai_biblios %]

                <h3>Biblios</h3>

                The following ids exist in both the biblio and deletedbiblio table:

                [% FOR b IN ai_biblios %][% b.biblionumber %][% UNLESS loop.last %], [% END %][% END %]

            [% END %]

            [% IF ai_checkouts %]

                <h3>Checkouts</h3>

                The following ids exist in both the issues and old_issues table:

                [% FOR c IN ai_checkouts %][% c.issue_id %][% UNLESS loop.last %], [% END %][% END %]

            [% END %]

            [% IF ai_holds %]

                <h3>Holds</h3>

                The following ids exist in both the holds and old_reserves table:

                [% FOR h IN ai_holds %][% h.issue_id %][% UNLESS loop.last %], [% END %][% END %]

            [% END %]

        [% END %]