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:

https://i.imgur.com/Tx4mlaF.png

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

https://i.imgur.com/zUiFA8Q.png

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