SELECT directoryurl,whereto 
		FROM privy5codes 
		WHERE (shortenedurl=?) AND 
			(
				City LIKE ? OR 
				City LIKE ? OR
				City LIKE ? OR 
				City LIKE ?
			)
	

				SELECT * FROM webpg_event WHERE name = ? 

	SELECT memberguests_login.sessionid 
	FROM memberguests_login 
	WHERE sessionid = ? 

	SELECT 
		memberguests_login.memberid,
	 	memberguests_login.logindatetime,
	 	memberguests_login.loginvia,
	 	memberguests_login.logoutdatetime,
	 	memberguests_login.sessionid,
	 	memberguests_login.fbuid,
	 	memberguests_login.fbaccesstoken,
	 	memberguests_login.fbsignedrequest,
	 	memberguests_login.fbexpiresin,
	 	memberguests_login.fbpicture,
	 	memberguests_login.logininviteonly 
	FROM memberguests_login 
	WHERE sessionid = ? 

						SELECT *
						FROM US_IP
						WHERE 
							(ip_start_decimal <= ?) AND 
							(? <= ip_end_decimal)
					

					SELECT * 
					FROM privy5codes 
					WHERE privy5codes.WhereTo = ? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND byprivymember IS NULL AND P5=1
					ORDER BY Category	
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '1' OR
						privy5codes LIKE '1,%' OR
						privy5codes LIKE '%,1' OR 
						privy5codes LIKE '%,1,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '74' OR
						privy5codes LIKE '74,%' OR
						privy5codes LIKE '%,74' OR 
						privy5codes LIKE '%,74,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '3' OR
						privy5codes LIKE '3,%' OR
						privy5codes LIKE '%,3' OR 
						privy5codes LIKE '%,3,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '72' OR
						privy5codes LIKE '72,%' OR
						privy5codes LIKE '%,72' OR 
						privy5codes LIKE '%,72,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '7' OR
						privy5codes LIKE '7,%' OR
						privy5codes LIKE '%,7' OR 
						privy5codes LIKE '%,7,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '8' OR
						privy5codes LIKE '8,%' OR
						privy5codes LIKE '%,8' OR 
						privy5codes LIKE '%,8,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '9' OR
						privy5codes LIKE '9,%' OR
						privy5codes LIKE '%,9' OR 
						privy5codes LIKE '%,9,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '73' OR
						privy5codes LIKE '73,%' OR
						privy5codes LIKE '%,73' OR 
						privy5codes LIKE '%,73,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '10' OR
						privy5codes LIKE '10,%' OR
						privy5codes LIKE '%,10' OR 
						privy5codes LIKE '%,10,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '11' OR
						privy5codes LIKE '11,%' OR
						privy5codes LIKE '%,11' OR 
						privy5codes LIKE '%,11,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '13' OR
						privy5codes LIKE '13,%' OR
						privy5codes LIKE '%,13' OR 
						privy5codes LIKE '%,13,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '14' OR
						privy5codes LIKE '14,%' OR
						privy5codes LIKE '%,14' OR 
						privy5codes LIKE '%,14,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '16' OR
						privy5codes LIKE '16,%' OR
						privy5codes LIKE '%,16' OR 
						privy5codes LIKE '%,16,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '18' OR
						privy5codes LIKE '18,%' OR
						privy5codes LIKE '%,18' OR 
						privy5codes LIKE '%,18,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '19' OR
						privy5codes LIKE '19,%' OR
						privy5codes LIKE '%,19' OR 
						privy5codes LIKE '%,19,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '61' OR
						privy5codes LIKE '61,%' OR
						privy5codes LIKE '%,61' OR 
						privy5codes LIKE '%,61,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '62' OR
						privy5codes LIKE '62,%' OR
						privy5codes LIKE '%,62' OR 
						privy5codes LIKE '%,62,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '22' OR
						privy5codes LIKE '22,%' OR
						privy5codes LIKE '%,22' OR 
						privy5codes LIKE '%,22,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '63' OR
						privy5codes LIKE '63,%' OR
						privy5codes LIKE '%,63' OR 
						privy5codes LIKE '%,63,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '23' OR
						privy5codes LIKE '23,%' OR
						privy5codes LIKE '%,23' OR 
						privy5codes LIKE '%,23,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '76' OR
						privy5codes LIKE '76,%' OR
						privy5codes LIKE '%,76' OR 
						privy5codes LIKE '%,76,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '27' OR
						privy5codes LIKE '27,%' OR
						privy5codes LIKE '%,27' OR 
						privy5codes LIKE '%,27,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '28' OR
						privy5codes LIKE '28,%' OR
						privy5codes LIKE '%,28' OR 
						privy5codes LIKE '%,28,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '29' OR
						privy5codes LIKE '29,%' OR
						privy5codes LIKE '%,29' OR 
						privy5codes LIKE '%,29,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '30' OR
						privy5codes LIKE '30,%' OR
						privy5codes LIKE '%,30' OR 
						privy5codes LIKE '%,30,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '31' OR
						privy5codes LIKE '31,%' OR
						privy5codes LIKE '%,31' OR 
						privy5codes LIKE '%,31,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '33' OR
						privy5codes LIKE '33,%' OR
						privy5codes LIKE '%,33' OR 
						privy5codes LIKE '%,33,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '35' OR
						privy5codes LIKE '35,%' OR
						privy5codes LIKE '%,35' OR 
						privy5codes LIKE '%,35,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '36' OR
						privy5codes LIKE '36,%' OR
						privy5codes LIKE '%,36' OR 
						privy5codes LIKE '%,36,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '39' OR
						privy5codes LIKE '39,%' OR
						privy5codes LIKE '%,39' OR 
						privy5codes LIKE '%,39,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '40' OR
						privy5codes LIKE '40,%' OR
						privy5codes LIKE '%,40' OR 
						privy5codes LIKE '%,40,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '42' OR
						privy5codes LIKE '42,%' OR
						privy5codes LIKE '%,42' OR 
						privy5codes LIKE '%,42,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '2' OR
						privy5codes LIKE '2,%' OR
						privy5codes LIKE '%,2' OR 
						privy5codes LIKE '%,2,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '44' OR
						privy5codes LIKE '44,%' OR
						privy5codes LIKE '%,44' OR 
						privy5codes LIKE '%,44,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '45' OR
						privy5codes LIKE '45,%' OR
						privy5codes LIKE '%,45' OR 
						privy5codes LIKE '%,45,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '51' OR
						privy5codes LIKE '51,%' OR
						privy5codes LIKE '%,51' OR 
						privy5codes LIKE '%,51,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '52' OR
						privy5codes LIKE '52,%' OR
						privy5codes LIKE '%,52' OR 
						privy5codes LIKE '%,52,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '53' OR
						privy5codes LIKE '53,%' OR
						privy5codes LIKE '%,53' OR 
						privy5codes LIKE '%,53,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '60' OR
						privy5codes LIKE '60,%' OR
						privy5codes LIKE '%,60' OR 
						privy5codes LIKE '%,60,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '56' OR
						privy5codes LIKE '56,%' OR
						privy5codes LIKE '%,56' OR 
						privy5codes LIKE '%,56,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '55' OR
						privy5codes LIKE '55,%' OR
						privy5codes LIKE '%,55' OR 
						privy5codes LIKE '%,55,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT * 
					FROM privy5codes 
					WHERE privy5codes.WhereTo = ? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND byprivymember IS NULL AND P5=1
					ORDER BY Category	
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '5' OR
						privy5codes LIKE '5,%' OR
						privy5codes LIKE '%,5' OR 
						privy5codes LIKE '%,5,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '20' OR
						privy5codes LIKE '20,%' OR
						privy5codes LIKE '%,20' OR 
						privy5codes LIKE '%,20,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '26' OR
						privy5codes LIKE '26,%' OR
						privy5codes LIKE '%,26' OR 
						privy5codes LIKE '%,26,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '77' OR
						privy5codes LIKE '77,%' OR
						privy5codes LIKE '%,77' OR 
						privy5codes LIKE '%,77,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '57' OR
						privy5codes LIKE '57,%' OR
						privy5codes LIKE '%,57' OR 
						privy5codes LIKE '%,57,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '58' OR
						privy5codes LIKE '58,%' OR
						privy5codes LIKE '%,58' OR 
						privy5codes LIKE '%,58,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT * 
					FROM privy5codes 
					WHERE privy5codes.WhereTo = ? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND byprivymember IS NULL AND P5=1
					ORDER BY Category	
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '25' OR
						privy5codes LIKE '25,%' OR
						privy5codes LIKE '%,25' OR 
						privy5codes LIKE '%,25,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '24' OR
						privy5codes LIKE '24,%' OR
						privy5codes LIKE '%,24' OR 
						privy5codes LIKE '%,24,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT * 
					FROM privy5codes 
					WHERE privy5codes.WhereTo = ? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND byprivymember IS NULL AND P5=1
					ORDER BY Category	
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '37' OR
						privy5codes LIKE '37,%' OR
						privy5codes LIKE '%,37' OR 
						privy5codes LIKE '%,37,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT * 
					FROM privy5codes 
					WHERE privy5codes.WhereTo = ? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND byprivymember IS NULL AND P5=1
					ORDER BY Category	
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '46' OR
						privy5codes LIKE '46,%' OR
						privy5codes LIKE '%,46' OR 
						privy5codes LIKE '%,46,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT * 
					FROM privy5codes 
					WHERE privy5codes.WhereTo = ? AND 
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND byprivymember IS NULL AND P5=1
					ORDER BY Category	
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '47' OR
						privy5codes LIKE '47,%' OR
						privy5codes LIKE '%,47' OR 
						privy5codes LIKE '%,47,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT * 
					FROM privy5codes 
					WHERE  
					(
						City LIKE ? OR 
						City LIKE ? OR
						City LIKE ? OR 
						City LIKE ?
					) AND byprivymember=1 AND P5=1
					ORDER BY Category	
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '107' OR
						privy5codes LIKE '107,%' OR
						privy5codes LIKE '%,107' OR 
						privy5codes LIKE '%,107,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '113' OR
						privy5codes LIKE '113,%' OR
						privy5codes LIKE '%,113' OR 
						privy5codes LIKE '%,113,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '121' OR
						privy5codes LIKE '121,%' OR
						privy5codes LIKE '%,121' OR 
						privy5codes LIKE '%,121,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '92' OR
						privy5codes LIKE '92,%' OR
						privy5codes LIKE '%,92' OR 
						privy5codes LIKE '%,92,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '106' OR
						privy5codes LIKE '106,%' OR
						privy5codes LIKE '%,106' OR 
						privy5codes LIKE '%,106,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '118' OR
						privy5codes LIKE '118,%' OR
						privy5codes LIKE '%,118' OR 
						privy5codes LIKE '%,118,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '120' OR
						privy5codes LIKE '120,%' OR
						privy5codes LIKE '%,120' OR 
						privy5codes LIKE '%,120,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '97' OR
						privy5codes LIKE '97,%' OR
						privy5codes LIKE '%,97' OR 
						privy5codes LIKE '%,97,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '130' OR
						privy5codes LIKE '130,%' OR
						privy5codes LIKE '%,130' OR 
						privy5codes LIKE '%,130,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '82' OR
						privy5codes LIKE '82,%' OR
						privy5codes LIKE '%,82' OR 
						privy5codes LIKE '%,82,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '99' OR
						privy5codes LIKE '99,%' OR
						privy5codes LIKE '%,99' OR 
						privy5codes LIKE '%,99,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '236' OR
						privy5codes LIKE '236,%' OR
						privy5codes LIKE '%,236' OR 
						privy5codes LIKE '%,236,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '128' OR
						privy5codes LIKE '128,%' OR
						privy5codes LIKE '%,128' OR 
						privy5codes LIKE '%,128,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '189' OR
						privy5codes LIKE '189,%' OR
						privy5codes LIKE '%,189' OR 
						privy5codes LIKE '%,189,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '233' OR
						privy5codes LIKE '233,%' OR
						privy5codes LIKE '%,233' OR 
						privy5codes LIKE '%,233,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '96' OR
						privy5codes LIKE '96,%' OR
						privy5codes LIKE '%,96' OR 
						privy5codes LIKE '%,96,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '103' OR
						privy5codes LIKE '103,%' OR
						privy5codes LIKE '%,103' OR 
						privy5codes LIKE '%,103,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '111' OR
						privy5codes LIKE '111,%' OR
						privy5codes LIKE '%,111' OR 
						privy5codes LIKE '%,111,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '117' OR
						privy5codes LIKE '117,%' OR
						privy5codes LIKE '%,117' OR 
						privy5codes LIKE '%,117,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '85' OR
						privy5codes LIKE '85,%' OR
						privy5codes LIKE '%,85' OR 
						privy5codes LIKE '%,85,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '108' OR
						privy5codes LIKE '108,%' OR
						privy5codes LIKE '%,108' OR 
						privy5codes LIKE '%,108,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '87' OR
						privy5codes LIKE '87,%' OR
						privy5codes LIKE '%,87' OR 
						privy5codes LIKE '%,87,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '232' OR
						privy5codes LIKE '232,%' OR
						privy5codes LIKE '%,232' OR 
						privy5codes LIKE '%,232,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '100' OR
						privy5codes LIKE '100,%' OR
						privy5codes LIKE '%,100' OR 
						privy5codes LIKE '%,100,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '194' OR
						privy5codes LIKE '194,%' OR
						privy5codes LIKE '%,194' OR 
						privy5codes LIKE '%,194,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '101' OR
						privy5codes LIKE '101,%' OR
						privy5codes LIKE '%,101' OR 
						privy5codes LIKE '%,101,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '131' OR
						privy5codes LIKE '131,%' OR
						privy5codes LIKE '%,131' OR 
						privy5codes LIKE '%,131,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '123' OR
						privy5codes LIKE '123,%' OR
						privy5codes LIKE '%,123' OR 
						privy5codes LIKE '%,123,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '81' OR
						privy5codes LIKE '81,%' OR
						privy5codes LIKE '%,81' OR 
						privy5codes LIKE '%,81,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '119' OR
						privy5codes LIKE '119,%' OR
						privy5codes LIKE '%,119' OR 
						privy5codes LIKE '%,119,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '104' OR
						privy5codes LIKE '104,%' OR
						privy5codes LIKE '%,104' OR 
						privy5codes LIKE '%,104,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '126' OR
						privy5codes LIKE '126,%' OR
						privy5codes LIKE '%,126' OR 
						privy5codes LIKE '%,126,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '91' OR
						privy5codes LIKE '91,%' OR
						privy5codes LIKE '%,91' OR 
						privy5codes LIKE '%,91,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '83' OR
						privy5codes LIKE '83,%' OR
						privy5codes LIKE '%,83' OR 
						privy5codes LIKE '%,83,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '215' OR
						privy5codes LIKE '215,%' OR
						privy5codes LIKE '%,215' OR 
						privy5codes LIKE '%,215,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '115' OR
						privy5codes LIKE '115,%' OR
						privy5codes LIKE '%,115' OR 
						privy5codes LIKE '%,115,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '80' OR
						privy5codes LIKE '80,%' OR
						privy5codes LIKE '%,80' OR 
						privy5codes LIKE '%,80,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '114' OR
						privy5codes LIKE '114,%' OR
						privy5codes LIKE '%,114' OR 
						privy5codes LIKE '%,114,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '89' OR
						privy5codes LIKE '89,%' OR
						privy5codes LIKE '%,89' OR 
						privy5codes LIKE '%,89,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '116' OR
						privy5codes LIKE '116,%' OR
						privy5codes LIKE '%,116' OR 
						privy5codes LIKE '%,116,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '112' OR
						privy5codes LIKE '112,%' OR
						privy5codes LIKE '%,112' OR 
						privy5codes LIKE '%,112,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '122' OR
						privy5codes LIKE '122,%' OR
						privy5codes LIKE '%,122' OR 
						privy5codes LIKE '%,122,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '193' OR
						privy5codes LIKE '193,%' OR
						privy5codes LIKE '%,193' OR 
						privy5codes LIKE '%,193,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '244' OR
						privy5codes LIKE '244,%' OR
						privy5codes LIKE '%,244' OR 
						privy5codes LIKE '%,244,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '102' OR
						privy5codes LIKE '102,%' OR
						privy5codes LIKE '%,102' OR 
						privy5codes LIKE '%,102,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '110' OR
						privy5codes LIKE '110,%' OR
						privy5codes LIKE '%,110' OR 
						privy5codes LIKE '%,110,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '209' OR
						privy5codes LIKE '209,%' OR
						privy5codes LIKE '%,209' OR 
						privy5codes LIKE '%,209,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '90' OR
						privy5codes LIKE '90,%' OR
						privy5codes LIKE '%,90' OR 
						privy5codes LIKE '%,90,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '137' OR
						privy5codes LIKE '137,%' OR
						privy5codes LIKE '%,137' OR 
						privy5codes LIKE '%,137,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '88' OR
						privy5codes LIKE '88,%' OR
						privy5codes LIKE '%,88' OR 
						privy5codes LIKE '%,88,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '84' OR
						privy5codes LIKE '84,%' OR
						privy5codes LIKE '%,84' OR 
						privy5codes LIKE '%,84,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '105' OR
						privy5codes LIKE '105,%' OR
						privy5codes LIKE '%,105' OR 
						privy5codes LIKE '%,105,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '86' OR
						privy5codes LIKE '86,%' OR
						privy5codes LIKE '%,86' OR 
						privy5codes LIKE '%,86,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '98' OR
						privy5codes LIKE '98,%' OR
						privy5codes LIKE '%,98' OR 
						privy5codes LIKE '%,98,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

					SELECT TOP 5 *, 
					(
						SELECT AVG(MyReviews.Star) AS avgstar
            			FROM myreviews, MEMBER  
            			WHERE 
							MYREVIEWS.MemberId = member.MemberID AND 
							MyReviews.LocationId= location.locationid AND
							member.can_login=1
					) AS averagestar 
					FROM location 
					WHERE
					(
						privy5codes LIKE '247' OR
						privy5codes LIKE '247,%' OR
						privy5codes LIKE '%,247' OR 
						privy5codes LIKE '%,247,%' 
					) 
					AND (Location.closestprivycity=?) 
					AND (Location.P5=1) 
					ORDER BY Location.Privy5Order DESC
				

