[RRDXA] Mitglieder Urkunde ist Fertig!
Christoph Berg
cb at df7cb.de
Tue Mar 26 07:38:25 EDT 2024
Hallo RRDXA,
noch ein paar Worte dazu, wo die Mitgliedsnummern herkommen.
Die RRDXA ist 60 Jahre alt, und Mitgliedslisten aus den frühen Jahren
gibt es keine mehr (falls es sie je gab). Daher gab es bisher auch
keine Mitgliedsnummern. Anstatt zu rekonstruieren, was es gar nicht
mehr gibt, gab es dann die alternative Idee, die Nummern neu zu
starten. Wir fangen dann einfach bei 100 an, was zumindest ungefähr
die Zahl der früheren Mitglieder treffen sollte.
Die Nr. 100 geht an die Clubstation DA0RR.
Als Reihenfolge habe ich den Most Active Operator 2023 zugrunde
gelegt. Damit nicht der beste FT8-Robot gewinnt, werden die 4
Mode-Kategorien CW, Phone, Digi und FT8/4 getrennt gewertet. In jedem
Mode gibt es eine Rangliste von 1 (wenig QSO) bis knapp 60 (viele
QSO), und die 4 Zahlen werden addiert.
member_no │ call │ sum │ array_agg │ qsos
───────────┼────────┼─────┼─────────────────────────────────────────────────┼───────
101 │ OE4EIE │ 182 │ {"(CW,53)","(PHONE,55)","(DIGI,41)","(FT8,33)"} │ 22268
102 │ DK8ZZ │ 182 │ {"(PHONE,56)","(DIGI,44)","(CW,55)","(FT8,27)"} │ 19272
103 │ DF8XC │ 176 │ {"(CW,52)","(DIGI,45)","(PHONE,57)","(FT8,22)"} │ 16231
104 │ DF7EE │ 166 │ {"(DIGI,40)","(CW,38)","(FT8,29)","(PHONE,59)"} │ 21506
105 │ DF5EN │ 154 │ {"(CW,59)","(FT8,8)","(DIGI,37)","(PHONE,50)"} │ 18590
106 │ DK5DQ │ 148 │ {"(DIGI,32)","(PHONE,58)","(CW,57)","(FT8,1)"} │ 17561
107 │ DF6QV │ 133 │ {"(DIGI,33)","(PHONE,54)","(CW,43)","(FT8,3)"} │ 4837
108 │ DK7ZT │ 130 │ {"(PHONE,37)","(FT8,36)","(CW,48)","(DIGI,9)"} │ 69986
109 │ DL1DAW │ 130 │ {"(FT8,6)","(DIGI,35)","(CW,42)","(PHONE,47)"} │ 4229
110 │ DJ0IF │ 128 │ {"(DIGI,21)","(CW,56)","(PHONE,51)"} │ 12582
111 │ DJ2QV │ 124 │ {"(PHONE,32)","(FT8,30)","(CW,54)","(DIGI,8)"} │ 15422
112 │ DL2DCX │ 124 │ {"(CW,40)","(DIGI,36)","(PHONE,33)","(FT8,15)"} │ 4389
113 │ OE6VIE │ 118 │ {"(PHONE,13)","(DIGI,28)","(CW,49)","(FT8,28)"} │ 10765
114 │ DF7CB │ 118 │ {"(DIGI,18)","(PHONE,31)","(CW,51)","(FT8,18)"} │ 6756
115 │ DJ4MH │ 116 │ {"(CW,34)","(PHONE,43)","(DIGI,39)"} │ 2958
116 │ DL8LR │ 112 │ {"(PHONE,49)","(CW,32)","(DIGI,31)"} │ 2547
117 │ DJ1AA │ 110 │ {"(DIGI,4)","(PHONE,38)","(CW,33)","(FT8,35)"} │ 60468
118 │ DF1LON │ 110 │ {"(CW,46)","(PHONE,25)","(FT8,16)","(DIGI,23)"} │ 4601
119 │ DL6TK │ 102 │ {"(CW,24)","(DIGI,34)","(FT8,20)","(PHONE,24)"} │ 3818
120 │ DL1QW │ 99 │ {"(CW,41)","(PHONE,16)","(DIGI,42)"} │ 3725
121 │ DH1PS │ 96 │ {"(DIGI,17)","(PHONE,48)","(FT8,31)"} │ 11441
122 │ DH6DAO │ 95 │ {"(FT8,23)","(CW,27)","(DIGI,5)","(PHONE,40)"} │ 4731
123 │ DM9EE │ 93 │ {"(FT8,26)","(PHONE,35)","(DIGI,6)","(CW,26)"} │ 7236
124 │ DL4SDW │ 92 │ {"(PHONE,18)","(DIGI,27)","(CW,47)"} │ 3129
125 │ DF4PD │ 90 │ {"(CW,44)","(DIGI,26)","(PHONE,20)"} │ 2901
126 │ DF1QR │ 86 │ {"(FT8,13)","(PHONE,42)","(CW,6)","(DIGI,25)"} │ 2081
127 │ DH3GE │ 84 │ {"(FT8,32)","(PHONE,52)"} │ 14341
128 │ DL1WA │ 84 │ {"(CW,50)","(PHONE,34)"} │ 3688
129 │ DL7PIP │ 80 │ {"(FT8,24)","(PHONE,39)","(CW,17)"} │ 4402
130 │ DM2RM │ 76 │ {"(FT8,21)","(CW,21)","(DIGI,19)","(PHONE,15)"} │ 3071
131 │ OP4A │ 74 │ {"(CW,31)","(FT8,25)","(PHONE,2)","(DIGI,16)"} │ 5610
132 │ DL8OBF │ 73 │ {"(CW,9)","(PHONE,53)","(FT8,11)"} │ 2703
133 │ DF8QB │ 72 │ {"(DIGI,43)","(CW,7)","(PHONE,22)"} │ 2787
134 │ LX1JH │ 68 │ {"(DIGI,7)","(PHONE,19)","(CW,8)","(FT8,34)"} │ 15291
135 │ DL7AOS │ 67 │ {"(PHONE,45)","(FT8,2)","(CW,20)"} │ 1488
136 │ DF2AJ │ 65 │ {"(CW,29)","(PHONE,36)"} │ 1477
137 │ DH4PSG │ 65 │ {"(PHONE,41)","(DIGI,24)"} │ 1259
138 │ DK8EY │ 63 │ {"(DIGI,29)","(PHONE,7)","(CW,13)","(FT8,14)"} │ 1547
139 │ DF2SD │ 63 │ {"(CW,36)","(PHONE,27)"} │ 1410
140 │ DL1CW │ 59 │ {"(DIGI,1)","(CW,58)"} │ 14565
141 │ DF5BX │ 55 │ {"(CW,25)","(DIGI,30)"} │ 891
142 │ DL8ZAJ │ 53 │ {"(PHONE,8)","(CW,18)","(DIGI,20)","(FT8,7)"} │ 672
143 │ DJ7YP │ 52 │ {"(CW,30)","(DIGI,22)"} │ 972
144 │ DL1YR │ 51 │ {"(PHONE,30)","(DIGI,2)","(FT8,19)"} │ 2580
145 │ DJ2YA │ 51 │ {"(FT8,12)","(CW,19)","(PHONE,17)","(DIGI,3)"} │ 1155
146 │ DG3BZ │ 47 │ {"(FT8,17)","(CW,1)","(PHONE,29)"} │ 2264
147 │ DL7BC │ 46 │ {"(PHONE,46)"} │ 1229
148 │ DK3QZ │ 45 │ {"(CW,45)"} │ 2416
149 │ DL5AN │ 44 │ {"(PHONE,44)"} │ 1102
150 │ DM3XRF │ 39 │ {"(CW,39)"} │ 1507
151 │ ON4CT │ 38 │ {"(DIGI,38)"} │ 1028
152 │ DL8SCG │ 37 │ {"(CW,37)"} │ 1244
153 │ DL8TG │ 37 │ {"(CW,22)","(DIGI,15)"} │ 470
154 │ DL9DAN │ 36 │ {"(CW,10)","(PHONE,26)"} │ 429
155 │ OT1A │ 35 │ {"(CW,35)"} │ 865
156 │ DK4US │ 29 │ {"(DIGI,13)","(CW,11)","(PHONE,5)"} │ 232
157 │ DD5MA │ 28 │ {"(FT8,10)","(CW,3)","(DIGI,11)","(PHONE,4)"} │ 797
158 │ DK5TRI │ 28 │ {"(CW,28)"} │ 607
159 │ DL5HAI │ 28 │ {"(PHONE,28)"} │ 515
160 │ DL9BU │ 27 │ {"(CW,15)","(DIGI,12)"} │ 274
161 │ DK4QT │ 26 │ {"(CW,16)","(DIGI,10)"} │ 274
162 │ DL9YED │ 26 │ {"(CW,12)","(DIGI,14)"} │ 244
163 │ DO1KUB │ 25 │ {"(PHONE,23)","(CW,2)"} │ 252
164 │ DK2DQ │ 23 │ {"(CW,23)"} │ 323
165 │ DB5ZF │ 21 │ {"(PHONE,21)"} │ 218
166 │ DL1SBF │ 20 │ {"(PHONE,6)","(CW,14)"} │ 214
167 │ DC2CB │ 14 │ {"(PHONE,10)","(FT8,4)"} │ 152
168 │ DF8ZH │ 14 │ {"(PHONE,14)"} │ 148
169 │ DK2EE │ 12 │ {"(PHONE,12)"} │ 136
170 │ DM4KW │ 11 │ {"(PHONE,11)"} │ 125
171 │ DL4YBL │ 9 │ {"(FT8,9)"} │ 585
172 │ DL6SAK │ 9 │ {"(PHONE,9)"} │ 100
173 │ OE6ZLA │ 9 │ {"(FT8,5)","(CW,4)"} │ 82
174 │ DL1XW │ 5 │ {"(CW,5)"} │ 39
175 │ DJ8DS │ 3 │ {"(PHONE,3)"} │ 19
176 │ DO4DAN │ 1 │ {"(PHONE,1)"} │ 1
(76 Zeilen)
Platz 1 war knapp, da hat OE4EIE dann doch mit mehr QSO die Nr. 101
gewonnen.
Die Nummern der Mitglieder, die nicht am MAO teilgenommen hatten, sind
ab 177 anhand des Anmeldedatums im rrdxa.org-Wordpress vergeben.
Christoph DF7CB #114
PS: Ich hatte vermutlich noch nie ein 3-fach geschachteltes Subselect
in SQL benutzt:
select row_number() over () + 100 as member_no, * from
(select call, sum(row_number), array_agg((mode,row_number))::text, sum(count) as qsos from
(select call, mode, count, row_number() over (partition by mode order by count) from
(select rroperator as call, major_mode mode, count(*) from log
join rrcalls on coalesce(operator, station_callsign) = rrcall
where start between '2023-01-01' and '2024-01-01' and major_mode <> 'unknown' and rrcall <> 'DA0RR'
group by 1, 2 order by 3 desc))
group by call order by 2 desc, 4 desc);
More information about the RRDXA
mailing list