if( !function_exists( 'mars_get_user_metacount' ) ){
    function mars_get_user_metacount( $user_id, $key ) {
        global $wpdb;

        if( false === ( $query = get_transient( $user_id . 'meta_count' . $key ) ) ){
            $query = $wpdb->get_var( $wpdb->prepare(
                    "
                    SELECT sum(meta_value)
                    FROM $wpdb->postmeta LEFT JOIN $wpdb->posts ON ( $wpdb->postmeta.post_id = $wpdb->posts.ID )
                    LEFT JOIN $wpdb->users ON ( $wpdb->posts.post_author = $wpdb->users.ID )
                    WHERE meta_key = %s
                    AND $wpdb->users.ID = %s
                    AND $wpdb->posts.post_status = %s
                    AND $wpdb->posts.post_type = %s
                    ",
                    $key,
                    $user_id,
                    'publish',
                    'video'
            ) );

            if( (int)$query > 0 ){
                set_transient( $user_id . 'meta_count' . $key , $query, 600);
            }
        }
        return (int)$query > 0 ? number_format_i18n($query) : 0;
    }
}