my $check = $c->model('FreeRadius')->resultset('Radcheck')
			->search( 
				{ }, 
				{ 
					select   => [ 'username', "SUM(if(attribute='auth-type' and value='reject',1,0)) as rejected" ],
					as       => [ 'username', 'rejected' ],
					group_by => \"username having rejected = 0"
				}
			);