Idaho Bed & Breakfasts

 
	SELECT *
		FROM biz_types 
	 WHERE biztype_id = 3 

 
	SELECT biz_contacts.state, states.*, biz_contacts.city
	  FROM biz_contacts INNER JOIN states ON biz_contacts.state = states.abv
	 WHERE biz_contacts.state='ID' AND type = 3 

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

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

   SELECT DISTINCT bc.cityid
	 FROM biz_contacts bc 
	WHERE bc.state = 'ID'
		AND bc.type = 3
	  AND bc.active = 1
	ORDER BY bc.city

   SELECT DISTINCT bc.listingnumber, bc.active, bc.paytype, bc.type, bc.bizamens, bc.bizname, bc.city, bc.state, bc.description, bc.website, bc.pets, bp.listingnumber, bp.mainphoto
	 FROM biz_contacts bc LEFT OUTER JOIN biz_photos bp ON bc.listingnumber = bp.listingnumber
	WHERE bc.state = 'ID'
	  AND bc.paytype <> 'free'
	  AND bc.active = 1
		AND bc.type = 3 

		 SELECT DISTINCT bc.listingnumber, bc.active, bc.paytype, bc.shortdescription, bc.bizname, bc.address1, bc.address2, bc.city, bc.state, bc.zip, bc.biz_phone1
		 FROM biz_contacts bc LEFT OUTER JOIN outfitter_trips ot ON bc.listingnumber = ot.listingnumber
		WHERE bc.state = 'ID'
			AND bc.paytype = 'free'
			AND bc.active = 1
			AND bc.type = 3
	 ORDER BY bc.city, bc.bizname
	

											SELECT city, cityid
												FROM city 
											 WHERE cityid IN (103,4929,4930,106,101,200,246,104,4938,4939,4940,102,108,4942)
											 ORDER BY city
										

			SELECT *
				FROM lodge_amens 
			 WHERE bnb = 1 AND grid = 1
			

				SELECT *
					FROM lodge_amens 
				 WHERE amensid IN (39,46,45,42,44,28) AND grid = 1
				

												SELECT *
												FROM ihs_propid_map
												WHERE llgid = 20635 

				SELECT *
					FROM lodge_amens 
				 WHERE amensid IN (3,4,6,12,20,34,39) AND grid = 1
				

			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/showstate.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: