sub recursive_subquery{
	my($schema,$join_column,$key,$values)  = @_;
	my ($value1) = shift(@$values);
	my $sub_query =$schema->search({
		$key => $value1,
	});

	for(@$values){
		my $tmp_query = $schema->search({
			$join_column => { 
				-in => $sub_query->get_column($join_column)->as_query 
			},
			$key => $_,
		});
		$sub_query = $tmp_query;
	}
	return $sub_query;
}

##</code><code>##

$c->stash->{rows} = $c->model('DB::Post')->search({
	'posts.post_id' => {
		-in => recursive_subquery(
		$c->model('DB::TagCloud1'),
		,'post_id',
		'tag_id',[
			16042,
			190712,
		])->get_column('post_id')->as_query 
	},
});