my $rs= $c->schema->resultset("TSeminar")->search(
		{ 'semcode' => $code },
		{ "join" =>  ['programcode', 'marketcode'],
		"prefetch" => [qw/programcode marketcode/], 
		"order_by"	=> [qw/semcode/], 
		"rows"		=> 30});