Application Variables:
applicationname=16674C21BBD774F3F0CD46198107AC84
devmode=false
dsn_name=entre360ds
dsn_name10=entre360_2011ds
event=Struct (26)
ipallow=24.199.44.252
magazine_imageupload=/upload/net/privy/www/p5photos/
org.corfield.framework=Struct (3)
paypal_biz=paypal@privy.net
paypal_url=https://www.paypal.com/cgi-bin/webscr
recaptcha_private=6LfrQtQSAAAAAGuECx5CZ5jRb4TPBzgrBVTK_IPH
recaptcha_public=6LfrQtQSAAAAALsfdvrJmY-JULezQbwYw4ea1nE2
site_addr=www.privy.net
upload=/upload/net/privy/www/
upload_magazine=/upload/net/privy/www/p5photos/
upload_root=/upload/net/privy/

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:\www\privy\losangeles\index.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,image/png,image/jpeg,image/pjpeg,image/x-xbitmap,image/svg+xml,image/gif;q=0.9,*/*;q=0.1
HTTP_ACCEPT_ENCODING=gzip, identity;q=0.9
HTTP_ACCEPT_LANGUAGE=en, *
HTTP_CONNECTION=keep-alive
HTTP_COOKIE=$Version=1; CFID=5955090; $Path=/; CFTOKEN=5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB; $Path=/; DESTINATION=Los%20Angeles; $Path=/; RECENTCITIES=Los%20Angeles%2CHong%20Kong%2CShanghai%2CLondon%2CNew%20York; $Path=/
HTTP_HOST=www.privy.net
HTTP_REFERER=http://www.privy.net/losangeles/go/listing
HTTP_URL=/losangeles/index.cfm/go/listing?rss=1?rss=1
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=172.30.1.133
PATH_INFO=/go/listing
PATH_TRANSLATED=d:\www\privy\losangeles\index.cfm
QUERY_STRING=rss=1
REMOTE_ADDR=172.6.167.56
REMOTE_HOST=172.6.167.56
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/losangeles/index.cfm
SERVER_NAME=www.privy.net
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
CFID=5955090
CFTOKEN=5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB
DESTINATION=Los Angeles
RECENTCITIES=Los Angeles,Hong Kong,Shanghai,London,New York

Session Variables:
cfid=5955090
cftoken=5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB
sessionid=16674C21BBD774F3F0CD46198107AC84_5955090_5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB
urltoken=CFID=5955090&CFTOKEN=5e6cb3d73e34ca8c-04E6476F-DF78-51E9-E8E1817815F6EDAB

URL Parameters:
rss=1