SELECT p.sku, p.mfgnum, p.name, p.vendor, p.vendornum, p.desc24mf, p.description, p.image_file, p.image_width, p.image_height, p.keywords, p.short_desc, p.weight, p.mult, p.uofm, p.oversize, p.addl_handling, m.*, pc.*, pp.*, pd.dept_id
	from (((product p INNER JOIN parent_child pc ON p.sku=pc.super_id) INNER JOIN product_price pp ON p.sku=pp.sku) LEFT OUTER JOIN product_meta m ON p.sku=m.sku) LEFT OUTER JOIN product_dept pd ON p.sku = pd.sku
	where p.sku = 420190
	ORDER BY p.mfgnum

		SELECT d.* from dept d, product_dept pd where pd.sku = 420190 AND pd.dept_id = d.dept_id
	

		SELECT * 
			FROM dept 
		 WHERE dept_id = 67793 

	SELECT p.sku, p.name, p.description, p.vendor, p.desc24mf, p.image_file, p.image_width, p.image_height, p.mfg, p.mult, p.uofm, pp.*, pc.* 
		FROM ((((product p INNER JOIN product_price pp ON p.sku=pp.sku) INNER JOIN parent_child pc ON p.sku=pc.sku) INNER JOIN product_dept pd ON p.sku=pd.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id
	 WHERE pp.web="y" AND now()>=pp.sale_start AND now()<=pp.sale_end 
	  AND pp.sale_price < pp.list_price 
GROUP BY pc.super_id
ORDER BY pp.sale_price

	SELECT *
		FROM navigation_gillroys
	 WHERE subdept = 0 OR dept_id =5
	ORDER BY deptname

	SELECT bs.*, p.mfg, p.vendornum, p.vendor, p.mfgnum 
		FROM product p inner join product_bestseller bs on p.sku=bs.sku 
ORDER BY bs.rank 
	 LIMIT 20 

		SELECT b.*, i.*, c.* 
			FROM (howto_body b INNER JOIN howto_cat_index i ON b.id=i.id) INNER JOIN howto_cat c ON i.cat=c.id  
		 WHERE (b.id=102 AND i.cat=100)
		 		OR (b.id=202 AND i.cat=200) 
				OR (b.id=302 AND i.cat=300) 
				OR (b.id=402 AND i.cat=400)
				OR (b.id=502 AND i.cat=500) 
				OR (b.id=602 AND i.cat=600) 
				OR (b.id=702 AND i.cat=700) 
				OR (b.id=802 AND i.cat=800)
		

						SELECT *
						FROM dept
						WHERE dept_id = 67072 

						SELECT *
						FROM dept
						WHERE dept_id = 71005 

						SELECT *
						FROM navigation_gillroys
						WHERE dept_id = 71005 

						SELECT p.sku, p.name, p.mult, bs.rank, pp.*, pc.*, COUNT(pc.sku) AS skucount, d.*, pd.*
							FROM ((((product p INNER JOIN product_price pp ON p.sku=pp.sku) INNER JOIN parent_child pc ON p.sku=pc.sku) INNER JOIN product_dept pd ON p.sku=pd.sku) INNER JOIN product_bestseller bs ON p.sku=bs.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id
							WHERE d.dept_id = 67793
								AND pp.web = 'y'
								AND pc.super_id <> 420190
							GROUP BY pc.super_id
							ORDER by bs.rank
							LIMIT 6
						

							SELECT p.desc24mf, p.mfgnum, p.mult, p.name, p.sku, p.vendor, p.weight, p.uofm, pp.*, pc.*
								FROM (product p INNER JOIN parent_child pc ON p.sku=pc.sku) INNER JOIN product_price pp ON p.sku=pp.sku
							 WHERE pc.super_id = 420190
							 	 AND pp.web = 'y'
						ORDER BY p.mfgnum
						

 
 	SELECT p.sku, p.name, p.description, p.vendor, p.desc24mf, p.image_file, p.image_width, p.image_height, p.mfg, pp.*, pc.*, d.*, pd.*
		FROM (((product p INNER JOIN product_price pp ON p.sku=pp.sku) INNER JOIN parent_child pc ON p.sku=pc.sku) INNER JOIN product_dept pd ON p.sku=pd.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id
	 WHERE p.sku=320382 

		SELECT d.* from dept d where d.dept_id = 66785 

		SELECT pp.*, pc.*, COUNT(pc.super_id) AS skucount
			FROM product_price pp INNER JOIN parent_child pc ON pp.sku=pc.sku
		 WHERE pc.super_id = 320382 
	GROUP BY pc.super_id
	

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 73374 

			SELECT dept_name, parent_id
			FROM dept
			WHERE dept_id = 66785 

			SELECT *
				FROM navigation_gillroys
			 WHERE dept_id = 0 

				SELECT *
				FROM navigation_gillroys
				WHERE home_subdept = 1
				ORDER BY deptname			
			

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 66787
		 AND dept_display = 1
ORDER BY dept_name

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (66863,66867,66852,66851,66856,70964,66866,66850,66849,73735,66857,66864,74763,66854,66853,66855,66865,66859,77847,66861,66860,70972)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787 

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 66784
		 AND dept_display = 1
ORDER BY dept_name

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (66821,66810,66814,66816,66813,66818,66826,66815,66812,66825,77838,77139,66817,66819,66823,66824,66820)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784 

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 66797
		 AND dept_display = 1
ORDER BY dept_name

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (66997,66975,66974,67013,67018,67014,66976,67005,66998,67007,67021,67003,76322,67006,67008,66980,76324,66991,67002,76323,66987,66986,66981,67001,66982,67019,67009,66992,66984,66979,66989,66993,67016,66994,67017,66996,70884,67010,66983,66915,67011,70927,67020,66990,66977,67004,66978,66985,66988,67000,66995)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797 

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 66798
		 AND dept_display = 1
ORDER BY dept_name

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (67028,67027,67032,67033,67029,67034,67025,67024,67023,67022,67031,67026,74401,67030)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66798 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66798 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66798 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66798 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66798 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66798 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66798 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66798 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66798 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66798 

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 70812
		 AND dept_display = 1
ORDER BY dept_name

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (73430,73262,67142,67125,67895,67143,67135,67132,70933,67131,67137,67139,67140,67128,67134,67138,67146,67144,67136,67147,67133,67141)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 70812 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 70812 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 70812 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 70812 

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 66792
		 AND dept_display = 1
ORDER BY dept_name

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (66931,67126,73985,66937,77906,66926,66920,66919,66936,66917,66927,66929,67433,66923,66933,66921,66928,77843,66924,77891,66934,66925,74397,66932)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66792 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66792 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66792 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66792 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66792 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66792 

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 66808
		 AND dept_display = 1
ORDER BY dept_name

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (67197,67206,67205,67993,67202,74609,67199,70922,76576,67200,76101,67966,67207,67963,67204,74329,67208,67969,76104,67201,67203,67198,66868)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66808 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66808 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66808 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66808 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66808 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66808 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66808 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66808 

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 66796
		 AND dept_display = 1
ORDER BY dept_name

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (77945,66964,66972,67584,66966,67529,66967,77942,66971,66963,66973,66969,76144,66970,66965,77949,66961,67530,66968,67531)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796 

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 66805
		 AND dept_display = 1
ORDER BY dept_name

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (73884,67166,67151,74037,76561,67165,67163,66930,67162,67158,73878,73796,67159,67161,67150,73952,76087,73882,67852,74032,76568,74044)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805 

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805 

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805 

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/gilluser/public_html/products/automotive/products/showprod2.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=Accept: application/xhtml+xml,text/html;q=0.9,text/plain;
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=automotive.gillroys.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=
PATH_TRANSLATED=/home/gilluser/public_html/products/automotive/products/showprod2.cfm
QUERY_STRING=sku=420190
REMOTE_ADDR=38.103.63.55
REMOTE_HOST=38.103.63.55
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/products/showprod2.cfm
SERVER_NAME=automotive.gillroys.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache/1.3.41 (Unix) JRun/4.0 PHP/4.4.6 mod_log_bytes/1.2 mod_bwlimited/1.4 mod_auth_passthrough/1.8 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.7a
WEB_SERVER_API=

Client Variables:
cfid=8676687
cftoken=59007224
hitcount=1
lastvisit={ts '2008-12-05 02:44:36'}
timecreated={ts '2008-12-05 02:44:36'}
urltoken=CFID=8676687&CFTOKEN=59007224

Cookie Variables:
CFID=8676687
CFTOKEN=59007224
LANGUAGE=english

Session Variables:
cfid=8676687
cftoken=59007224
sessionid=GILLROYS_8676687_59007224
urltoken=CFID=8676687&CFTOKEN=59007224

URL Parameters:
SKU=420190