Interesting Query Results

[zovs66]

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

The query:

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:

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.