Casino City Home
World Gambling
American Gambling
Massachusetts Gambling
MGM Springfield
Nearby CasinosHotel ReservationsTweetsMapExecutivesOwnership
Casino City HomeWorld GamblingAmerican GamblingMassachusetts Gambling
MGM Springfield Nearby CasinosHotel Reservations
News
TweetsMapExecutivesOwnership
Sign up for the
Casino City Times
Weekly Newsletter!

MGM Springfield News

Casino City’s Friday Five: Jackpots and crimes edition

This week, we have a major jackpot win at Mohegan Sun in Connecticut, BetMGM teaming up with Buffalo Wild Wings, Intertops hosting a $240,000 contest, a grand opening coming up for a Nevada casino, and several incidents taking place at Encore Boston Harbor.

Craps welcomed back at Massachusetts casinos

The Mass Gaming Commission approved a request from MGM Springfield and Encore Boston Harbor to resume operating craps while blackjack tables can expand to four seats.

Casino City’s Friday Five: More casinos reopening edition

The first casino in Massachusetts began welcoming back guests this week, while the other two following suit in the next few days. In the poker world, the World Series of Poker continues to give out gold bracelets through online events.

Casino City’s Friday Five: World Series of Poker 2020 kicks off edition

Even though we are seeing a much different edition of the World Series of Poker this year, it is officially underway. While it is not taking place at the Rio All-Suite Hotel & Casino in Las Vegas, golden bracelets will be awarded in online competitions this summer.

MGM Springfield will reopen on 13 July

The Western Massachusetts property will reopen in a limited capacity to the public on Monday, July 13 at 10 a.m. A hosted, invitation-only event will take place ahead of the public reopening.

Casino City’s Friday Five: Las Vegas face mask edition

In an attempt to slow spreading, the Nevada Gaming Control Board adjusted the policy once again this week, making it a requirement for any visitor in a public place, which includes sitting at a table game with plexiglass barriers.

Massachusetts casinos will reopen without poker, craps and roulette

The Massachusetts Gaming Commission adopted rules that Encore Boston Harbor, MGM Springfield and Plainridge Park Casino must meet in anticipation of the resumption of casino operations.

Massachusetts casinos extend closure through the end of May

The MGC voted unanimously to extend the temporary closure of Plainridge Park Casino, Encore Boston Harbor and MGM Springfield until 1 June.

Massachusetts casinos will remain closed until 18 May

The Massachusetts Gaming Commission voted unanimously today to extend the temporary closures of Encore Boston Harbor, MGM Springfield and Plainridge Park Casino.

Massachusetts casinos hit hard by COVID-19 shutdown

The gross gaming revenues for the month of March at Encore Boston Harbor, MGM Springfield and Plainridge Park were less than half of what they made in February.

About us | Editorial Staff | Feedback | Advertising
CASINO CITY NETWORK: Online Casino City | Casino City Times | Poker Zone | RGT Online | Casino City Press | Gaming Directory

 


Debugging Information
ColdFusion Server Standard 9,0,1,274733
Template /propertynews.cfm
Time Stamp 14-Apr-21 11:14 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 216.116.192.60
Host Name 216.116.192.60


Execution Time

Total Time Avg Time Count Template
21 ms 21 ms 1 top level D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\propertynews.cfm
8 ms 8 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/MicroLeftNavQueries.cfm
3 ms 3 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/newsInclude.cfm
1 ms 1 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/footerMicro.cfm
1 ms 1 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/legal.cfm
0 ms 0 ms 1 D:/ClusterSites/htdocs/minisites.casinocity.com/htdocs/Application.cfm
0 ms 0 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/GoogleAnalyticsJavaScript.cfm
0 ms 0 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/OCCBonusBlock.cfm
0 ms 0 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/casinocitynetwork.cfm
0 ms 0 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/microLeftNav.cfm
0 ms 0 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/rightSide2.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
21 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GetPropertyID (Datasource=GamingProperties-RO-CasinoCity, Time=7ms, Records=1) in D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\propertynews.cfm @ 11:14:59.059
		SELECT Property.PropertyId     -- Property.OrganizationName, Countries.PlaceName Country, States.PlaceName State
		FROM Property
		WHERE dbo.StringToUrl(Property.City) = 'springfield'
		  AND Property.UrlOrganizationName = 'mgm-springfield'
		  AND Property.PropertyStatusTypeId = 1
	
