Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
Pyr00 wrote:Cant edit
I tried this on the All players report
This filters to hands where someone was dealt in with less than 300 hands in the database:
tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps where thps.id_player in (SELECT tc.id_player from tourney_cache tc where true group by tc.id_player HAVING sum(tc.cnt_hands) > 300))
but dont work :s, the tracker said like loading.. all the time https://gyazo.com/e74eea43296a970b9ea0a8e6cbd0d7a9
AND ((cash_hand_player_statistics.id_gametype = 1)AND (cash_hand_player_statistics.id_gametype<>1 OR (cash_hand_player_statistics.id_gametype=1 AND (cash_hand_player_statistics.id_limit in (SELECT hlrl.id_limit FROM cash_limit hlrl WHERE (hlrl.flg_nlpl=false and (CASE WHEN hlrl.limit_currency='SEK' THEN (hlrl.amt_bb*0.15) ELSE (CASE WHEN hlrl.limit_currency='INR' THEN (hlrl.amt_bb*0.020) ELSE (CASE WHEN hlrl.limit_currency='XSC' THEN 0.0 ELSE (CASE WHEN hlrl.limit_currency='PLY' THEN 0.0 ELSE hlrl.amt_bb END) END) END) END)<=1.01) or (hlrl.flg_nlpl=true and (CASE WHEN hlrl.limit_currency='SEK' THEN (hlrl.amt_bb*0.15) ELSE (CASE WHEN hlrl.limit_currency='INR' THEN (hlrl.amt_bb*0.020) ELSE (CASE WHEN hlrl.limit_currency='XSC' THEN 0.0 ELSE (CASE WHEN hlrl.limit_currency='PLY' THEN 0.0 ELSE hlrl.amt_bb END) END) END) END)<=0.51))))))
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 29 guests