def get_all_published_ships_basic(db_connection):
    """ Gets a list of all published ships and their basic information.

    :return: Each result has a tuple of (typeID, typeName, groupID, groupName, categoryID, and categoryName).
    :rtype: list
    """

    if not hasattr(get_all_published_ships_basic, '_results'):
        sql = 'CALL get_all_published_ships_basic();'
        results = execute_sql(sql, db_connection)
        get_all_published_ships_basic._results = results

    return get_all_published_ships_basic._results
Gets a list of all published ships and their basic information.

    :return: Each result has a tuple of (typeID, typeName, groupID, groupName, categoryID, and categoryName).
    :rtype: list