Property (Datasource=GamingProperties-RO-CasinoCity, Time=3ms, Records=1) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 11:14:59.059
	SELECT 	Top 1 Property.PropertyId, 
		Property.PlaceId,
		Property.Abbreviation,
		Property.OrganizationName,
		CASE
			WHEN IsNull(Property.ShortOrganizationName,'') = '' THEN Property.OrganizationName
			ELSE Property.ShortOrganizationName
		END ShortOrganizationName,
		Property.Address1,
		Property.Address2,
		Property.Address3,
		Property.City,
		StateNamePlaces.PlaceName AS StateName,
		Property.PostalCode,
		Property.CCURL,
		Property.URL,
		Property.EmailGeneral,
		Property.Longitude,
		Property.Latitude,
		Property.OwnerType,
		IsNull(Property.TravelNowID, 0) TravelNowId,
		Property.Latitude,
		Property.Longitude,
		Property.Geolocation,
		GeocodePrecision.GeocodePrecision,
		Property.GeocodeConfidence,
		CASE
			when Property.OwnerType = 'INDIAN' then 'Native American'
			else ''
		END formatedOwnerType,
		Property.PropertyType,
		Casino.CasinoName,
		Casino.StructureType,
		IsNull(Casino.SquareFeet, 0) SquareFeet,
		LTrim(RTrim(Casino.Hours)) Hours,
		PropertyStatusTypes.*,
		IsNull(SlotPropertyAndGame.Quantity, 0) SlotQuantity,
		IsNull(TableGamePropertyAndGame.Quantity, 0) TableQuantity,
		
		StatePlaces.PlaceCode State,
		StatePlaces.PlaceName StateName,
		CountryPlaces.PlaceCode Country,
		CountryPlaces.PlaceId   CountryId,
		CASE	WHEN IsNull(CountryPlaces.CommonName,'') <> '' THEN CountryPlaces.CommonName
				ELSE CountryPlaces.PlaceName
		END	FullCountryName,
		PropertyDetails.CasinoCityUrl MicrositeUrl,
		(
			SELECT 	Top 1 PropertyAndExecutiveUpdates.Id 
			FROM PropertyAndExecutiveUpdates 
			INNER JOIN ExecutiveUpdates ON
				PropertyAndExecutiveUpdates.ExecutiveUpdateId = ExecutiveUpdates.ExecutiveUpdateId
			INNER JOIN ExecutiveUpdatesAndExecutiveResponsibilities ON
				ExecutiveUpdates.ExecutiveUpdateId = ExecutiveUpdatesAndExecutiveResponsibilities.ExecutiveUpdateId
			INNER JOIN ExecutiveResponsibility ON 
				ExecutiveUpdatesAndExecutiveResponsibilities.ExecutiveResponsibilityId = ExecutiveResponsibility.ExecutiveResponsibilityId
			WHERE PropertyAndExecutiveUpdates.PropertyId= Property.PropertyId
			AND ExecutiveUpdates.EndDate IS NULL
			AND ExecutiveUpdates.Status = 'A'
		) AnyExecs,
		(
			SELECT 	Top 1 PropertyAndGamingBusinesses.PropertyId
			FROM PropertyAndGamingBusinesses 
			WHERE PropertyID = Property.PropertyId
			AND PropertyAndGamingBusinesses.EndActiveDate IS NULL
		) AnyOwners,
		(
			SELECT 	Top 1 PropertyAndImage.PropertyId
			FROM 	PropertyAndImage
			INNER JOIN Image ON 
				PropertyAndImage.ImageID = Image.ImageID
			WHERE 	PropertyAndImage.PropertyId = Property.PropertyId
		) AnyImages,
		
	(SELECT COUNT (DISTINCT Articles.ArticleId)
	FROM Articles
	INNER JOIN Content 
		ON Articles.ContentId = Content.ContentId
	INNER Join ContentAndObjects ON
		(ContentAndObjects.ContentId = Content.ContentId
		AND ContentAndObjects.ObjectId = Property.PropertyId AND
		ContentAndObjects.TableId = 1)
	) HaveNews
	
	FROM	Property
	INNER JOIN PropertyDetails ON Property.PropertyId = PropertyDetails.PropertyId
	LEFT JOIN GeocodePrecision ON Property.GeocodePrecisionId = GeocodePrecision.GeocodePrecisionId
	-- State Name
	LEFT JOIN PropertyAndPlaces PropertyAndStateNamePlaces ON (Property.PropertyId = PropertyAndStateNamePlaces.PropertyId
		AND PropertyAndStateNamePlaces.PlaceLevel = 2
		AND PropertyAndStateNamePlaces.LocationTypeCode = 'P'
		)
	LEFT JOIN Places StateNamePlaces ON 
		PropertyAndStateNamePlaces.PlaceId = StateNamePlaces.PlaceId
	-- Country Info
	INNER JOIN PropertyAndPlaces PropertyAndPlacesCountry ON (Property.PropertyId = PropertyAndPlacesCountry.PropertyId
		AND PropertyAndPlacesCountry.PlaceLevel =1
		AND PropertyAndPlacesCountry.LocationTypeCode = 'P'
		)
	INNER JOIN Places CountryPlaces ON 
		PropertyAndPlacesCountry.PlaceId = CountryPlaces.PlaceId
	LEFT JOIN ActiveCountryMiniSites ON CountryPlaces.PlaceId = ActiveCountryMiniSites.PlaceId
	-- State Info
	LEFT JOIN PropertyAndPlaces PropertyAndPlacesState ON (Property.PropertyId = PropertyAndPlacesState.PropertyId
		AND PropertyAndPlacesState.PlaceLevel = 2
		AND CountryPlaces.ExposeChildrenInCasinoCity = 1
		AND PropertyAndPlacesState.LocationTypeCode = 'P'
		)
	LEFT JOIN Places StatePlaces ON 
		PropertyAndPlacesState.PlaceId = StatePlaces.PlaceId
	LEFT JOIN ActiveStateMiniSites ON
		StatePlaces.PlaceId = ActiveStateMiniSites.PlaceId
	-- Slot Count
	LEFT JOIN PropertyAndGame SlotPropertyAndGame ON
		Property.PropertyId = SlotPropertyAndGame.PropertyId AND SlotPropertyAndGame.GameId = 100
	LEFT JOIN Game SlotGame ON
		SlotPropertyAndGame.GameID = SlotGame.GameID AND SlotGame.[Description] = 'Slots'
	-- Table Game Count
	LEFT JOIN PropertyAndGame TableGamePropertyAndGame ON
		Property.PropertyId = TableGamePropertyAndGame.PropertyId AND TableGamePropertyAndGame.GameId = 10300
	LEFT JOIN Game TableGame ON
		TableGamePropertyAndGame.GameID = TableGame.GameID AND TableGame.[Description] = 'Table Games'

	LEFT JOIN PropertyStatusTypes ON
		Property.PropertyStatusTypeID=PropertyStatusTypes.PropertyStatusTypeID
	LEFT JOIN Casino ON
		Property.PropertyId = Casino.PropertyId
	LEFT JOIN Minisites ON
		Property.PropertyId = Minisites.PropertyId
	LEFT JOIN Hosts ON
		Minisites.MinisiteId = Hosts.MinisiteId
	WHERE	Property.Propertyid= ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 981300

