import sqlite3


def get_top_ints(guild):
    """Find the top 10 "ints"

    Args:
        guild (int): ID of guild

    Returns:
        tuple: Top 10 "ints"
    """
    
    conn = sqlite3.connect('jit.db')
    c = conn.cursor()
    
    c.execute('''
        WITH t1 AS (SELECT * FROM match WHERE guild == ? ORDER BY deaths DESC, kills ASC, assists ASC)
            
        SELECT * FROM t1 LIMIT 10;
        ''', (guild,))
    
    top_ints = c.fetchall()
    return top_ints