SELECT *
		FROM biz_types 
	 WHERE biztype_id = 5 

	SELECT *
	FROM (city c INNER JOIN zipcodes z ON c.cityid = z.cityid) INNER JOIN state s ON c.StateID = s.StateID
	WHERE c.cityid = 179 

	SELECT *
	FROM zipcodes
	WHERE cityid = 179 

		 SELECT DISTINCT bt.biztype_id
		 FROM biz_contacts bc INNER JOIN biz_types bt ON bc.type = bt.biztype_id
		WHERE bc.zip IN (99676)
			AND bt.lodging = 1
			AND bc.active = 1
			AND bc.zip <> ''
		ORDER BY bt.biztype_desc
	

					SELECT *
						FROM biz_types
					 WHERE biztype_id = '5'
				

					SELECT *
						FROM biz_types
					 WHERE biztype_id = '2'
				

	SELECT * 
		FROM zipcodes 
	 WHERE zipcode = 99676 

	SELECT DISTINCT z.cityid
		FROM zipcodes z 
	 WHERE (latitude >= 61.9713827886 AND latitude <= 62.5496514522) AND (longitude >= -150.483862761 AND longitude <= -149.736321565) AND z.cityid <> 0  
	 ORDER BY z.city

 
			SELECT biztype_desc
				FROM biz_types 
			 WHERE biztype_id = 5 

				SELECT city
					FROM city
				 WHERE cityid = 179 

					 SELECT cityid
						 FROM biz_contacts  
						WHERE cityid IN (179)
							AND type = 5
							AND active = 1
						LIMIT 1
				

	SELECT * 
		FROM zipcodes 
	 WHERE zipcode = 99676 

	SELECT DISTINCT z.cityid
		FROM zipcodes z 
	 WHERE (latitude >= 60.8148454613 AND latitude <= 63.7061887794) AND (longitude >= -151.978945151 AND longitude <= -148.241239175) AND z.cityid <> 0  
	 ORDER BY z.city

	SELECT DISTINCT c.cityid, c.city, s.state_name
	FROM (city c INNER JOIN state s ON c.StateID = s.StateID) INNER JOIN town_run tr ON c.cityid = tr.cityid
	WHERE c.cityid IN (173,5745,175,809,2690,2695,3602,179,2687,2683) AND c.cityid <> 179
	ORDER BY c.city

	SELECT * 
		FROM zipcodes 
	 WHERE zipcode = 99676 

	SELECT DISTINCT z.cityid
		FROM zipcodes z 
	 WHERE (latitude >= 61.9713827886 AND latitude <= 62.5496514522) AND (longitude >= -150.483862761 AND longitude <= -149.736321565) AND z.cityid <> 0  
	 ORDER BY z.city

   SELECT bc.active, bc.listingnumber, bc.paytype, bc.type, bc.bizamens, bc.pets, bc.bizname, bc.description, bp.listingnumber, bp.mainphoto, bc.website, bc.state, bc.city, bc.zip, bc.fac_ratelo, bc.fac_ratehi
	 FROM (biz_contacts bc LEFT OUTER JOIN biz_photos bp ON bc.listingnumber = bp.listingnumber) INNER JOIN biz_types bt ON bc.type = bt.biztype_id
	WHERE bc.paytype = 'premium'
	  AND bc.active = 1
		AND bc.type = 5
		AND bc.cityid IN (179)
		

   SELECT bc.active, bc.listingnumber, bc.paytype, bc.type, bc.bizamens, bc.pets, bc.bizname, bc.description, bp.listingnumber, bp.mainphoto, bc.website, bc.state, bc.city, bc.zip, bc.fac_ratelo, bc.fac_ratehi
	 FROM (biz_contacts bc LEFT OUTER JOIN biz_photos bp ON bc.listingnumber = bp.listingnumber) INNER JOIN biz_types bt ON bc.type = bt.biztype_id
	WHERE bc.paytype = 'booking'
	  AND bc.active = 1
		AND bc.type = 5
		AND bc.cityid IN (179)
		GROUP BY bc.listingnumber

   SELECT DISTINCT bc.listingnumber, bc.active, bc.paytype, bc.bizname, bc.address1, bc.address2, bc.city, bc.state, bc.zip, bc.biz_phone1
	 FROM (biz_contacts bc LEFT OUTER JOIN biz_photos bp ON bc.listingnumber = bp.listingnumber) INNER JOIN biz_types bt ON bc.type = bt.biztype_id
	WHERE bc.paytype = 'free'
	  AND bc.active = 1
		AND bc.type = 5
		AND bc.cityid = 179
	ORDER BY bc.bizname

			SELECT *
			FROM biz_types
			WHERE lodging = 1
			ORDER BY biztype_id
		

						SELECT bc.state, bc.city, bc.zip, s.name, s.abv, bt.*
							FROM (biz_contacts bc INNER JOIN states s ON bc.state = s.abv) INNER JOIN biz_types bt ON bc.type = bt.biztype_id
						 WHERE bc.active = 1
							AND bt.lodging = 1
						ORDER BY bc.state
					

							 SELECT Distinct cityid
								 FROM biz_contacts bc INNER JOIN biz_types bt ON bc.type = bt.biztype_id
								WHERE bc.paytype = 'premium'	
									AND lodging = 1
									AND active = 1
						

							SELECT DISTINCT c.cityid, c.zip, c.city, s.state_name, s.state_abv
								FROM (city c INNER JOIN zipcodes z ON c.zip = z.zipcode) INNER JOIN state s ON c.StateID = s.StateID
							 WHERE c.cityid IN (25,45,4930,209,5748,180,67,89,102,125,108,204,116,5749,246,5109,140,5461,4814,27,205,171,4942) OR c.lodgehome = 1
							ORDER BY c.city
						

							SELECT bc.state, s.name, s.abv, bt.*
								FROM (biz_contacts bc INNER JOIN states s ON bc.state = s.abv) INNER JOIN biz_types bt ON bc.type = bt.biztype_id
							 WHERE bc.active = 1
								AND bc.type = 2
							ORDER BY bc.state
						

							SELECT bc.state, s.name, s.abv, bt.*
								FROM (biz_contacts bc INNER JOIN states s ON bc.state = s.abv) INNER JOIN biz_types bt ON bc.type = bt.biztype_id
							 WHERE bc.active = 1
								AND bc.type = 3
							ORDER BY bc.state
						

							SELECT bc.state, s.name, s.abv, bt.*
								FROM (biz_contacts bc INNER JOIN states s ON bc.state = s.abv) INNER JOIN biz_types bt ON bc.type = bt.biztype_id
							 WHERE bc.active = 1
								AND bc.type = 4
							ORDER BY bc.state
						

							SELECT bc.state, s.name, s.abv, bt.*
								FROM (biz_contacts bc INNER JOIN states s ON bc.state = s.abv) INNER JOIN biz_types bt ON bc.type = bt.biztype_id
							 WHERE bc.active = 1
								AND bc.type = 5
							ORDER BY bc.state
						

							SELECT bc.state, s.name, s.abv, bt.*
								FROM (biz_contacts bc INNER JOIN states s ON bc.state = s.abv) INNER JOIN biz_types bt ON bc.type = bt.biztype_id
							 WHERE bc.active = 1
								AND bc.type = 33
							ORDER BY bc.state
						

							SELECT bc.state, s.name, s.abv, bt.*
								FROM (biz_contacts bc INNER JOIN states s ON bc.state = s.abv) INNER JOIN biz_types bt ON bc.type = bt.biztype_id
							 WHERE bc.active = 1
								AND bc.type = 34
							ORDER BY bc.state
						

							SELECT bc.state, s.name, s.abv, bt.*
								FROM (biz_contacts bc INNER JOIN states s ON bc.state = s.abv) INNER JOIN biz_types bt ON bc.type = bt.biztype_id
							 WHERE bc.active = 1
								AND bc.type = 35
							ORDER BY bc.state
						

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=/home/locallod/public_html/businesses/showtown.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=Accept: application/xhtml+xml,text/html;q=0.9,text/plain;
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.locallodgingguide.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=
PATH_TRANSLATED=/home/locallod/public_html/businesses/showtown.cfm
QUERY_STRING=biztype_id=5&cityid=179
REMOTE_ADDR=38.103.63.61
REMOTE_HOST=38.103.63.61
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/businesses/showtown.cfm
SERVER_NAME=locallodgingguide.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache/1.3.41 (Unix) JRun/4.0 PHP/4.4.6 mod_log_bytes/1.2 mod_bwlimited/1.4 mod_auth_passthrough/1.8 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.7a
WEB_SERVER_API=

Client Variables:
cfid=8607480
cftoken=89668108
hitcount=1
lastvisit={ts '2008-12-03 16:12:53'}
timecreated={ts '2008-12-03 16:12:53'}
urltoken=CFID=8607480&CFTOKEN=89668108

Cookie Variables:
CFID=8607480
CFTOKEN=89668108
LANGUAGE=english

Session Variables:
cfid=8607480
cftoken=89668108
sessionid=LOCALLODGINGGUIDE_8607480_89668108
urltoken=CFID=8607480&CFTOKEN=89668108

URL Parameters:
BIZTYPE_ID=5
CITYID=179