[Custom Stats] How to differentiate hands based on pokersite played ?

[Maedinn]

I am going to try to explain what i am trying to do ...

I want to calculate a weighted sum of rake base on the site where i played.
Unfortunately usual tables ph or phmsisc do not have the site_id so i can't just do a "ph.site_id". I find out that there is a table named Pokersites but i am not sure how to use it ...


Basically here is my CustomStats i would like to do with an error :
<Stat GroupName="CustomsStats"
ColumnName="TEST"
ValueExpressions="
Sum(case when pokersites.abbreviation=PP THEN ph.RakeAmount ELSE 0 END)/100 as RakePartyPoker;
Sum(case when pokersites.abbreviation=FT THEN ph.RakeAmount ELSE 0 END)/100 as RakeFullTilt;
Sum(case when pokersites.abbreviation=PS THEN ph.RakeAmount ELSE 0 END)/100 as RakePokerstars
"
Evaluate="RakePartyPoker*4+RakeFullTilt+RakePokers tars*2"
ColumnHeader="SP" ColumnFormat="0" ColumnWidth="*" Tooltip="TEST"
/>

I suppose it must not be difficult but i just can't find the right wording.

[Maedinn]

Noneone as a clue ?
Still looking for this information but i have no idea ...

[Maedinn]

Thanks everyone for your help.
The answer is to use PKH.site_id insttead of trying to reach directy the "site" table.

I found the answer in another question.
Thread can be closed.