Someone

<Stat ColumnName="RakePaid" ValueExpressions="SUM(pkh.rakeamount * (ph.netamountwon + phmisc.postamountpreflop + phmisc.betamountpreflop + phmisc.callamountpreflop + COALESCE(flop.betamount + flop.callamount, 0) + COALESCE(turn.betamount + turn.callamount, 0) + COALESCE(river.betamount + river.callamount, 0)) * 1. / (pkh.potsize + pkh.rakeamount)) * 0.01 AS RakePaid" Evaluate="RakePaid" ColumnHeader="Rake Paid" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="Rake taken from pots won" />
<Stat ColumnName="WCRake" ValueExpressions="SUM(pkh.rakeamount * (phmisc.postamountpreflop + phmisc.betamountpreflop + phmisc.callamountpreflop + COALESCE(flop.betamount + flop.callamount, 0) + COALESCE(turn.betamount + turn.callamount, 0) + COALESCE(river.betamount + river.callamount, 0)) * 1. / (pkh.potsize + pkh.rakeamount)) * 0.01 AS WCRake" Evaluate="WCRake" ColumnHeader="WC Rake" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="Weighted Contributed Rake" />
<Stat ColumnName="CWCRake" ValueExpressions="SUM(pkh.rakeamount * (LEAST((SELECT allmisc.postamountpreflop + allmisc.betamountpreflop + allmisc.callamountpreflop + COALESCE(allflop.betamount + allflop.callamount, 0) + COALESCE(allturn.betamount + allturn.callamount, 0) + COALESCE(allriver.betamount + allriver.callamount, 0) FROM playerhandscashkeycolumns allph JOIN playerhandscashmisc allmisc USING (playerhand_id) LEFT JOIN playerhandsflop allflop USING (playerhand_id) LEFT JOIN playerhandsturn allturn USING (playerhand_id) LEFT JOIN playerhandsriver allriver USING (playerhand_id) WHERE allph.pokerhand_id = pkh.pokerhand_id ORDER BY 1 DESC LIMIT 1 OFFSET 1), phmisc.postamountpreflop + phmisc.betamountpreflop + phmisc.callamountpreflop + COALESCE(flop.betamount + flop.callamount, 0) + COALESCE(turn.betamount + turn.callamount, 0) + COALESCE(river.betamount + river.callamount, 0))) * 1. / (pkh.potsize + (SELECT allmisc.postamountpreflop + allmisc.betamountpreflop + allmisc.callamountpreflop + COALESCE(allflop.betamount + allflop.callamount, 0) + COALESCE(allturn.betamount + allturn.callamount, 0) + COALESCE(allriver.betamount + allriver.callamount, 0) FROM playerhandscashkeycolumns allph JOIN playerhandscashmisc allmisc USING (playerhand_id) LEFT JOIN playerhandsflop allflop USING (playerhand_id) LEFT JOIN playerhandsturn allturn USING (playerhand_id) LEFT JOIN playerhandsriver allriver USING (playerhand_id) WHERE allph.pokerhand_id = pkh.pokerhand_id ORDER BY 1 DESC LIMIT 1 OFFSET 1) - (SELECT allmisc.postamountpreflop + allmisc.betamountpreflop + allmisc.callamountpreflop + COALESCE(allflop.betamount + allflop.callamount, 0) + COALESCE(allturn.betamount + allturn.callamount, 0) + COALESCE(allriver.betamount + allriver.callamount, 0) FROM playerhandscashkeycolumns allph JOIN playerhandscashmisc allmisc USING (playerhand_id) LEFT JOIN playerhandsflop allflop USING (playerhand_id) LEFT JOIN playerhandsturn allturn USING (playerhand_id) LEFT JOIN playerhandsriver allriver USING (playerhand_id) WHERE allph.pokerhand_id = pkh.pokerhand_id ORDER BY 1 DESC LIMIT 1 OFFSET 0) + pkh.rakeamount)) * 0.01 AS CWCRake" Evaluate="CWCRake" ColumnHeader="WC Rake (True)" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="Weighted Contributed Rake (excluding uncalled bets) (SLOW)" />