Visit Casino City's Internet Directory
Casino City HomeWorld GamblingAmerican GamblingIndiana Gambling
Belterra Casino Resort
Nearby Casinos
NewsMapExecutivesOwnership
Sign up for the
Casino City Times
Weekly Newsletter!
Casino City Home
World Gambling
American Gambling
Indiana Gambling
Belterra Casino Resort
NewsMapExecutivesOwnership

Casinos Near Belterra Casino Resort

There are 45 casinos within 100 miles of Belterra Casino Resort

Map Index Distance (miles) Casino
  Belterra Casino Resort  find on map
14608 State Road 156, Florence, Indiana
12.9 Rising Star Casino Resort  find on map
777 Rising Star Drive, Rising Sun, Indiana
22.4 Hollywood Casino - Lawrenceburg  find on map
777 Hollywood Boulevard, Lawrenceburg, Indiana
23.5 Turfway Park Racing and Gaming  find on map
7500 Turfway Road, Florence, Kentucky
30.5 Saint Michael Bingo  find on map
2104 Saint Michael Street, Cincinnati, Ohio
32.4 Newport Racing & Gaming  find on map
1723 Monmouth Street, Newport, Kentucky
32.5 Hard Rock Casino - Cincinnati  find on map
1000 Broadway Street, Cincinnati, Ohio
34.0 Belterra Park Gaming & Entertainment Center  find on map
6301 Kellogg Road, Cincinnati, Ohio
44.9 Pride Bingo  find on map
1233 Symmes Road, Fairfield, Ohio
45.1 St. John Bingo Hall  find on map
751 Slone Drive, Suite 17-19, Georgetown, Kentucky
46.5 Ruggles Blue  find on map
4844 Union Center Pavilion, West Chester, Ohio
52.3 American Legion Post 34  find on map
725 West Broadway Street, Lawrenceburg, Kentucky
53.7 Keeneland  find on map
4201 Versailles Road, Lexington, Kentucky
54.6 Bingo City at Breckenridge  find on map
3441 Breckenridge Lane, Louisville, Kentucky
55.4 Winner's Circle OTB Clarksville  find on map
650 Eastern Boulevard, Clarksville, Indiana
55.7 Red Mile Gaming & Racing  find on map
1200 Red Mile Road, Lexington, Kentucky
57.0 Jackpot Bingo  find on map
1230 Eastland Drive, Lexington, Kentucky
58.3 Roosevelt Boulevard Bingo  find on map
3244 Roosevelt Boulevard, Middletown, Ohio
58.5 Derby City Gaming  find on map
4520 Poplar Level Road, Louisville, Kentucky
58.9 Sunshine Bingo Center  find on map
5712 Outer Loop, Louisville, Kentucky
59.8 Warren County Bingo  find on map
121 South Broadway Street, Lebanon, Ohio
60.1 Churchill Downs  find on map
700 Central Avenue, Louisville, Kentucky
60.5 Miami Valley Gaming  find on map
6000 West State Route 63, Lebanon, Ohio
61.3 New Silver Heights Bingo  find on map
9206 Blue Lick Road, Louisville, Kentucky
61.3 J-Town Bingo Hall  find on map
9125 Galene Drive, Louisville, Kentucky
65.6 Rainbow Bingo  find on map
4449 Rockwell Road, Winchester, Kentucky
66.6 Caesars Southern Indiana  find on map
11999 Casino Center Drive Southeast, Elizabeth, Indiana
66.8 Charity Hall Bingo  find on map
5001 Stephan Drive, Louisville, Kentucky
71.8 Keystone Bingo Center  find on map
126 Keystone Avenue, Bardstown, Kentucky
73.2 Indiana Grand Racing & Casino  find on map
4200 North Michigan Road, Shelbyville, Indiana
73.3 Winner's Circle Brewpub & OTB Indiana Grand  find on map
4300 North Michigan Road, Indiana Grand Racing & Casino, Shelbyville, Indiana
76.5 VFW 9927 Bingo  find on map
3316 Wilmington Pike, Dayton, Ohio
76.5 Tri-County Bingo  find on map
261 East Clay Street, Lewisburg, Ohio
79.5 Galaxy Bingo and Bowling  find on map
1025 Amberly Way, Richmond, Kentucky
79.6 Eastown Bingo  find on map
1232 Falke Drive, Dayton, Ohio
80.1 The Ruggles Club  find on map
3335 Seajay Drive, Beavercreek, Ohio
80.6 HCRC Bingo  find on map
1922 Leo Street, Dayton, Ohio
82.5 Hollywood Gaming at Dayton Raceway  find on map
777 Hollywood Boulevard, Dayton, Ohio
82.7 Jackpot Charity Bingo  find on map
3183 Irvine Road, Richmond, Kentucky
85.6 Southland Bingo  find on map
2360 South Dixie Boulevard, Radcliff, Kentucky
85.9 Huber Heights Bingo  find on map
6428 Chambersburg Road, Dayton, Ohio
92.2 French Lick Resort  find on map
8670 West State Road 56, French Lick, Indiana
94.3 Winner's Circle Pub, Grille & OTB Indianapolis  find on map
20 North Pennsylvania Street, Suite 2, Indianapolis, Indiana
94.8 Agape Church Bingo  find on map
1500 US 22 Northwest, Washington Court House, Ohio
96.5 Harrah's Hoosier Park Racing & Casino  find on map
4500 Dan Patch Circle, Anderson, Indiana
99.4 United Bingo  find on map
125 West Main Street, Springfield, Ohio
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 /map.cfm
Time Stamp 09-May-21 04:38 PM
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
96 ms 96 ms 1 top level D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm
85 ms 85 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/mapPageContents.cfm
18 ms 9 ms 2 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/MicroLeftNavQueries.cfm
1 ms 1 ms 1 D:/ClusterSites/htdocs/minisites.casinocity.com/htdocs/Application.cfm
1 ms 1 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/footerMicro.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/legal.cfm
0 ms 0 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/mappingfunctions.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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
98 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GetPropertyID (Datasource=GamingProperties-RO-CasinoCity, Time=1ms, Records=1) in D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm @ 16:38:45.045
		SELECT Property.PropertyId, Longitude, Latitude			-- Property.OrganizationName, Countries.PlaceName Country, States.PlaceName State
		FROM Property
		INNER JOIN ActivePropertyMiniSites ON ActivePropertyMiniSites.PropertyId = Property.PropertyId
		WHERE ActivePropertyMiniSites.FQDN = 'belterra.casinocity.com'
	
