Interesting Query Results

[zovs66]

One last example for the day.

I just was curious how many scenarios contained the T-34/76 M1943.

The Query:

select distinct ScenNum, sTitle, uName from sData where uName like "%T-34/76 M1943%" and Nation = "Russia"

The Results:

ScenNum	sTitle	uName
000 - 0 WINSPWW2 Tutorial Scenario	T-34/76 M1943
007 - 7 Ferdinands at Kursk 7/43	T-34/76 M1943
046 - 46 Totenkopf Attacks 213.9 7/43	T-34/76 M1943
085 - 85 Wiking volunteers defend 2/43	T-34/76 M1943
088 - 88 The Dark Streets of Kiev 11/43	T-34/76 M1943
091 - 91 Panthers Enter Kowel 3/44	T-34/76 M1943
093 - 93 Tigers at Narva (II) 4/44	T-34/76 M1943
094 - 94 Romanian Spring Attack 4/44	T-34/76 M1943
115 - 115 Langemarck at Narva, Day 3 7/4	T-34/76 M1943
142 - 142 StuG 276 in South Russia 1/44	T-34/76 M1943
151 - 151 Czerkasy Station 3/44	T-34/76 M1943
152 - 152 Retaking Czerkasy 4/44	T-34/76 M1943
153 - 153 Kowel Relief Attack I 4/44	T-34/76 M1943
154 - 154 Defending Kowel 4/44	T-34/76 M1943
155 - 155 Piercing the Pocket 4/44	T-34/76 M1943
156 - 156 Kowel Tank Battle 4/44	T-34/76 M1943
168 - 168 Bake Attacks 2/44	T-34/76 M1943
254 - 254 Kurland: Baldone 9/44	T-34/76 M1943
266 - 266 Fronteinsatz 2/45	T-34/76 M1943
305 - 305 Gegenstoss 10/44	T-34/76 M1943
306 - 306 Jaszberenv Rearguard 11/44	T-34/76 M1943
349 - 349 StuGs against the Storm 9/44	T-34/76 M1943
379 - 379 Budapest 1/45	T-34/76 M1943
423 - 423 Prokhorovka 7/43	T-34/76 M1943
440 - 440 Tiger Trap  2/44	T-34/76 M1943
446 - 446 ASL Gotterdammerung 4/45	T-34/76 M1943
472 - 472 KG Friebe Attacks 4/44	T-34/76 M1943
505 - 505 Fictional delay, Romania 8/44	T-34/76 M1943
530 - The Crossing 9/43	T-34/76 M1943
532 - The Crossing Part II 9/43	T-34/76 M1943
534 - The Passing 8/43	T-34/76 M1943
536 - Hold Until Relieved 11/43	T-34/76 M1943
539 - Operation Kutuzov 8/43	T-34/76 M1943
540 - 3rd Mech Corps: Ukraine 8/43	T-34/76 M1943
543 - 3rd Mech Corps: Kursk 7/43	T-34/76 M1943
544 - The Turning Tide: Ukraine 9/43	T-34/76 M1943
545 - Southern Exposure: Kursk 7/43	T-34/76 M1943
547 - Beginning of the End: Kursk 7/43	T-34/76 M1943
574 - Delayed British Attack 8/45	T-34/76 M1943
589 - Taming the Tigers 8/44 (PBEM)	T-34/76 M1943
594 - No Support 7/44	T-34/76 M1943
595 - Thrown Together 7/44	T-34/76 M1943
596 - Cut Off 7/44	T-34/76 M1943
598 - Fanatical Holding Action 9/44	T-34/76 M1943
613 - Night Battle Noromaryevka 1/43	T-34/76 M1943
627 - Smashing the 3rd 8/44	T-34/76 M1943
720 - Smertniki 8/45	T-34/76 M1943
730 - The Deadly Line 8/45	T-34/76 M1943

Okay, I am guilty I created 20 scenarios with those T-34's! lol.

Okay one last sql to find all the scenarios that have the German's using captured T-34s:

select distinct ScenNum, sTitle, uName from sData where uName like "%747(r)%" and Nation = "Germany"

Results:

ScenNum	sTitle	uName
021 - 21 Jagdtigers in the West 4/45	Pz T34c 747(r)
350 - 350 Comrade Kopitin's Valor 8/44	Pz T34b 747(r)
416 - 416 Kulikovka Sanatorium 1/43	Pz T34a 747(r)
527 - Into the valley of death 10/44	Pz T34c 747(r)
545 - Southern Exposure: Kursk 7/43	Pz T34c 747(r)

Cool stuff with ScenHack...