SELECT *
	FROM city
	WHERE cityid = 181 

	SELECT *
		FROM state
	 WHERE StateID = '43' 

	SELECT *
	FROM zipcodes
	WHERE cityid = 181 

	SELECT * 
		FROM zipcodes 
	 WHERE zipcode = 97201 

	SELECT DISTINCT z.cityid
		FROM zipcodes z 
	 WHERE (latitude >= 45.209683112 AND latitude <= 45.7879517757) AND (longitude >= -122.98352435 AND longitude <= -122.396984073) AND z.cityid <> 0  
	 ORDER BY z.city

				 SELECT DISTINCT cityid
					 FROM biz_contacts bc INNER JOIN biz_types bt ON bc.type = bt.biztype_id
					WHERE cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
						AND lodging = 1
						AND active = 1
					LIMIT 1
			

					SELECT city
						FROM city c 
					 WHERE cityid = 4130 

				 SELECT DISTINCT cityid
					 FROM biz_contacts bc INNER JOIN biz_types bt ON bc.type = bt.biztype_id
					WHERE cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
						AND lodging = 1
						AND active = 1
					LIMIT 1
			

					SELECT city
						FROM city c 
					 WHERE cityid = 4128 

				 SELECT DISTINCT cityid
					 FROM biz_contacts bc INNER JOIN biz_types bt ON bc.type = bt.biztype_id
					WHERE cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
						AND lodging = 1
						AND active = 1
					LIMIT 1
			

					SELECT city
						FROM city c 
					 WHERE cityid = 4140 

				 SELECT DISTINCT cityid
					 FROM biz_contacts bc INNER JOIN biz_types bt ON bc.type = bt.biztype_id
					WHERE cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
						AND lodging = 1
						AND active = 1
					LIMIT 1
			

					SELECT city
						FROM city c 
					 WHERE cityid = 4110 

				 SELECT DISTINCT cityid
					 FROM biz_contacts bc INNER JOIN biz_types bt ON bc.type = bt.biztype_id
					WHERE cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
						AND lodging = 1
						AND active = 1
					LIMIT 1
			

					SELECT city
						FROM city c 
					 WHERE cityid = 4685 

				 SELECT DISTINCT cityid
					 FROM biz_contacts bc INNER JOIN biz_types bt ON bc.type = bt.biztype_id
					WHERE cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
						AND lodging = 1
						AND active = 1
					LIMIT 1
			

					SELECT city
						FROM city c 
					 WHERE cityid = 4129 

				 SELECT DISTINCT cityid
					 FROM biz_contacts bc INNER JOIN biz_types bt ON bc.type = bt.biztype_id
					WHERE cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
						AND lodging = 1
						AND active = 1
					LIMIT 1
			

					SELECT city
						FROM city c 
					 WHERE cityid = 4119 

				 SELECT DISTINCT cityid
					 FROM biz_contacts bc INNER JOIN biz_types bt ON bc.type = bt.biztype_id
					WHERE cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
						AND lodging = 1
						AND active = 1
					LIMIT 1
			

					SELECT city
						FROM city c 
					 WHERE cityid = 4153 

				 SELECT DISTINCT cityid
					 FROM biz_contacts bc INNER JOIN biz_types bt ON bc.type = bt.biztype_id
					WHERE cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
						AND lodging = 1
						AND active = 1
					LIMIT 1
			

					SELECT city
						FROM city c 
					 WHERE cityid = 181 

				 SELECT DISTINCT cityid
					 FROM biz_contacts bc INNER JOIN biz_types bt ON bc.type = bt.biztype_id
					WHERE cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
						AND lodging = 1
						AND active = 1
					LIMIT 1
			

					SELECT city
						FROM city c 
					 WHERE cityid = 4141 

				 SELECT DISTINCT cityid
					 FROM biz_contacts bc INNER JOIN biz_types bt ON bc.type = bt.biztype_id
					WHERE cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
						AND lodging = 1
						AND active = 1
					LIMIT 1
			

					SELECT city
						FROM city c 
					 WHERE cityid = 4559 

				 SELECT DISTINCT cityid
					 FROM biz_contacts bc INNER JOIN biz_types bt ON bc.type = bt.biztype_id
					WHERE cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
						AND lodging = 1
						AND active = 1
					LIMIT 1
			

					SELECT city
						FROM city c 
					 WHERE cityid = 4108 

	SELECT * 
		FROM zipcodes 
	 WHERE zipcode = 97201 

	SELECT DISTINCT z.cityid
		FROM zipcodes z 
	 WHERE (latitude >= 44.0531457848 AND latitude <= 46.9444891029) AND (longitude >= -124.156604905 AND longitude <= -121.223903518) 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 (4671,4672,4607,4130,67,4673,4674,363,4148,5667,4116,4588,4560,4128,4142,3088,4677,4109,4679,4155,4126,4120,4140,4144,5669,4110,4151,4685,79,5671,4602,4548,4129,4687,4107,5675,5676,5677,4149,81,4114,4119,4689,4609,4153,4152,181,4115,4691,5687,4136,4692,87,4694,197,4156,4123,4143,5688,4122,4141,4559,4147,5691,4132,80,4108,4137,5692,4154) AND c.cityid <> 181
	ORDER BY c.city
	

						SELECT bt.*
						FROM biz_types bt
						WHERE lodging = 1
						ORDER BY biztype_desc	
					

	SELECT * 
		FROM zipcodes 
	 WHERE zipcode = 97201 

	SELECT DISTINCT z.cityid
		FROM zipcodes z 
	 WHERE (latitude >= 45.209683112 AND latitude <= 45.7879517757) AND (longitude >= -122.98352435 AND longitude <= -122.396984073) AND z.cityid <> 0  
	 ORDER BY z.city

									SELECT listingnumber
										FROM biz_contacts bc INNER JOIN biz_types bt ON bc.type = bt.biztype_id
									 WHERE cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
										AND paytype <> 'free'
										AND bt.lodging = 1
								

	SELECT * 
		FROM zipcodes 
	 WHERE zipcode = 97201 

	SELECT DISTINCT z.cityid
		FROM zipcodes z 
	 WHERE (latitude >= 45.209683112 AND latitude <= 45.7879517757) AND (longitude >= -122.98352435 AND longitude <= -122.396984073) AND z.cityid <> 0  
	 ORDER BY z.city

									SELECT listingnumber
										FROM biz_contacts 
									 WHERE type = 3
										AND cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
										AND paytype <> 'free'
								

									SELECT listingnumber
										FROM biz_contacts 
									 WHERE type = 3
										AND cityid IN (181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181)
										AND paytype = 'free'
								

									SELECT listingnumber
										FROM biz_contacts 
									 WHERE type = 35
										AND cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
										AND paytype <> 'free'
								

									SELECT listingnumber
										FROM biz_contacts 
									 WHERE type = 35
										AND cityid IN (181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181)
										AND paytype = 'free'
								

									SELECT listingnumber
										FROM biz_contacts 
									 WHERE type = 5
										AND cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
										AND paytype <> 'free'
								

									SELECT listingnumber
										FROM biz_contacts 
									 WHERE type = 5
										AND cityid IN (181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181)
										AND paytype = 'free'
								

									SELECT listingnumber
										FROM biz_contacts 
									 WHERE type = 4
										AND cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
										AND paytype <> 'free'
								

									SELECT listingnumber
										FROM biz_contacts 
									 WHERE type = 4
										AND cityid IN (181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181)
										AND paytype = 'free'
								

									SELECT listingnumber
										FROM biz_contacts 
									 WHERE type = 34
										AND cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
										AND paytype <> 'free'
								

									SELECT listingnumber
										FROM biz_contacts 
									 WHERE type = 34
										AND cityid IN (181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181)
										AND paytype = 'free'
								

									SELECT listingnumber
										FROM biz_contacts 
									 WHERE type = 2
										AND cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
										AND paytype <> 'free'
								

									SELECT listingnumber
										FROM biz_contacts 
									 WHERE type = 2
										AND cityid IN (181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181)
										AND paytype = 'free'
								

									SELECT listingnumber
										FROM biz_contacts 
									 WHERE type = 33
										AND cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
										AND paytype <> 'free'
								

									SELECT listingnumber
										FROM biz_contacts 
									 WHERE type = 33
										AND cityid IN (181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181,181)
										AND paytype = 'free'
								

							SELECT DISTINCT bc.listingnumber, type, bt.*
							FROM (biz_contacts bc INNER 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.type = 3
								AND bc.cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
								AND bc.active = 1
								AND bp.mainphoto <> 'spacer.gif'
							

							SELECT DISTINCT bc.listingnumber, type, bt.*
							FROM (biz_contacts bc INNER 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.type = 35
								AND bc.cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
								AND bc.active = 1
								AND bp.mainphoto <> 'spacer.gif'
							

							SELECT DISTINCT bc.listingnumber, type, bt.*
							FROM (biz_contacts bc INNER 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.type = 5
								AND bc.cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
								AND bc.active = 1
								AND bp.mainphoto <> 'spacer.gif'
							

							SELECT DISTINCT bc.listingnumber, type, bt.*
							FROM (biz_contacts bc INNER 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.type = 4
								AND bc.cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
								AND bc.active = 1
								AND bp.mainphoto <> 'spacer.gif'
							

							SELECT DISTINCT bc.listingnumber, type, bt.*
							FROM (biz_contacts bc INNER 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.type = 34
								AND bc.cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
								AND bc.active = 1
								AND bp.mainphoto <> 'spacer.gif'
							

							SELECT DISTINCT bc.listingnumber, type, bt.*
							FROM (biz_contacts bc INNER 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.type = 2
								AND bc.cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
								AND bc.active = 1
								AND bp.mainphoto <> 'spacer.gif'
							

									SELECT bc.*, bp.*, s.name, bt.*
										FROM ((biz_contacts bc INNER JOIN biz_photos bp ON bp.listingnumber=bc.listingnumber) INNER JOIN states s ON bc.state = s.abv) INNER JOIN biz_types bt ON bc.type = bt.biztype_id
									 WHERE bc.listingnumber=24485 

							SELECT DISTINCT bc.listingnumber, type, bt.*
							FROM (biz_contacts bc INNER 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.type = 33
								AND bc.cityid IN (4130,4128,4140,4110,4685,4129,4119,4153,181,4141,4559,4108)
								AND bc.active = 1
								AND bp.mainphoto <> 'spacer.gif'
							

			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/destinations/desttown.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=