Now its working fine and returning the correct data, since before, it was filtering with 2 HamTeamsID parameters

So for example it was trying to get HamTeamsID 1 and HamTeamsID 2 and as so, was not returning any results