public function bodyType($type)
    {
        $tableSpec = ModelSpecies::tableName() . ' spec';
        $tableCarcase = ModelCarcase::tableName() . ' carcase';


        return $this->innerJoin($tableSpec, 'car.model_spec_id = spec.model_spec_id')
            ->innerJoin($tableCarcase, 'spec.model_carcase_id = carcase.model_carcase_id')
            ->andFilterWhere(['carcase.body_type_id' => $type]);

    }

    public function transmission($transmission)
    {
        $tableSpec = ModelSpecies::tableName() . ' spec';


        return $this->innerJoin($tableSpec, 'car.model_spec_id = spec.model_spec_id')
            ->andFilterWhere(['spec.transmission_type' => $transmission]);

    }