.com.unity Forums - Interesting Query Results

.com.unity Forums (http://forum.shrapnelgames.com/index.php)

- WinSPWW2 (http://forum.shrapnelgames.com/forumdisplay.php?f=139)

- - Interesting Query Results (http://forum.shrapnelgames.com/showthread.php?t=52205)

Interesting Query Results

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

Code:

SELECT sYear, count(*) AS Total

FROM ScenData.db

WHERE (sMonth > 0 AND sYear > 0) AND ScenID !=999

GROUP BY sYear

ORDER BY Total DESC

Not too surprisingly here is the list:

Code:

sYear        Total

1944        199

1945        114

1941        109

1943        100

1942        91

1940        75

1939        57

1936        6

1938        6

1937        5

1934        4

1935        3

1946        2

1933        2

1932        1

1931        1

1930        1

* Note: I excluded out the twenty-five 1930 scenario's (real dates 1908-1929) I am currently working for this result.

Re: Interesting Query Results

So during play testing I wrote this query to find out about how many bicycles were in all the scenarios.

The query:

Code:

select distinct ScenNum, sTitle from sData

where uName = "Fahrrad Gruppe" or uName = "Kerekparos Raj" or uName = "Bicycles" or uName = "Bicycle Squad" or uName =  "Bicycle Sqd ATR" or uName = "Bicycle Cavalry" or  uName = "Bicycle Inf" or uName = "Bicycle MG Team" or uName = "Bicycle Sec" or  uName = "Bicycle Section" or uName = "Bicycle Scouts"

Note that I had to use MobHack to find all the possible spellings, there is a shortcut way to do that, but I just wanted to illustrate a point.

Here is the results:

Code:

ScenNum        sTitle

078 - 78 Hungarian 2nd Motorized 8/41

172 - 172 Air Assault on The Hague 5/40

235 - 235 Skirmish at Hustenburg 5/40

236 - 236 Belgian Counterattack 5/40

356 - 356 Prosna Bridgehead 9/39

357 - 357 Hard Fighting 9/39

359 - 359 Elddopet A Baptism of Fire 4/4

529 - South of Uman 7/41

624 - Siam Sambal 1/41

632 - Balkan Sideshow 4/41

652 - Riding the Coattails 9/39

653 - Age-Old Foes 9/39

668 - Tentative 5/40

Not only neat things we can ask ScenHack about our database of scenarios and units, but some great scenarios to try out when your like "Hey I'd like to play a scenario that has such and such with that whatz-youz-mall-callz itz".

If you ask I probably already wrote a sql for that or can help out.

Re: Interesting Query Results

One last example for the day.

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

The Query:

Code:

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

The Results:

Code:

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:

Code:

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

Results:

Code:

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...

Re: Interesting Query Results

Wait, is the patch already out?

Re: Interesting Query Results

Quote:

Originally Posted by Ts4EVER (Post 844879)

Wait, is the patch already out?

Of course not. Coming soon.

Re: Interesting Query Results

Don just got a bit ahead of events. If all goes well it will be Tuesday April 2