$dbh->prepare( build_query( $dbh, getQueryInfo() ) );
$sth->execute( getQueryVars() );

##</code><code>##

$dbh->prepare( build_query( $dbh, getBaseQuery(), getOrder() ) );
$sth->execute( getQueryVars() );

##</code><code>##

if (@order) {
    $query .= ' ORDER BY ' . 
        join ', ',
        map { $dbh->quote_identifier($_->[0]) . " $_->[1]" }
        @order;
}

##</code><code>##

my @order = (
    [ Brand => 'ASC'  ],
    [ Model => 'ASC'  ],
    [ Year  => 'DESC' ],
);