SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 0 and cd2 = 0 and cd3 = 0 and cd4 = 0 and cd5 = 0 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 1 and cd2 = 0 and cd3 = 0 and cd4 = 0 and cd5 = 0 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 0 and cd2 = 1 and cd3 = 0 and cd4 = 0 and cd5 = 0 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 0 and cd2 = 0 and cd3 = 1 and cd4 = 0 and cd5 = 0 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 0 and cd2 = 0 and cd3 = 0 and cd4 = 1 and cd5 = 0 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 0 and cd2 = 0 and cd3 = 0 and cd4 = 0 and cd5 = 1 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 1 and cd2 = 1 and cd3 = 0 and cd4 = 0 and cd5 = 0 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 1 and cd2 = 0 and cd3 = 1 and cd4 = 0 and cd5 = 0 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 1 and cd2 = 0 and cd3 = 0 and cd4 = 1 and cd5 = 0 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 1 and cd2 = 0 and cd3 = 0 and cd4 = 0 and cd5 = 1 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 0 and cd2 = 1 and cd3 = 1 and cd4 = 0 and cd5 = 0 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 0 and cd2 = 1 and cd3 = 0 and cd4 = 1 and cd5 = 0 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 0 and cd2 = 1 and cd3 = 0 and cd4 = 0 and cd5 = 1 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 0 and cd2 = 0 and cd3 = 1 and cd4 = 1 and cd5 = 0 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 0 and cd2 = 0 and cd3 = 1 and cd4 = 0 and cd5 = 1 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 0 and cd2 = 0 and cd3 = 0 and cd4 = 1 and cd5 = 1 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 1 and cd2 = 1 and cd3 = 1 and cd4 = 0 and cd5 = 0 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 1 and cd2 = 1 and cd3 = 0 and cd4 = 1 and cd5 = 0 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 1 and cd2 = 1 and cd3 = 0 and cd4 = 0 and cd5 = 1 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 1 and cd2 = 0 and cd3 = 1 and cd4 = 1 and cd5 = 0 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 1 and cd2 = 0 and cd3 = 1 and cd4 = 0 and cd5 = 1 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 1 and cd2 = 0 and cd3 = 0 and cd4 = 1 and cd5 = 1 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 0 and cd2 = 1 and cd3 = 1 and cd4 = 1 and cd5 = 0 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 0 and cd2 = 1 and cd3 = 1 and cd4 = 0 and cd5 = 1 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 0 and cd2 = 1 and cd3 = 0 and cd4 = 1 and cd5 = 1 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 0 and cd2 = 0 and cd3 = 1 and cd4 = 1 and cd5 = 1 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 1 and cd2 = 1 and cd3 = 1 and cd4 = 1 and cd5 = 0 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 1 and cd2 = 1 and cd3 = 1 and cd4 = 0 and cd5 = 1 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 1 and cd2 = 1 and cd3 = 0 and cd4 = 1 and cd5 = 1 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 1 and cd2 = 0 and cd3 = 1 and cd4 = 1 and cd5 = 1 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 0 and cd2 = 1 and cd3 = 1 and cd4 = 1 and cd5 = 1 union
SELECT count(*) as count, sum(vp) as vp_total, sum(hp) as hp_total from hands where cd1 = 1 and cd2 = 1 and cd3 = 1 and cd4 = 1 and cd5 = 1;
Query has 140 lines
query executed
cols = 3
rows = 1
0: count:1  vp:10  hp50