March 28th, 2019, 08:08 AM
|
 |
Shrapnel Fanatic
|
|
Join Date: Mar 2005
Location: GWN
Posts: 12,658
Thanks: 4,091
Thanked 5,862 Times in 2,893 Posts
|
|
Re: All U.S.M.C. Scenarios for 2019
Just remember it totals WIP or special saved scenarios as well. My total running that SQL you gave is 122
When I restrict it to the number of scenarios in the next patch I get 121 so IDK how you get 120
SELECT count(*)
FROM ScenData.db
WHERE sMonth > 0 AND sYear > 0 AND ScenID <488 AND P1ID = 11 OR P2ID = 11
|