PlayHQ Player Performance Statistics Data Table Joins
Primary Table:
- HP.PlayHQ_PlayerPeformanceStatistics (PP)
Accompanying Tables:
HP.app_Competition (co)
o PP.CompetitionGuid=co.CompetitionGuid and co.isdelete='False'
HP.app_Grade (g)
o PP.GradeGuid=g.GradeGuid and g.isdelete='False'
HP.app_Innings (i)
o PP.battinginningsid=i.inningsguid and i.isdelete='False' (PP.bowlinginningsid, PP.fieldinginningsid)
HP.app_MatchPlayer (mp)
o PP.MatchPlayerID = MP.MatchPlayerId and mp.isdelete ='False' (PP.WicketBowlerMatchId, PP.WicketFielderMatchId)
HP.app_Round (r)
o PP.RoundGuid=r.RoundGuid and r.isdelete='False'
HP.app_Season (s)
o PP.SeasonGuid = S.SeasonGUID and s.isdelete='False'
HP.app_OrganisationMapping (om)
o PP.[OrganisationMappingId] = om.[OrganisationMappingId] and om.isdelete='False'
o *When joining for club name use PP.[OrganisationMappingId]. When joining for association name use co.[OrganisationMappingId].
HP.ref_Organisation (o)
o om.OrganisationGuid=o.OrganisationGuid and o.isdelete='False'
HP.CRD_Organisations (org)
o o.CRMId = org.CRMGuid
HP.ref_Team (t)
o PP.TeamGuid=t.teamguid and t.isdelete='False'
HP.static_AgeGroup (age)
o PP.AgeGroupId=age.AgeGroupId
HP.static_DismissalType (d)
o PP.DismissalTypeId = d.DismissalTypeId
HP.static_Gender (gen)
o PP.GenderID=Gen.GenderID
HP.static_MatchType (mty)
o PP.MatchTypeId = mty.MatchTypeId
Example Competitions to Query
Competition Name
- CompetitionGUID
NSW Premier Cricket (Men’s)
- dd053832-27f5-4975-aeaa-2f1addf42be8
NSW Premier Cricket (Women’s)
- 8fb427f2-d42e-49d8-bcd7-ea9bf9e5c5db
Queensland Premier Cricket Mens Competitions
- 6ef7521c-430b-4729-9bf4-e97e4b36431a
Queensland Premier Cricket Womens Competitions
-265c1456-8e31-46d1-8968-4002184d4f35
SACA Premier Cricket Senior Men
- 83e3b236-77cb-4990-ae0e-4e05fba9a127
SACA Premier Cricket Senior Women
- bc995f8e-68f9-4d23-80a3-372be9dd4a39
Cricket Tasmania Premier League
- 1704a2b2-6890-403d-838a-96036433893f
Victorian Premier Cricket Kookaburra Men’s Premier
- 4e6db182-f08b-4330-b171-e682fc0cdf01
Victorian Premier Cricket Kookaburra Women’s Premier
- 8bc0d5c1-8208-4262-b32d-b5ab0f331d06
WA Premier Cricket Senior Male
- eed0bd3d-7e01-433c-a4d4-cd06d0ac754f
WA Premier Cricket Senior Female
- ff30b562-a366-4eb2-b664-23376a009526
0 comments
Please sign in to leave a comment.