```sql

CREATE MATERIALIZED VIEW player_champ_counts_mv
ENGINE = AggregatingMergeTree() ORDER BY (patch_num, my_account_id, champ_id)
as select patch_num, my_account_id, champ_id, countState() as c_state
from full_info
group by patch_num, my_account_id, champ_id;

create view player_champ_counts as
select patch_num, my_account_id, champ_id, countMerge(c_state) as c
from player_champ_counts_mv
group by patch_num, my_account_id, champ_id;
```

2.4s:
`select * from player_champ_counts`

900ms:
```
select patch_num, my_account_id, champ_id, countMerge(c_state) as c
from player_champ_counts_mv
group by patch_num, my_account_id, champ_id;
```

In other words, just inlining the definition of the view is doing something different than querying the view itself.
: table_lock(std::move(table_lock_))
    , metadata_snapshot(metadata_snapshot_)
    , options(std::move(options_))
    , storage(std::move(storage_))
    , required_columns(required_columns_)
    , query_info(query_info_)
    , context(std::move(context_))
    , processing_stage(processing_stage_)
    , max_block_size(max_block_size_)
    , max_streams(max_streams_)
{
    
    
    Pipes pipes = storage->read(required_columns, metadata_snapshot, query_info, *context, processing_stage, max_block_size, max_streams);
    if (pipes.empty())
    {
        Pipe pipe(std::make_shared<NullSource>(metadata_snapshot->getSampleBlockForColumns(required_columns, storage->getVirtuals(), storage->getStorageID())));
        if (query_info.prewhere_info)
        {
            if (query_info.prewhere_info->alias_actions)
                pipe.addSimpleTransform(std::make_shared<ExpressionTransform>(
                        pipe.getHeader(), query_info.prewhere_info->alias_actions));
            pipe.addSimpleTransform(std::make_shared<FilterTransform>(
                    pipe.getHeader(),
                    query_info.prewhere_info->prewhere_actions,
                    query_info.prewhere_info->prewhere_column_name,
                    query_info.prewhere_info->remove_prewhere_column));