Property (Datasource=GamingProperties-RO-CasinoCity, Time=4ms, Records=1) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 16:38:45.045
	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) = 512500

getCCRegion (Datasource=GamingProperties-RO-CasinoCity, Time=1ms, Records=0) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 16:38:45.045
	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=10) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 16:38:45.045
	SELECT * FROM PropertyNavigation 
	WHERE  PropertyId=?
	  AND  Active=1
	ORDER BY SortOrder
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 512500

Nearby (Datasource=GamingProperties-RO-CasinoCity, Time=73ms, Records=45) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\mapPageContents.cfm @ 16:38:46.046
				DECLARE @GeoLocation Geography;
				SELECT @GeoLocation = GeoLocation FROM Property WHERE Property.PropertyId = 512500;
				SELECT TOP 100 Property.PropertyId,
				Property.OrganizationName,
				Property.CCURL,
				 Property.Address1,
				 Property.Address2,
				 Property.City,
				 Property.StateName,
				 Property.CountryName,
				 Property.PostalCode,
				 Property.Country AS CountryCode,
				
				 Property.PropertyId as CasinoId,
				 Property.Latitude, Property.Longitude,
				 Property.Geolocation.STDistance(@GeoLocation)/1609.344  Distance
				FROM Property
				INNER JOIN PropertyStatusTypes	ON Property.PropertyStatusTypeId = PropertyStatusTypes.PropertyStatusTypeID
				WHERE Property.Latitude IS NOT NULL 
				and Property.Longitude IS NOT null
				AND Property.Geolocation.STDistance(@GeoLocation)/1609.344  <= 100
				AND Property.PropertyStatusTypeId = 1
				AND Property.PropertyId <> 512500
				ORDER BY Property.Geolocation.STDistance(@GeoLocation)
			
Property (Datasource=GamingProperties-RO-CasinoCity, Time=4ms, Records=1) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 16:38:46.046
	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) = 512500

getCCRegion (Datasource=GamingProperties-RO-CasinoCity, Time=1ms, Records=0) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 16:38:46.046
	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=0ms, Records=10) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 16:38:46.046
	SELECT * FROM PropertyNavigation 
	WHERE  PropertyId=?
	  AND  Active=1
	ORDER BY SortOrder
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 512500


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\map.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=belterra.casinocity.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=/map.cfm
PATH_TRANSLATED=D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm
QUERY_STRING=site=belterra&nearest=OK
REMOTE_ADDR=216.116.192.60
REMOTE_HOST=216.116.192.60
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/map.cfm
SERVER_NAME=belterra.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:
nearest=OK
site=belterra
Debug Rendering Time: 13 ms