Interesting Query Results

[zovs66]

Here is a query that produces total number of scenarios by year:

SELECT sYear, count(*) AS Total
FROM ScenData.db
WHERE (sMonth > 0 AND sYear > 0) AND ScenID !=999
GROUP BY sYear
ORDER BY Total DESC

Here is the top 10 (so to speak):

sYear	Total
1989	39
1985	38
1984	29
1973	22
2009	21
1950	18
1967	15
1982	15
2015	12
2020	12
1968	11
1991	11
2006	10
2005	10
1965	10
1979	10
1978	10
2003	10

[zovs66]

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:

select distinct ScenNum, sTitle from sData
where (uName LIKE "T-80%")  AND ScenNum != 999

And the result list:

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

[Roman]

And how do you do that search? It's very good!!!

[Roman]

I already saw it in this thread.
http://forum.shrapnelgames.com/showthread.php?t=52203

[zovs66]

It is done using the ScenHack tool which comes with the CD version.

To get to it use the Game Options Menu | Utilities | ScenHack:



Go to the Sort Tab and paste the above query in the query edit box and click Run:



Lastly if you'd like to view the results in a file click on the 'Write CSV' button to generate a text file.