Visit Casino City's Internet Directory
Casino City HomeWorld GamblingAmerican GamblingLouisiana Gambling
Coushatta Casino Resort
Nearby Casinos
Hotel ReservationsEntertainmentNewsTweetsMapExecutivesOwnership
Sign up for the
Casino City Times
Weekly Newsletter!
Casino City Home
World Gambling
American Gambling
Louisiana Gambling
Coushatta Casino Resort
Hotel ReservationsEntertainmentNewsTweetsMapExecutivesOwnership

Casinos Near Coushatta Casino Resort

There are 99 casinos within 100 miles of Coushatta Casino Resort

Map Index Distance (miles) Casino
  Coushatta Casino Resort  find on map
777 Coushatta Drive, Kinder, Louisiana
0.0 Coushatta Casino Resort  find on map
777 Coushatta Drive, Kinder, Louisiana
20.8 Peto's I-10 Travel Center and Casino  find on map
15125 Highway 395, Roanoke, Louisiana
22.4 Eunice Truckstop & Casino  find on map
1673 Highway 190, Eunice, Louisiana
23.4 Pilot Travel Center Casino #1051  find on map
1119 Lowe Grout Road, Suite A, Iowa, Louisiana
23.7 Jennings Truck Stop Casino  find on map
1919 Evangeline Road, Jennings, Louisiana
24.0 Bayou Gold Casino  find on map
241 West Maple Avenue, Suite A, Eunice, Louisiana
24.8 Races and Aces - Eunice  find on map
1051 East Laurel Avenue, Eunice, Louisiana
26.2 Cash Magic Eunice  find on map
3747 Highway 190, Eunice, Louisiana
26.9 Gillis Truck Stop and Buddy's Casino  find on map
6191C North Highway 171, Moss Bluff, Louisiana
28.3 Cash Magic Lake Charles  find on map
108 Highway 397, Lake Charles, Louisiana
33.3 Rice Palace Casino  find on map
2015 Rice Capital Parkway, Crowley, Louisiana
33.6 Isle of Capri Casino Hotel - Lake Charles  find on map
100 Westlake Avenue, Westlake, Louisiana
35.3 L'Auberge Casino Resort Lake Charles  find on map
777 Avenue L'Auberge, Lake Charles, Louisiana
35.7 Golden Nugget - Lake Charles  find on map
2550 Golden Nugget Boulevard, Lake Charles, Louisiana
36.1 Crowley Truck Stop Casino  find on map
9002 South LA 13, Crowley, Louisiana
38.1 Cash Magic Winner's Choice   find on map
2654 Highway 108, Sulphur, Louisiana
38.3 Miss Mamie's Casino - Rayne  find on map
1044 Church Point Highway, Rayne, Louisiana
38.3 Sulphur Truck Stop Casino  find on map
2510 South Cities Service Highway, Sulphur, Louisiana
38.4 Frog City Travel Plaza and Casino  find on map
1418 North Polk Street, Rayne, Louisiana
38.6 Royal Palace Casino  find on map
504 North Beglis Parkway, Sulphur, Louisiana
39.8 Wagin' Cajun Casino  find on map
2706 South Beglis Parkway, Sulphur, Louisiana
40.7 Jackpot Junction Casino  find on map
2706 Ruth Street, Sulphur, Louisiana
42.4 Black Gold Casino  find on map
137 Frontage Road, Rayne, Louisiana
42.4 Lucky Deuces Casino  find on map
3002 Daulaut Drive, Suite B, Duson, Louisiana
42.6 Lucky Sam's Casino  find on map
3601 Highway 115 West, Bunkie, Louisiana
42.6 Miss Mamie's Casino - Duson  find on map
257 Austria Road, Duson, Louisiana
43.9 Ace High Club #9  find on map
528 East Landry Street, Opelousas, Louisiana
44.1 Ace High Club #10  find on map
120 South Academy Street, Opelousas, Louisiana
44.4 Ace High Club #11  find on map
1323 Creswell Lane, Opelousas, Louisiana
45.1 Singh Quick Stop  find on map
547 B Country Rodge Road, Opelousas, Louisiana
45.1 Evangeline Downs Racetrack Casino Hotel  find on map
2235 Creswell Lane Extension, Opelousas, Louisiana
45.5 Gator Gold Casino  find on map
227 Highway 167, Opelousas, Louisiana
45.8 Gold Rush Casino  find on map
8412 I-49 North Service Road, Suite B, Opelousas, Louisiana
45.8 The Quarters Travel Plaza & Casino  find on map
165 Highway 744, Opelousas, Louisiana
46.3 Beau Chene Truck Plaza  find on map
1828 Frontage Road, Grand Coteau, Louisiana
46.3 Go Bears Truck Stop  find on map
1672 North Service Road, Grand Coteau, Louisiana
46.5 Ace in the Hole  find on map
106 St. Charles Street, Grand Coteau, Louisiana
48.5 King's Casino  find on map
16470 Highway 190, Port Barre, Louisiana
51.2 Ace High Club #2  find on map
552 North Saizon Street, Port Barre, Louisiana
52.9 Love's Casino 362  find on map
2024 West Street, Vinton, Louisiana
53.2 Stark's Silver Dollar  find on map
4346 Highway 12, Starks, Louisiana
54.0 Damico's Bingo World  find on map
4810 Lee Street, Alexandria, Louisiana
54.1 Delta Downs Racetrack Casino & Hotel  find on map
2717 Delta Downs Drive, Vinton, Louisiana
55.2 Cash Magic Breaux Bridge  find on map
1869 Mills Highway, Breaux Bridge, Louisiana
55.9 Cash Magic Vinton  find on map
2334 Highway 109 South, Vinton, Louisiana
55.9 Lucky Longhorn Casino  find on map
2374 Highway 109 South, Vinton, Louisiana
55.9 Cottons Corner Bingo  find on map
2360 Highway 109 South, Vinton, Louisiana
56.2 Silver's Travel Center Casino  find on map
2243 Rees Street, Breaux Bridge, Louisiana
56.3 Cash Magic Texas Pelican   find on map
2217 Old Highway 90, Vinton, Louisiana
56.5 Mardi Gras Bingo  find on map
701 Bolton Avenue, Alexandria, Louisiana
58.1 LJ's Casino  find on map
7974 Highway 1, Mansura, Louisiana
59.2 Paragon Casino Resort  find on map
711 Paragon Place, Marksville, Louisiana
60.6 Cash Magic Broussard North  find on map
1144 Highway 90 East, Broussard, Louisiana
60.7 Atchafalaya Gold Casino  find on map
2996 Grand Point Highway, Breaux Bridge, Louisiana
60.8 Joey's Sports Bar and Casino  find on map
1115 Terrace Highway, Broussard, Louisiana
60.8 Miss Mamie's Casino - Henderson  find on map
3003 Grand Point Highway, Breaux Bridge, Louisiana
60.8 The Big Easy Casino  find on map
1025 Smede Highway, Broussard, Louisiana
60.9 Races and Aces - Henderson  find on map
2939 A Grand Point Highway, Breaux Bridge, Louisiana
61.2 Lucky Dollar Casino - Broussard  find on map
1040 Baker Hughes Road, Broussard, Louisiana
61.3 Cash Magic Broussard South  find on map
1050 Baker Hughes Drive, Broussard, Louisiana
61.4 St. Martin Truck and Casino Plaza  find on map
1339 Southeast Evangeline Throughway, Broussard, Louisiana
64.4 Jena Choctaw Pines Casino  find on map
149 Chahta Trail, Dry Prong, Louisiana
64.5 Spanish Lake Casino and Travel Center  find on map
1907 West Old Spanish Trail, New Iberia, Louisiana
65.1 Players Club Deli #7  find on map
1006 Par Road, Saint Martinville, Louisiana
65.4 Races and Aces - St. Martinville  find on map
2308 North Main Street, Saint Martinville, Louisiana
65.8 Beno's Casino and Motel  find on map
1178 Clover Hill Road, Saint Martinville, Louisiana
65.9 Lucky Rose Casino  find on map
15944 Highway 1, Simmesport, Louisiana
68.4 Bayou Teche Casino  find on map
7783 Main Highway, Saint Martinville, Louisiana
71.6 LA Express #8  find on map
5002 Highway 1, Batchelor, Louisiana
75.0 LA Express #11  find on map
8203 Airline Highway, Livonia, Louisiana
80.4 Pablo's Cantinasino  find on map
2490 Morganza Highway, New Roads, Louisiana
80.5 Mid-River Truck Stop  find on map
1942 Hospital Road, New Roads, Louisiana
82.0 Myrna's Bar and Grill  find on map
21429 Highway 182, Jeanerette, Louisiana
82.8 Grand Bayou Casino  find on map
17545 Sidney Road, Grosse Tete, Louisiana
82.9 LA Express Daiquiri Shop  find on map
708 New Roads Street, New Roads, Louisiana
83.9 Landry's Auto Truck Stop  find on map
20355 Highway 90 Frontage Road, Jeanerette, Louisiana
83.9 LA Express #7  find on map
12610 Highway 190 West, Erwinville, Louisiana
84.5 Bingo Paradise 3  find on map
830 Keyser Avenue, Natchitoches, Louisiana
85.3 11th Street Bingo  find on map
3250 South 11th Street, Beaumont, Texas
85.5 Texas Poker Club  find on map
5395 Highway 105, Beaumont, Texas
86.8 Bingo Paradise 1  find on map
201 Highway 3175 Bypass, Natchitoches, Louisiana
88.0 Miko's Gaming  find on map
3020 Hina Chahta Street, Jena, Louisiana
89.3 Cypress Bayou Casino Hotel  find on map
832 Martin Luther King Road, Charenton, Louisiana
89.9 Silver's Travel Plaza & Casino - Port Allen  find on map
6742 US Highway 190 West, Port Allen, Louisiana
92.5 Fred's Travel Center Casino  find on map
15169 Highway 61, Saint Francisville, Louisiana
92.6 Players Paradise Casino  find on map
1401 Northwest Boulevard, Franklin, Louisiana
93.2 Lucky Dollar Casino - Port Allen  find on map
3051 Lobdell Highway, Port Allen, Louisiana
93.7 Emerald Palace Casino  find on map
347 Lobdell Highway, Port Allen, Louisiana
93.7 Cash's Truck Plaza  find on map
420 Lobdell Highway, Port Allen, Louisiana
93.8 Nino's Casino  find on map
121 North Lobdell Highway, Port Allen, Louisiana
93.8 LA Express #91  find on map
220 Highway 415, Port Allen, Louisiana
93.9 415 South Casino  find on map
940 Lobdell Highway South, Port Allen, Louisiana
94.0 Gator's Den - Port Allen  find on map
751 Lobdell Highway, Port Allen, Louisiana
95.7 LA 1 South Truck Plaza & Casino  find on map
3191 Highway 1 South, Port Allen, Louisiana
96.1 Lucky Louie's Truck Stop  find on map
4169 North River Road, Port Allen, Louisiana
96.9 Hollywood Casino - Baton Rouge  find on map
1717 River Road North, Baton Rouge, Louisiana
97.0 Fat Tuesday's Casino  find on map
25394 Highway 1, Plaquemine, Louisiana
97.0 Belle of Baton Rouge Casino Hotel  find on map
103 France Street, Baton Rouge, Louisiana
99.3 Jubilee Casino  find on map
1032 Highway 317, Franklin, Louisiana
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 16-Apr-21 06:11 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
14 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
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
108 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\map.cfm @ 06:11:48.048
		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 = 'grandcoushatta.casinocity.com'
	
Property (Datasource=GamingProperties-RO-CasinoCity, Time=4ms, Records=1) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 06:11:48.048
	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) = 38800

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

Nearby (Datasource=GamingProperties-RO-CasinoCity, Time=82ms, Records=99) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\mapPageContents.cfm @ 06:11:48.048
				DECLARE @GeoLocation Geography;
				SELECT @GeoLocation = GeoLocation FROM Property WHERE Property.PropertyId = 38800;
				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 <> 10600
				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 @ 06:11:48.048
	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) = 38800

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


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