public boolean getOpenTests(CommandSender sender, int pageNumber) throws SQLException {

        String database = plugin.getConfig().getString("mysql.database");
        Integer numberOfQuestions = plugin.getConfig().getList("quiz-questions").size();

        String query = "SELECT * FROM `" + database + "`.`quizzes` WHERE `applicant` IS NOT NULL";
        String getNumberOfResults = "SELECT COUNT(*) AS count FROM `" + database + "`.`quizzes` WHERE `applicant` IS NOT NULL";
        ResultSet results = plugin.dbManageMySQL.query(query);
        ResultSet numberOfResultsCount = plugin.dbManageMySQL.query(getNumberOfResults);
        
        numberOfResultsCount.first();
        
        int numberOfResults = numberOfResultsCount.getInt("count");
        
        int resultsPerPage = plugin.getConfig().getInt("results-per-page");
        
        int pageCount = Math.round((int) Math.ceil((numberOfResults - 1) / resultsPerPage)) + 1;
        
        if (pageNumber > pageCount) {
            sender.sendMessage(plugin.prefix + ChatColor.GOLD + " - " + ChatColor.RED + "That page does not exist!");
            return true;
        }

        if (numberOfResults == 0) {
            sender.sendMessage(plugin.prefix + ChatColor.GOLD + " - " + ChatColor.RED + "No Tests Found!");
            return true;
        }
        
        sender.sendMessage(ChatColor.DARK_PURPLE + "----------------- " + ChatColor.GOLD + "uTest - Latest Tests" + ChatColor.DARK_PURPLE + " -----------------");
        sender.sendMessage(ChatColor.DARK_PURPLE + "-------------------- " + ChatColor.GOLD + "Page " + pageNumber + " / " + pageCount + ChatColor.DARK_PURPLE + " ---------------------");

        if (pageNumber > 1) {
            int startRow = pageNumber * resultsPerPage - resultsPerPage;

            for (int x = 0; x < startRow; x++) {
                results.next();
            }
        }
        
        int counter = 0;

        while (results.next() && counter < resultsPerPage) {

            Integer ID = results.getInt("id");
            Date testDate = results.getDate("testdate");
            Time testTime = results.getTime("testtime");
            String applicant = results.getString("applicant");

            if (plugin.getServer().getPlayer(applicant) != null) {
                sender.sendMessage(ChatColor.GOLD + "#" + ID + " " + testDate + " " + testTime + " - " + ChatColor.GREEN + applicant);
            } else {
                sender.sendMessage(ChatColor.GOLD + "#" + ID + " " + testDate + " " + testTime + " - " + ChatColor.RED + applicant);
            }
            
            counter++;
        }

        return true;
    }