SELECT * FROM webpg_event WHERE pageid = 1
			

	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 
			(
				City LIKE ? OR 
				City LIKE ? OR
				City LIKE ? OR 
				City LIKE ?
			) AND star=1 AND p5=1
			ORDER BY orderstar
		

			SELECT Code, Category, directoryurl, picture2, IntroMiddle, whereto, star, shortenedurl 
			FROM privy5codes 
			WHERE 
			(
				City LIKE ? OR 
				City LIKE ? OR
				City LIKE ? OR 
				City LIKE ?
			) AND byprivymember=1 AND p5=1
			ORDER BY Category
		

			SELECT Code, Category, directoryurl, picture3, IntroMiddle, whereto 
			FROM privy5codes 
			WHERE 
			(
				City LIKE ? OR 
				City LIKE ? OR
				City LIKE ? OR 
				City LIKE ?
			) 
			AND byprivymember IS NULL 
			AND p5=1 
			ORDER BY Category
		

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '179' OR
										privy5codes LIKE '179,%' OR
										privy5codes LIKE '%,179' OR 
										privy5codes LIKE '%,179,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '174' OR
										privy5codes LIKE '174,%' OR
										privy5codes LIKE '%,174' OR 
										privy5codes LIKE '%,174,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '148' OR
										privy5codes LIKE '148,%' OR
										privy5codes LIKE '%,148' OR 
										privy5codes LIKE '%,148,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '205' OR
										privy5codes LIKE '205,%' OR
										privy5codes LIKE '%,205' OR 
										privy5codes LIKE '%,205,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '185' OR
										privy5codes LIKE '185,%' OR
										privy5codes LIKE '%,185' OR 
										privy5codes LIKE '%,185,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '188' OR
										privy5codes LIKE '188,%' OR
										privy5codes LIKE '%,188' OR 
										privy5codes LIKE '%,188,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '183' OR
										privy5codes LIKE '183,%' OR
										privy5codes LIKE '%,183' OR 
										privy5codes LIKE '%,183,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '155' OR
										privy5codes LIKE '155,%' OR
										privy5codes LIKE '%,155' OR 
										privy5codes LIKE '%,155,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									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) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '162' OR
										privy5codes LIKE '162,%' OR
										privy5codes LIKE '%,162' OR 
										privy5codes LIKE '%,162,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '160' OR
										privy5codes LIKE '160,%' OR
										privy5codes LIKE '%,160' OR 
										privy5codes LIKE '%,160,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '176' OR
										privy5codes LIKE '176,%' OR
										privy5codes LIKE '%,176' OR 
										privy5codes LIKE '%,176,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '180' OR
										privy5codes LIKE '180,%' OR
										privy5codes LIKE '%,180' OR 
										privy5codes LIKE '%,180,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									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) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '195' OR
										privy5codes LIKE '195,%' OR
										privy5codes LIKE '%,195' OR 
										privy5codes LIKE '%,195,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '151' OR
										privy5codes LIKE '151,%' OR
										privy5codes LIKE '%,151' OR 
										privy5codes LIKE '%,151,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '169' OR
										privy5codes LIKE '169,%' OR
										privy5codes LIKE '%,169' OR 
										privy5codes LIKE '%,169,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '182' OR
										privy5codes LIKE '182,%' OR
										privy5codes LIKE '%,182' OR 
										privy5codes LIKE '%,182,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '181' OR
										privy5codes LIKE '181,%' OR
										privy5codes LIKE '%,181' OR 
										privy5codes LIKE '%,181,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '186' OR
										privy5codes LIKE '186,%' OR
										privy5codes LIKE '%,186' OR 
										privy5codes LIKE '%,186,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '158' OR
										privy5codes LIKE '158,%' OR
										privy5codes LIKE '%,158' OR 
										privy5codes LIKE '%,158,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '184' OR
										privy5codes LIKE '184,%' OR
										privy5codes LIKE '%,184' OR 
										privy5codes LIKE '%,184,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '140' OR
										privy5codes LIKE '140,%' OR
										privy5codes LIKE '%,140' OR 
										privy5codes LIKE '%,140,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									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) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '165' OR
										privy5codes LIKE '165,%' OR
										privy5codes LIKE '%,165' OR 
										privy5codes LIKE '%,165,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									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) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									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) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '156' OR
										privy5codes LIKE '156,%' OR
										privy5codes LIKE '%,156' OR 
										privy5codes LIKE '%,156,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '175' OR
										privy5codes LIKE '175,%' OR
										privy5codes LIKE '%,175' OR 
										privy5codes LIKE '%,175,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '192' OR
										privy5codes LIKE '192,%' OR
										privy5codes LIKE '%,192' OR 
										privy5codes LIKE '%,192,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '190' OR
										privy5codes LIKE '190,%' OR
										privy5codes LIKE '%,190' OR 
										privy5codes LIKE '%,190,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '153' OR
										privy5codes LIKE '153,%' OR
										privy5codes LIKE '%,153' OR 
										privy5codes LIKE '%,153,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '143' OR
										privy5codes LIKE '143,%' OR
										privy5codes LIKE '%,143' OR 
										privy5codes LIKE '%,143,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '178' OR
										privy5codes LIKE '178,%' OR
										privy5codes LIKE '%,178' OR 
										privy5codes LIKE '%,178,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '177' OR
										privy5codes LIKE '177,%' OR
										privy5codes LIKE '%,177' OR 
										privy5codes LIKE '%,177,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '154' OR
										privy5codes LIKE '154,%' OR
										privy5codes LIKE '%,154' OR 
										privy5codes LIKE '%,154,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '243' OR
										privy5codes LIKE '243,%' OR
										privy5codes LIKE '%,243' OR 
										privy5codes LIKE '%,243,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '173' OR
										privy5codes LIKE '173,%' OR
										privy5codes LIKE '%,173' OR 
										privy5codes LIKE '%,173,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '246' OR
										privy5codes LIKE '246,%' OR
										privy5codes LIKE '%,246' OR 
										privy5codes LIKE '%,246,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '166' OR
										privy5codes LIKE '166,%' OR
										privy5codes LIKE '%,166' OR 
										privy5codes LIKE '%,166,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

									SELECT TOP 5 location.directoryurl, location.name 
									FROM location 
									WHERE 
									(
										privy5codes LIKE '132' OR
										privy5codes LIKE '132,%' OR
										privy5codes LIKE '%,132' OR 
										privy5codes LIKE '%,132,%'
									) AND 
									(Location.ClosestPrivyCity=?) AND 
									(Location.P5=1) 
								

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '125' OR
									privy5codes LIKE '125,%' OR
									privy5codes LIKE '%,125' OR 
									privy5codes LIKE '%,125,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '4' OR
									privy5codes LIKE '4,%' OR
									privy5codes LIKE '%,4' OR 
									privy5codes LIKE '%,4,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '6' OR
									privy5codes LIKE '6,%' OR
									privy5codes LIKE '%,6' OR 
									privy5codes LIKE '%,6,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '12' OR
									privy5codes LIKE '12,%' OR
									privy5codes LIKE '%,12' OR 
									privy5codes LIKE '%,12,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '15' OR
									privy5codes LIKE '15,%' OR
									privy5codes LIKE '%,15' OR 
									privy5codes LIKE '%,15,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '17' OR
									privy5codes LIKE '17,%' OR
									privy5codes LIKE '%,17' OR 
									privy5codes LIKE '%,17,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '21' OR
									privy5codes LIKE '21,%' OR
									privy5codes LIKE '%,21' OR 
									privy5codes LIKE '%,21,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '50' OR
									privy5codes LIKE '50,%' OR
									privy5codes LIKE '%,50' OR 
									privy5codes LIKE '%,50,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '38' OR
									privy5codes LIKE '38,%' OR
									privy5codes LIKE '%,38' OR 
									privy5codes LIKE '%,38,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '43' OR
									privy5codes LIKE '43,%' OR
									privy5codes LIKE '%,43' OR 
									privy5codes LIKE '%,43,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								FROM location 
								WHERE 
								(
									privy5codes LIKE '54' OR
									privy5codes LIKE '54,%' OR
									privy5codes LIKE '%,54' OR 
									privy5codes LIKE '%,54,%'
								) AND 
								(Location.ClosestPrivyCity=?) AND 
								(Location.P5=1)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

								SELECT TOP 5 location.directoryurl, location.name, location.thumbnail 
								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)  
							

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

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

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

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

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

					SELECT * 
					FROM privy5codes 
					WHERE 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 4
		magazine_id,
		COUNT(magazine_id) AS hits,
		(
			SELECT directoryurl
	        FROM magazine
	        WHERE magazine.id = magazine_views.magazine_id
		) AS directoryurl
	FROM MAGAZINE_VIEWS
	WHERE
		created>=CONVERT(datetime,'2019-12-22 00:00:00') AND
		created<=CONVERT(datetime,'2019-12-28 23:59:59') AND
		magazine_id!=17
	GROUP BY magazine_id
	ORDER BY COUNT(magazine_id) DESC

		SELECT TOP 4 directoryurl FROM magazine ORDER BY initpopular DESC
	

						SELECT *
						FROM magazine
						WHERE directoryurl=? 

						SELECT *
						FROM magazine
						WHERE directoryurl=? 

						SELECT *
						FROM magazine
						WHERE directoryurl=? 

						SELECT *
						FROM magazine
						WHERE directoryurl=? 

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

	SELECT
		LOCATION.Name,
		LOCATION.LocationId,
		LOCATION.Privy5Codes,
		LOCATION.Privy5Text,
		LOCATION.Thumbnail,
		LOCATION.directoryurl,
		(
			SELECT privy5codes.whereto
			FROM privy5codes
			WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',') AND
			(
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ?
			)
		) AS categorywhereto2,
		(
			SELECT privy5codes.category
			FROM privy5codes
			WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',') AND
			(
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ?
			)
		) AS categorytext,
		(
			SELECT privy5codes.directoryurl
			FROM privy5codes
			WHERE privy5codes.code = dbo.firstlist(location.privy5codes,',') AND
			(
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ? OR
				City LIKE ?
			)
		) AS categoryurl
	FROM PRIVY5TOPPLACES INNER JOIN LOCATION ON PRIVY5TOPPLACES.LocationId = LOCATION.LocationId
	WHERE (PRIVY5TOPPLACES.City = ?)

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

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)
[email protected]
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\sanfrancisco\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=Hong%20Kong%2CShanghai%2CLondon%2CLos%20Angeles%2CNew%20York%2CMacau; $Path=/
HTTP_HOST=www.privy.net
HTTP_REFERER=http://www.privy.net/sanfrancisco
HTTP_URL=/sanfrancisco/index.cfm/
HTTP_USER_AGENT=Mozilla/4.5 (compatible; HTTrack 3.0x; Windows 98)
LOCAL_ADDR=172.30.1.133
PATH_INFO=/
PATH_TRANSLATED=d:\www\privy\sanfrancisco\index.cfm
QUERY_STRING=
REMOTE_ADDR=172.6.167.56
REMOTE_HOST=172.6.167.56
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/sanfrancisco/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=Hong Kong,Shanghai,London,Los Angeles,New York,Macau

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