select ban_ip from ban where ban_ip = '38.107.191.97'

				INSERT INTO 
					online (ipaddress, firstactive, lastactive, useremail, server) 
				VALUES
				('192.168.13.80',NOW(),{ts '2010-03-16 23:29:26'},'none','1')		
				ON DUPLICATE KEY UPDATE
				lastactive 	= NOW(),
				server		= '1'
			

				INSERT INTO 
					ips_to_encode (ip, dateadded, dateupdated) 
				VALUES
				('192.168.13.80',NOW(),{ts '2010-03-16 23:29:26'})		
				ON DUPLICATE KEY UPDATE
					dateupdated 	= NOW()
			

		insert into stats
			(referer,click,user_ip,datetime,object,page)
		values
			('',1,'38.107.191.97',Now(),'0','www.pubcrawler.com/Template/dsp_restaurant_zoom.cfm/flat/ID=315210')
	

			SELECT 
		ID,name,Address,City,State,zipcode,phone,latitude,longitude,URL, restauranttype, yearlisted, neighborhood, 
		county, country, mondayopen, mondayclose, tuesdayopen, tuesdayclose, wednesdayopen,
		wednesdayclose, thursdayopen, thursdayclose, fridayopen, fridayclose, saturdayopen, saturdayclose,
		sundayopen, sundayclose
			from
				allrestaurants
			where
				ID = 315210
		

		select 
			logoid, logoestablishment, logofile, logopublished, logodeleted
		from 
			logosrestaurant
		where 
			logoestablishment = '315210'
			and
			logopublished = 'True'
		order by
			logoid
				DESC
		

			select photoid,photoestablishment,photofile,photopublished from photosrestaurant
			where  photopublished = 'True' and photoestablishment = '315210'
		

	SELECT menu_id, menu_file, menu_extension, menu_description, menu_published_date	from restaurantmenu	where 
	menu_establishment_id = "315210" and
	menu_published = "True" and menu_deleted is NULL
	order by menu_published_date ASC

			SELECT BrewerID,Name,Address1,Address2,City,State,ZipCode,Zipcodefour,PhoneNumber,BrewPub,Brewery,OpenStatus,	Brewery | Brewpub As Type,
ROUND((ACOS((SIN(42.21888000/57.2958) * SIN(abs(latitude)/57.2958)) +(COS(42.21888000/57.2958) * COS(abs(latitude)/57.2958) *COS(longitude/57.2958 - -71.02626000/57.2958))))* 3963, 1) AS distance	FROM Brewers
			WHERE 
				PUBCRAWLER <> 0 and openstatus is null
				and latitude <= 42.291223156 and latitude >= 42.146536844 
				and longitude >= -71.098603156 and longitude <= -70.953916844 
			ORDER BY distance
		

		SELECT 
			ID,Name,Longitude,Latitude, address, city, state, county, zipcode, phone
		from
			allrestaurants
		WHERE 
			latitude <= 42.2478172624 and latitude >= 42.1899427376 
			and longitude >= -71.0551972624 and longitude <= -70.9973227376
		ORDER BY
			name
				ASC
	

		SELECT 
			id, restaurantid, body, updated
		FROM
			restaurants_nearby_bb
		WHERE
			restaurantid = 315210
	

			SELECT 
				id, restaurantid, body, updated
			FROM
				restaurants_nearby_hotels
			WHERE
				restaurantid = 315210
		

			SELECT 
				id, restaurantid, body, updated
			FROM
				restaurants_nearby_landmarks
			WHERE
				restaurantid = 315210
		

			select 
				id, type, establishmentid, shortcode, customcode, offer 
			from
				smsoffers 
			where
				type = 'r'
				and
				establishmentid = '315210'
		

			SELECT * 
			FROM restaurantreviews
			WHERE restaurantid = '315210'
			and ValidReview = 1
			and (profanity = 0 or profanity is null)
			ORDER BY ReviewDate DESC
		

			SELECT 	foodselection, foodquality, atmosphere, service, restrooms, price, overall
			FROM restaurantreviews
			WHERE restaurantid = 315210
			and ValidReview = 1
			and (profanity = 0 or profanity is null)
		

insert into 
	logrestaurants
(record,useragent,userip,searchdate,UserEmail,userreferrer)
values
('315210','CCBot/1.0 (+http://www.commoncrawl.org/bot.html)','',
{ts '2010-03-16 23:29:27'},'','')

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=/opt/coldfusion8/wwwroot/Template/dsp_restaurant_zoom.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=Close
HTTP_COOKIE=CFGLOBALS=urltoken%3DCFID%23%3D22148860%26CFTOKEN%23%3D9da685a2c8695e54%2D6A2AB31D%2DC5FB%2DA906%2D46E433631994DBA7%23lastvisit%3D%7Bts%20%272010%2D03%2D16%2023%3A28%3A55%27%7D%23timecreated%3D%7Bts%20%272010%2D03%2D16%2023%3A28%3A55%27%7D%23hitcount%3D2%23cftoken%3D9da685a2c8695e54%2D6A2AB31D%2DC5FB%2DA906%2D46E433631994DBA7%23cfid%3D22148860%23; CFID=22148860; CFTOKEN=9da685a2c8695e54-6A2AB31D-C5FB-A906-46E433631994DBA7
HTTP_HOST=www.pubcrawler.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/flat/ID=315210
PATH_TRANSLATED=/opt/coldfusion8/wwwroot/Template/dsp_restaurant_zoom.cfm
QUERY_STRING=
REMOTE_ADDR=192.168.13.80
REMOTE_HOST=atom3302.local
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/Template/dsp_restaurant_zoom.cfm
SERVER_NAME=www.pubcrawler.com
SERVER_PORT=8500
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=
WEB_SERVER_API=

Client Variables:
cfid=22148860
cftoken=9da685a2c8695e54-6A2AB31D-C5FB-A906-46E433631994DBA7
hitcount=3
lastvisit={ts '2010-03-16 23:29:26'}
timecreated={ts '2010-03-16 23:28:55'}
urltoken=CFID=22148860&CFTOKEN=9da685a2c8695e54-6A2AB31D-C5FB-A906-46E433631994DBA7

Cookie Variables:
CFGLOBALS=urltoken=CFID#=22148860&CFTOKEN#=9da685a2c8695e54-6A2AB31D-C5FB-A906-46E433631994DBA7#lastvisit={ts '2010-03-16 23:29:26'}#timecreated={ts '2010-03-16 23:28:55'}#hitcount=3#cftoken=9da685a2c8695e54-6A2AB31D-C5FB-A906-46E433631994DBA7#cfid=22148860#
CFID=22148860
CFTOKEN=9da685a2c8695e54-6A2AB31D-C5FB-A906-46E433631994DBA7

Session Variables:
cfid=22148860
cftoken=9da685a2c8695e54-6A2AB31D-C5FB-A906-46E433631994DBA7
sessionid=MY_TEST_APP_22148860_9da685a2c8695e54-6A2AB31D-C5FB-A906-46E433631994DBA7
urltoken=CFID=22148860&CFTOKEN=9da685a2c8695e54-6A2AB31D-C5FB-A906-46E433631994DBA7

URL Parameters:
ID=315210