Error in query SELECT count(prf_ID) as Number, if (prf_Units = 'Meter', round(ABS(prf_MinRate),0) , round(ABS(prf_MinRate) * 0.3048, 0)) as DescentRate, if (prf_Units = 'Meter', round(ABS(prf_MaxRate),0) , round(ABS(prf_MaxRate) * 0.3048, 0)) as AscentRate FROM udlProfile WHERE usr_ID = 1 AND prf_Type = 'depth' GROUP BY prf_MinRate, prf_MaxRate
Max stijgsnelheden
Snelheid(Meter/min):Aantal duiken%
0: 8 1%
1: 8 1%
2: 47 3%
3: 166 12%
4: 354 26%
5: 238 17%
6: 176 13%
7: 100 7%
8: 115 8%
9: 57 4%
10: 34 2%
11: 20 1%
12: 15 1%
13: 7 1%
14: 4 0%
15: 4 0%
16: 5 0%
17: 3 0%
18: 2 0%
19: 3 0%
20: 4 0%
21: 2 0%
22: 1 0%
23: 1 0%
24: 0 0%
25: 0 0%
26: 0 0%
27: 0 0%
28: 1 0%
29: 0 0%
30: 0 0%
31: 0 0%
32: 0 0%
33: 0 0%
34: 0 0%
35: 0 0%
36: 0 0%
37: 0 0%
38: 0 0%
39: 0 0%
40: 0 0%
41: 0 0%
42: 0 0%
43: 0 0%
44: 1 0%
Opstijgsnelheid buckets
Max daalsnelheden
Snelheid(Meter/min):Aantal duiken%
0: 7 1%
1: 11 1%
2: 30 2%
3: 80 6%
4: 259 19%
5: 207 15%
6: 186 14%
7: 107 8%
8: 109 8%
9: 61 4%
10: 44 3%
11: 37 3%
12: 39 3%
13: 32 2%
14: 34 2%
15: 18 1%
16: 41 3%
17: 9 1%
18: 15 1%
19: 9 1%
20: 11 1%
21: 6 0%
22: 2 0%
23: 7 1%
24: 6 0%
25: 2 0%
26: 1 0%
27: 1 0%
28: 0 0%
29: 0 0%
30: 1 0%
31: 0 0%
32: 1 0%
33: 0 0%
34: 0 0%
35: 1 0%
36: 1 0%
37: 0 0%
38: 0 0%
39: 1 0%
Afdaalsnelheid buckets
Opstijg versus Afdaal snelheden