getCCRegion (Datasource=GamingProperties-RO-CasinoCity, Time=1ms, Records=0) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 11:14:59.059
	SELECT PlaceGroupId, FqDn,
			 CASE WHEN ActiveRegionMinisites.PlaceGroup IN ('Central America','South America') THEN 'Central and South America'
			 		ELSE ActiveRegionMinisites.PlaceGroup
			 END	PlaceGroup
	FROM  ActiveRegionMinisites
	WHERE ActiveRegionMinisites.PlaceGroup =
		(	SELECT CASE WHEN PlaceGroups.PlaceGroup = 'Central America'	THEN 'South America'
							WHEN PlaceGroups.PlaceGroup = 'Russian Federation' THEN 'Europe'
							ELSE PlaceGroups.PlaceGroup
					 END PlaceGroup
			FROM 	Places
			INNER JOIN PlaceGroupsAndPlaces	ON PlaceGroupsAndPlaces.PlaceId = Places.PlaceId
			INNER JOIN PlaceGroups				ON PlaceGroups.PlaceGroupID = PlaceGroupsAndPlaces.PlaceGroupId
			WHERE Places.PlaceId = 2
			AND 	PlaceGroups.PlaceGroup IN ('Europe','North America','South America','Central America','Asia','Africa','Oceania','Caribbean')
		)
