Element REFERRERTAG is undefined in SESSION.
	    

			SELECT 	pathCss,group_id,group_name
			FROM   	b2c_groups
			WHERE 	url like '%selectcomfort.icongodev.com|%'
	 

			SELECT store_id,url,ckey
			FROM   b2c_stores
			WHERE store_id !=0
			AND group_id =1
		

					select 	store_id
					from	QrygetStoreByGroup
					where 	store_id = 26 

			SELECT 	 newsletter_category_id
			FROM   	newsletter_categories
			WHERE 	group_id =1
			AND     language_id = 'eng'
			and		active_ind = 'Y'
	 

			SELECT 	ckey
			FROM   	b2c_stores
			WHERE 	store_id = '26'
		

			select	ukey
			,	user_id
			,	store_id
			,	first_name
			,	last_name
			,	address_1
			,	address_2
			,	city
			,	state_id
			,	state_other
			,	country_id
			,	postal_code
			,	telephone
			,   telephone_1
			,   telephone_2
			,   telephone_3
			,   telephone_4
			,	fax
			,	email_1
			,	commonDB.dbo.f_decode(password) as password
			,	language_id
			,	preferred_shipping_method_id
			,	prestige_card
			,   year(date_of_birth) BirthYear
			,   month(date_of_birth) BirthMonth
			,   day(date_of_birth) BirthDay
			,  company_name as company
			, 	member_company_id
			,	custom1
			,	custom2
			,	custom3
			,	custom4
			,	custom5
			,	custom6
			,	custom7
			,	custom8
			,	custom9
      		,   custom10
      		,   custom11
      		,   custom12
      
			,	shared_wish_list_ind
			,	external_database_id
			,   gender_id
			,	date_created
			from	b2c_users
			where	ukey = 27806327 

		select englevel1 as level1
			,		level1Id
			,		nameMasklevel1_eng  as nameMasklevel1
			, 		level1Id_sequence
			
				,
			englevel2 as level2
			,		level2Id
			,		nameMasklevel2_eng  as nameMasklevel2
			, 		level2Id_sequence
			
				,
			englevel3 as level3
			,		level3Id
			,		nameMasklevel3_eng  as nameMasklevel3
			, 		level3Id_sequence
			
		from 	search_b2c_store_item_categories
		order by
		level1Id_sequence desc,level1 desc
			
				,
			level2Id_sequence desc,level2 desc
			
				,
			level3Id_sequence desc,level3 desc
			

				select distinct 
					level2ID_sequence, englevel2 as description,
					level2id as item_category_id,
					namemasklevel1_eng + '/' + namemasklevel2_eng as mask_description
				from 
					search_b2c_store_item_categories
				where 
					level1id =  117
					and level2id is not null
				
				order by 
						level2ID_sequence
					,	englevel2
				

											select distinct 
												level3ID_sequence, 
												level1ID,
												level2ID,
												level3ID,
												englevel3 as description,
												level3id as item_category_id,
												namemasklevel1_eng + '/' + namemasklevel2_eng + '/' + namemasklevel3_eng  as mask_description
											from 
												search_b2c_store_item_categories
											where 
												level1id =  117
												and level2id = 118
												and level3id is not null
											
											order by 
													level3ID_sequence, englevel3
											

			SELECT a.item_id FROM
			 b2c_catalog_items a
			WHERE a.membership_card_ind = 'Y'
			AND a.store_id = ?
			and a.item_id = ? 

			SELECT a.item_id FROM
			 b2c_catalog_items a
			WHERE a.membership_card_ind = 'Y'
			AND a.store_id = ?
			and a.item_id = ? 

			SELECT a.item_id FROM
			 b2c_catalog_items a
			WHERE a.membership_card_ind = 'Y'
			AND a.store_id = ?
			and a.item_id = ? 

			SELECT a.item_id FROM
			 b2c_catalog_items a
			WHERE a.membership_card_ind = 'Y'
			AND a.store_id = ?
			and a.item_id = ? 

											select distinct 
												level3ID_sequence, 
												level1ID,
												level2ID,
												level3ID,
												englevel3 as description,
												level3id as item_category_id,
												namemasklevel1_eng + '/' + namemasklevel2_eng + '/' + namemasklevel3_eng  as mask_description
											from 
												search_b2c_store_item_categories
											where 
												level1id =  117
												and level2id = 126
												and level3id is not null
											
											order by 
													level3ID_sequence, englevel3
											

			SELECT a.item_id FROM
			 b2c_catalog_items a
			WHERE a.membership_card_ind = 'Y'
			AND a.store_id = ?
			and a.item_id = ? 

			SELECT a.item_id FROM
			 b2c_catalog_items a
			WHERE a.membership_card_ind = 'Y'
			AND a.store_id = ?
			and a.item_id = ? 

			SELECT a.item_id FROM
			 b2c_catalog_items a
			WHERE a.membership_card_ind = 'Y'
			AND a.store_id = ?
			and a.item_id = ? 

											select distinct 
												level3ID_sequence, 
												level1ID,
												level2ID,
												level3ID,
												englevel3 as description,
												level3id as item_category_id,
												namemasklevel1_eng + '/' + namemasklevel2_eng + '/' + namemasklevel3_eng  as mask_description
											from 
												search_b2c_store_item_categories
											where 
												level1id =  117
												and level2id = 205
												and level3id is not null
											
											order by 
													level3ID_sequence, englevel3
											

			SELECT a.item_id FROM
			 b2c_catalog_items a
			WHERE a.membership_card_ind = 'Y'
			AND a.store_id = ?
			and a.item_id = ? 

											select distinct 
												level3ID_sequence, 
												level1ID,
												level2ID,
												level3ID,
												englevel3 as description,
												level3id as item_category_id,
												namemasklevel1_eng + '/' + namemasklevel2_eng + '/' + namemasklevel3_eng  as mask_description
											from 
												search_b2c_store_item_categories
											where 
												level1id =  117
												and level2id = 122
												and level3id is not null
											
											order by 
													level3ID_sequence, englevel3
											

			SELECT a.item_id FROM
			 b2c_catalog_items a
			WHERE a.membership_card_ind = 'Y'
			AND a.store_id = ?
			and a.item_id = ? 

			SELECT a.item_id FROM
			 b2c_catalog_items a
			WHERE a.membership_card_ind = 'Y'
			AND a.store_id = ?
			and a.item_id = ? 

				select distinct 
					level2ID_sequence, 
					englevel2 as description,
					level2id as item_category_id,
					namemasklevel1_eng + '/' + namemasklevel2_eng as mask_description
				from 
					search_b2c_store_item_categories
				where 
					level1id =  110
					and level2id is not null
				
				order by 
					level2ID_sequence, englevel2
				

				SELECT
					description_eng
					,	characteric_value_id
				FROM 
					[b2c_catalog_characteristic_values]
				WHERE 	
					characteristic_id = 'Shop by Solution'
				ORDER BY
					description_eng 

					INSERT INTO banner_tracking (banner_id,tracking_type)
					
						SELECT	?
							,	? 
							UNION ALL
						
						SELECT	?
							,	? 
							UNION ALL
						
						SELECT	?
							,	? 
							UNION ALL
						
						SELECT	?
							,	? 
							UNION ALL
						
						SELECT	?
							,	? 
							UNION ALL
						
						SELECT	?
							,	? 
							UNION ALL
						
						SELECT	?
							,	? 
							UNION ALL
						
						SELECT	?
							,	? 
							UNION ALL
						
						SELECT	?
							,	? 
							UNION ALL
						
						SELECT	?
							,	? 
							UNION ALL
						
						SELECT	?
							,	? 

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=\\172.16.11.20\selectdev_websites\websites\selectComfortV9\selectComfort\store.cfm
CONTENT_LENGTH=
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,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=CFID=126694; CFTOKEN=fc3e5fe2f6af1a58-211CE826-C292-6475-B6E487228699C07F; JSESSIONID=14308dbe69bf2ea38eff4d692a3ee5c53525; REVISITSITE=true; REVISITSITEVAR=false; SELECTCOMFORT_COOKIELANGUAGEID=eng; SELECTCOMFORT_COOKIESTOREID=26; SELECTCOMFORT_COOKIEUKEY=27806327
HTTP_HOST=selectcomfort.icongodev.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=/store.cfm
PATH_TRANSLATED=\\172.16.11.20\selectdev_websites\websites\selectComfortV9\selectComfort\store.cfm
QUERY_STRING=lang=eng
REMOTE_ADDR=38.107.179.244
REMOTE_HOST=38.107.179.244
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/store.cfm
SERVER_NAME=selectcomfort.icongodev.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Cookie Variables:
CFID=126694
CFTOKEN=fc3e5fe2f6af1a58-211CE826-C292-6475-B6E487228699C07F
JSESSIONID=14308dbe69bf2ea38eff4d692a3ee5c53525
REVISITSITE=true
REVISITSITEVAR=false
SELECTCOMFORT_COOKIELANGUAGEID=eng
SELECTCOMFORT_COOKIESTOREID=26
SELECTCOMFORT_COOKIEUKEY=27806327

Session Variables:
actuallang=eng
b2corder=Struct (5)
brandselected=
currencyid=USD
email_subscription=no
ipcountry=
loggedind=N
member_company_id=
menucount=0
preferredlocation=Struct (11)
sessionid=14308dbe69bf2ea38eff4d692a3ee5c53525
shoppingcartstepactive=Struct (5)
storeid=26
ukey=27806327
urltoken=CFID=126694&CFTOKEN=fc3e5fe2f6af1a58-211CE826-C292-6475-B6E487228699C07F&jsessionid=14308dbe69bf2ea38eff4d692a3ee5c53525
useremail=
userfirstname=
userlastname=

URL Parameters:
LANG=eng