Visit Casino City's Internet Directory
Casino City HomeWorld GamblingAmerican GamblingCalifornian Gambling
Cache Creek Casino Resort
Nearby Casinos
NewsTweetsMapExecutivesOwnership
Sign up for the
Casino City Times
Weekly Newsletter!
Casino City Home
World Gambling
American Gambling
Californian Gambling
Cache Creek Casino Resort
NewsTweetsMapExecutivesOwnership

Casinos Near Cache Creek Casino Resort

There are 69 casinos within 100 miles of Cache Creek Casino Resort

Map Index Distance (miles) Casino
  Cache Creek Casino Resort  find on map
14455 State Highway 16, Brooks, California
26.1 Twin Pine Casino & Hotel  find on map
22223 Highway 29, Middletown, California
28.0 Vaca Valley Bingo  find on map
190 Belle Vista Road, Vacaville, California
31.0 Napa Bingo Emporium  find on map
575 Third Street, Napa, California
36.4 Colusa Casino Resort  find on map
3770 Highway 45, Colusa, California
36.9 Sonoma County Fairgrounds  find on map
1350 Bennett Valley Road, Santa Rosa, California
37.2 Capitol Casino  find on map
411 North 16th Street, Sacramento, California
38.2 Limelight Cardroom  find on map
1014 Alhambra Boulevard, Sacramento, California
38.8 River Rock Casino  find on map
3250 Highway 128, Geyserville, California
39.3 Florin Road Bingo  find on map
2350 Florin Road, Sacramento, California
39.3 Napa Valley Casino  find on map
3466 Broadway Street, Highway 29, American Canyon, California
39.4 Cal Expo  find on map
1600 Exposition Boulevard, Sacramento, California
40.3 Hard Rock Hotel & Casino - Sacramento at Fire Mountain  find on map
3317 Forty Mile Road, Wheatland, California
40.7 Graton Resort & Casino  find on map
288 Golf Course Drive West, Rohnert Park, California
40.7 Casino Marysville  find on map
515 Fourth Street, Marysville, California
40.9 Parkwest Casino Lotus  find on map
6010 Stockton Boulevard, Sacramento, California
41.5 Solano Race Place  find on map
900 Fairgrounds Drive, Vallejo, California
42.0 Sacramento Bingo Center  find on map
3399 Arden Way, Sacramento, California
42.4 777 Bingo  find on map
777 Sereno Drive, Vallejo, California
42.8 Parkwest Casino Sonoma  find on map
5151 Montero Way, Petaluma, California
44.8 The Tavern at Stones Gambling Hall  find on map
6508 Antelope Road, Citrus Heights, California
44.8 Konocti Vista Casino Resort, Marina & RV Park  find on map
2755 Mission Rancheria Road, Lakeport, California
44.9 The Saloon at Stones Gambling Hall  find on map
6510 Antelope Road, Citrus Heights, California
45.3 Thunder Valley Casino Resort  find on map
1200 Athens Avenue, Lincoln, California
46.0 Grand Oaks Palace Bingo Center  find on map
7919 Auburn Boulevard, Citrus Heights, California
47.4 Parkwest Casino Cordova  find on map
2801 Prospect Park Drive, Rancho Cordova, California
48.8 Robinson Rancheria Resort & Casino  find on map
1545 East Highway 20, Nice, California
49.0 Rogelio's Dine and Sleep Inn  find on map
34 Main Street, Isleton, California
50.3 Blue Devils Bingo - Concord  find on map
4065 Nelson Avenue, Concord, California
50.5 Running Creek Casino  find on map
635 East State Highway 20, Upper Lake, California
52.1 California Grand Casino  find on map
5988 Pacheco Boulevard, Pacheco, California
52.9 FLB Entertainment Center  find on map
511 East Bidwell Street, Folsom, California
54.1 Nineteenth Hole  find on map
2746 West Tregallas Road, Antioch, California
55.0 San Pablo Lytton Casino  find on map
13255 San Pablo Avenue, San Pablo, California
56.8 Pete's 881 Club  find on map
721 Lincoln Avenue, San Rafael, California
59.3 Golden Gate Fields  find on map
1100 Eastshore Highway, Berkeley, California
60.7 Feather Falls Casino & Lodge  find on map
3 Alverda Drive, Oroville, California
62.7 Oaks Card Club  find on map
4097 San Pablo Avenue, Emeryville, California
63.2 Gold Country Casino Resort  find on map
4020 Olive Highway, Oroville, California
64.3 Parkwest Casino Lodi  find on map
1800 South Cherokee Lane, Lodi, California
66.7 Red Hawk Casino  find on map
1 Red Hawk Parkway, Placerville, California
67.1 Towers Casino  find on map
115 Bank Street, Grass Valley, California
67.6 Coyote Valley Casino  find on map
455 Coyote Valley Boulevard, Redwood Valley, California
67.9 Westlane Card Room  find on map
6111 Westlane, Suite 101, Stockton, California
67.9 Kings Card Club  find on map
6111 West Lane, Suite 103, Stockton, California
67.9 Coyote Valley One Stop Shop  find on map
60 Coyote Valley Boulevard, Redwood Valley, California
68.4 Foothill Square Bingo  find on map
10700 Macarthur Boulevard, Suite 111, Oakland, California
70.1 Casino 99  find on map
175 East 20th Street, Suite 150, Chico, California
72.6 Casino Chico  find on map
968 East Avenue, Chico, California
72.8 San Joaquin County Fairgrounds  find on map
1658 South Airport Way, Stockton, California
73.3 Parkwest Casino 580  find on map
968 North Canyons Parkway, Livermore, California
73.5 The Palace Poker Casino  find on map
2281 Mission Boulevard, Hayward, California
73.9 Harrah's Northern California  find on map
4640 Coal Mine Road, Ione, California
74.7 Lucky Chances Casino  find on map
1700 Hillside Boulevard, Colma, California
75.2 Livermore Casino  find on map
3571 First Street, Livermore, California
75.2 Alameda County Fairgrounds  find on map
4501 Pleasanton Avenue, Pleasanton, California
75.9 Bingo Ranch  find on map
3070 Pacific Avenue, Livermore, California
77.3 Stars Casino  find on map
775 West Clover Road, Tracy, California
77.7 Artichoke Joe's Casino  find on map
659 Huntington Avenue, San Bruno, California
78.7 Rolling Hills Casino Resort  find on map
2655 Everett Freeman Way, Corning, California
79.9 Sherwood Valley Casino  find on map
100 Kawi Place, Willits, California
79.9 Jackson Rancheria Casino Resort  find on map
12222 New York Ranch Road, Jackson, California
80.8 Casino Real  find on map
1355 North Main Street, Manteca, California
82.3 Jockey Club  find on map
2495 South Delaware Street, San Mateo, California
84.7 Garcia River Casino  find on map
22215 Windy Hollow Road, Point Arena, California
94.2 Modesto Poker Room and Casino  find on map
5001 McHenry Avenue, Modesto, California
94.5 Hidden Oaks Casino  find on map
76700 Covelo Road, Covelo, California
94.8 Casino M8trix  find on map
1887 Matrix Boulevard, San Jose, California
94.8 Bay 101 Casino  find on map
1788 North First Street, San Jose, California
97.2 Red Fox Casino  find on map
200 Cahto Drive, Laytonville, California
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 11-May-21 09:53 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
108 ms 108 ms 1 top level D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm
93 ms 93 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/mapPageContents.cfm
13 ms 7 ms 2 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/MicroLeftNavQueries.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/footerMicro.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
109 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GetPropertyID (Datasource=GamingProperties-RO-CasinoCity, Time=8ms, Records=1) in D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm @ 09:53:09.009
		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 = 'cachecreek.casinocity.com'
	
Property (Datasource=GamingProperties-RO-CasinoCity, Time=3ms, Records=1) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 09:53:09.009
	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) = 42500

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

Nearby (Datasource=GamingProperties-RO-CasinoCity, Time=81ms, Records=69) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\mapPageContents.cfm @ 09:53:09.009
				DECLARE @GeoLocation Geography;
				SELECT @GeoLocation = GeoLocation FROM Property WHERE Property.PropertyId = 42500;
				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 <> 42500
				ORDER BY Property.Geolocation.STDistance(@GeoLocation)
			
Property (Datasource=GamingProperties-RO-CasinoCity, Time=3ms, Records=1) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 09:53:09.009
	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) = 42500

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


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=cachecreek.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=cachecreek&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=cachecreek.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=cachecreek
Debug Rendering Time: 15 ms