navStructure (Datasource=GamingProperties-RO-CasinoCity, Time=1ms, Records=12) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 11:14:59.059
	SELECT * FROM PropertyNavigation 
	WHERE  PropertyId=?
	  AND  Active=1
	ORDER BY SortOrder
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 981300

getNews (Datasource=GamingProperties-RO-CasinoCity, Time=3ms, Records=79) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\newsInclude.cfm @ 11:14:59.059
	SELECT Articles.ArticleId, Articles.Title, Articles.BriefDescription, Content.PublicationDate, Content.ContentId,
	 CASE WHEN Content.PrimaryArticleUrl IS NOT NULL
			THEN Content.PrimaryArticleURL
			ELSE 'www.casinocitytimes.com/news/article/' + dbo.StringToUrl(Articles.Title) + '-' + Cast(Content.ContentID AS varchar)
	 END  PrimaryArticleURL,
	 Websites.UseHttps
	FROM Articles
	INNER JOIN Content 
		ON Articles.ContentId = Content.ContentId
	LEFT JOIN Websites ON Content.PrimaryWebSiteId = WebSites.WebsiteId
	INNER JOIN ContentAndObjects 
		ON ContentAndObjects.ContentId = Content.ContentId
	INNER JOIN Tables 
		ON (ContentAndObjects.TableId = Tables.TableId
		AND Tables.TableName = 'Property')
	INNER JOIN Property 
		ON Property.PropertyId = ContentAndObjects.ObjectId
	WHERE Property.PropertyId = ?
	AND IsNull(Content.ApprovalFlag,0) <> 2
	ORDER BY Content.PublicationDate DESC, Articles.ArticleID DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 981300


Scope Variables

Application Variables:
applicationname=Minisites
dbpassword=m0nsters,Inc
dbusername=CC-RO-CasinoCity
dsn=GamingProperties-RO-CasinoCity
googlemapkey=AIzaSyDM2pDbQRrl4ZeldPpxu1lf8nENUYv-BLM
googlemapkey3=AIzaSyD56LEu3WUieqGOTmHj08k_WHnsVpAyTr4
sitename=casinocity.com
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\propertynews.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=massachusetts.casinocity.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=/propertynews.cfm
PATH_TRANSLATED=D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\propertynews.cfm
QUERY_STRING=site=massachusetts&city=springfield&property=mgm-springfield
REMOTE_ADDR=216.116.192.60
REMOTE_HOST=216.116.192.60
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/propertynews.cfm
SERVER_NAME=massachusetts.casinocity.com
SERVER_PORT=3012
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=
Server Variables:
coldfusion=Struct (8)
os=Struct (5)
URL Parameters:
city=springfield
property=mgm-springfield
site=massachusetts
Debug Rendering Time: 12 ms