Here is another interesting query to run. You can literally change it to any unit class your interested in looking at. So lets say per that thread the other week about T-80's.
The query to find all the T-80's in all the scenarios:
Code:
select distinct ScenNum, sTitle from sData
where (uName LIKE "T-80%") AND ScenNum != 999
And the result list:
Code:
ScenNum sTitle
028 - 28 Schwarzer Herzog - Koenig****te
029 - 29 Schwarzer Herzog - Schandelah
033 - 33 Blackhorse! 6/86
036 - 36 Durango Valley: OPFOR Russia
114 - 114 It Begins! 8/86
119 - 119 Ukrainian Crisis 2/05
132 - 132 Into the Mouth of Hell 8/89
150 - 150 Arctic Battlefield VI 7/89
151 - 151 Breaking the Shackles 7/89
171 - 171 Facing the Angry Bear-2005
177 - 177 Armor at Alsfeld 8/89
179 - 179 The Bear strikes (WP) 6/86
180 - 180 The Bear strikes (NATO) 6/86
183 - 183 Fintel Ridge 9/89
188 - 188 Red Storm 85' BMP Regiment ***
268 - 268 Villingen 8/85
280 - 280 ALWIA: ...Buying Time
287 - 287 Red Dawn: Old ironsides
300 - 300 Battle In East Ukraine 3/14
317 - 317 Reindeer Games: White Death 12
336 - 336 Red Army-Forcing the Elbe 9/89
338 - 338 Red Army- Fintel Ridge 9/89
340 - 340 Red Army- Unexpected Guests 9/
349 - 349 SwordPoint 7/87
359 - 359 WW3: Vistula Crossing 6/20
362 - 362 Red Effect: Killing Grounds
368 - 368 Totenkopf Attacks WW2+40
372 - 372 Soldiers of Destruction WW2+40
379 - 379 Prohorovka 7/43 WW2+40
398 - 398 WW3: The Duck Hunt 6/20
414 - The Bridges of Jonava 9/99
416 - Soviets Return 12/2004
417 - Baltic Counterattack 5/2006
444 - Tough Training 4/2006
469 - Day of the Red Storm 8/89
474 - Blackhorse! 12/89