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

		SELECT DISTINCT bc.listingnumber
		FROM biz_contacts bc INNER JOIN biz_photos bp ON bc.listingnumber=bp.listingnumber
		WHERE bc.paytype = 'premium'
				AND bc.active = 1
				AND bc.type >= 2 AND bc.type <= 5
				AND bp.mainphoto <> 'spacer.gif'
		

			SELECT bc.*, bp.*, s.name
				FROM (biz_contacts bc INNER JOIN biz_photos bp ON bp.listingnumber=bc.listingnumber) INNER JOIN states s ON bc.state = s.abv
			 WHERE bc.listingnumber=2267 

				SELECT *
				FROM biz_types
				WHERE biztype_id = "5"	
			

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

					SELECT listingnumber
						FROM biz_contacts bc INNER JOIN biz_types bt ON bc.type = bt.biztype_id
					 WHERE bc.active = 1
						AND bt.lodging = 1
				

					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 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 * 
		FROM zipcodes 
	 WHERE zipcode = 97520 

	SELECT DISTINCT z.cityid
		FROM zipcodes z 
	 WHERE (latitude >= 41.899376563 AND latitude <= 42.4776452266) AND (longitude >= -122.986440893 AND longitude <= -122.39962173) AND z.cityid <> 0  
	 ORDER BY z.city

	SELECT * 
		FROM zipcodes 
	 WHERE zipcode = 81611 

	SELECT DISTINCT z.cityid
		FROM zipcodes z 
	 WHERE (latitude >= 38.9060065068 AND latitude <= 39.4842751704) AND (longitude >= -107.112740363 AND longitude <= -106.534445916) AND z.cityid <> 0  
	 ORDER BY z.city

	SELECT * 
		FROM zipcodes 
	 WHERE zipcode = 12719 

	SELECT DISTINCT z.cityid
		FROM zipcodes z 
	 WHERE (latitude >= 41.2020270146 AND latitude <= 41.7802956782) AND (longitude >= -75.2417171257 AND longitude <= -74.5887577278) AND z.cityid <> 0  
	 ORDER BY z.city

	SELECT * 
		FROM zipcodes 
	 WHERE zipcode = 97701 

	SELECT DISTINCT z.cityid
		FROM zipcodes z 
	 WHERE (latitude >= 43.8036543645 AND latitude <= 44.3819230281) AND (longitude >= -122.154999907 AND longitude <= -120.432265108) AND z.cityid <> 0  
	 ORDER BY z.city

	SELECT * 
		FROM zipcodes 
	 WHERE zipcode = 59716 

	SELECT DISTINCT z.cityid
		FROM zipcodes z 
	 WHERE (latitude >= 44.9955870427 AND latitude <= 45.5738557063) AND (longitude >= -113.19319708 AND longitude <= -109.54180353) AND z.cityid <> 0  
	 ORDER BY z.city

	SELECT * 
		FROM zipcodes 
	 WHERE zipcode = 83701 

	SELECT DISTINCT z.cityid
		FROM zipcodes z 
	 WHERE (latitude >= 43.3263060368 AND latitude <= 43.9045747005) AND (longitude >= -116.505630603 AND longitude <= -115.927215467) AND z.cityid <> 0  
	 ORDER BY z.city

	SELECT * 
		FROM zipcodes 
	 WHERE zipcode = 59715 

	SELECT DISTINCT z.cityid
		FROM zipcodes z 
	 WHERE (latitude >= 45.38013523 AND latitude <= 45.9584038936) AND (longitude >= -111.665038963 AND longitude <= -110.421081643) AND z.cityid <> 0  
	 ORDER BY z.city

	SELECT * 
		FROM zipcodes 
	 WHERE zipcode = 80424 

	SELECT DISTINCT z.cityid
		FROM zipcodes z 
	 WHERE (latitude >= 39.1925322331 AND latitude <= 39.7708008968) AND (longitude >= -106.443036092 AND longitude <= -105.632525431) AND z.cityid <> 0  
	 ORDER BY z.city

	SELECT * 
		FROM zipcodes 
	 WHERE zipcode = 81211 

	SELECT DISTINCT z.cityid
		FROM zipcodes z 
	 WHERE (latitude >= 38.5488669194 AND latitude <= 39.127135583) AND (longitude >= -106.515131759 AND longitude <= -105.77910347) AND z.cityid <> 0  
	 ORDER BY z.city

	SELECT * 
		FROM zipcodes 
	 WHERE zipcode = 80809 

	SELECT DISTINCT z.cityid
		FROM zipcodes z 
	 WHERE (latitude >= 38.6321799077 AND latitude <= 39.2104485713) AND (longitude >= -106.163863528 AND longitude <= -103.823502194) AND z.cityid <> 0  
	 ORDER BY z.city

	SELECT * 
		FROM zipcodes 
	 WHERE zipcode = 01339 

	SELECT DISTINCT z.cityid
		FROM zipcodes z 
	 WHERE (latitude >= 42.3326689519 AND latitude <= 42.9109376155) AND (longitude >= -73.2363208313 AND longitude <= -72.5240093689) AND z.cityid <> 0  
	 ORDER BY z.city

	SELECT * 
		FROM zipcodes 
	 WHERE zipcode = 83227 

	SELECT DISTINCT z.cityid
		FROM zipcodes z 
	 WHERE (lati