SELECT 	pathCss,group_id,group_name
			FROM   	b2c_groups
			WHERE 	url like ? 

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

					select 	store_id
					from	QrygetStoreByGroup
					where 	store_id = 26 

				SELECT 	store_id
				FROM   	b2c_stores
				WHERE 	store_id = ?
				AND url like ? 

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

			INSERT INTO b2c_users ( User_ID , store_id , Password , visiting_ip , visiting_host , visiting_browser_type , visiting_http , icongo_sid , language_id , address_1 , city , state_id , Country_id , postal_code , email_1 , first_name , last_name , date_last_accessed , date_modified , date_created , no_of_logins , require_login_ind , terms_accepted_ind ) VALUES ( '' , 
			?
			, '' 
			
				, 
				? 
				, 
				? 
				, 
				? 
				, 
				? 
				, 
				? 
			, 
			?
			, '' , '' , '' , '' , '' , '' , '' , '' , GETDATE() , GETDATE() , GETDATE() , 0 , 'Y' , 'Y' ) SELECT @@IDENTITY AS 'Identity' 
		

	select	first_name
	,	last_name
	,	email_1
	,	prestige_card
	from	b2c_users
	where	ukey = ? 

	select	order_id
	,	extended_price
	from	b2c_orders
	where	ukey = ?
	and	order_status_id = 1
	

		select	order_id
		,	extended_price
		from	b2c_orders
		where	ukey = ?
		and	order_status_id = 1
	

		select order_id from b2c_orders where ukey = 
		?
		and order_status_id = 1 
	

			SELECT 	ckey
			FROM   	b2c_stores
			WHERE 	store_id = ? 

		SELECT country_id
		FROM ip_countries
		WHERE 644592624 BETWEEN start_number_ip AND end_number_ip
	

			SELECT	bct.banner_placeholder_id
				,	bct.banner_campaign_id
				,	banners.banner_id
			FROM	banner_campaign_thresholds bct
					JOIN banner_placeholders ph ON ph.banner_placeholder_id = bct.banner_placeholder_id
						AND ph.archived = 'N'
					JOIN banners ON banners.banner_placeholder_id = ph.banner_placeholder_id
						AND banners.banner_campaign_id = bct.banner_campaign_id
						AND banners.active_ind = 'Y'
			WHERE	banners.converted_orders >= bct.conversion_threshold
			AND		EXISTS (
				
				SELECT	1
				FROM	banners b
				WHERE	b.banner_campaign_id = banners.banner_campaign_id
				AND		b.banner_placeholder_id = ph.banner_placeholder_id
				AND		b.banner_id <> banners.banner_id
				AND		b.active_ind = 'Y'
				AND	NOT EXISTS (
					
					SELECT	1
					FROM	banners b2
					WHERE	b2.banner_campaign_id = banners.banner_campaign_id
					AND		b2.banner_placeholder_id = ph.banner_placeholder_id
					AND		b2.active_ind = 'Y'
					AND		b2.banner_id <> b.banner_id
					
					
					AND		b.converted_orders >= b2.converted_orders
				)
			)			
		

			SELECT	b.banner_id
				,	b.banner_name
				,	b.default_banner_ind
				,	b.alt_tag_message
				,	b.onclick_url
				,	b.onclick_new_window_ind
				,	b.image_map
				,	b.ext
				,	CASE WHEN ISNULL(b.banner_weight,0) = 0 THEN 1 ELSE b.banner_weight END as banner_weight
				,	CAST(b.banner_id AS VARCHAR) + '_1.' + b.ext as source

				
				,	b.banner_placeholder_id
				,	b.language_id
				,	b.store_id
				,	b.member_company_id
				
				,	CASE WHEN ISNULL( b.site_key, '0' ) = '0' THEN 'default' ELSE b.site_key END AS site_key
				
				,	ISNULL(rt.referrer_tag, 0) AS referrer_tag
				
				
				
				,	b.categoryId
				,	b.brand_id
				,	b.keywords
				,	ISNULL( b.country_id, 0 ) as country_id
				
				
				,	isnull(b.model_id, 0) as model_id
								
				
				,	b.banner_key_1

				
				,	b.banner_key_2
				,	b.banner_type_id
				,	CASE
						WHEN b.banner_type_id IN (3,4,5) THEN 1
						ELSE 0
					END	as productDisplay

				
				,	b.banner_tracking
				,	b.track_conversion
				,	b.no_follow_ind

				,	b.banner_campaign_id
				,	b.product_tags
				
				,	isnull(b.sequence, 0) as sequence
				
				,	b.title
				
			FROM	banners b WITH (NOLOCK)
					JOIN banner_placeholders bph WITH (NOLOCK) ON bph.banner_placeholder_id = b.banner_placeholder_id
						AND b.archived = bph.archived
					
						LEFT JOIN referrer_tags rt WITH (NOLOCK) ON rt.referrer_id = b.referrer_id
					
			WHERE	b.archived = 'N'
			AND		b.active_ind = 'Y'
			AND		getdate() between b.start_date and b.end_date
		

			SELECT	banner_placeholder_id
				,	description_eng
				,	description_fre
				,	width
				,	height
				,	placeholder_tracking
				,	placeholder_type
				,	group_id
				,	CASE WHEN sequence = 0 THEN 100 ELSE sequence END as sequence
				,	has_category_ind
				
				,	ISNULL(front_end_variable_name, banner_placeholder_id) as front_end_variable_name
				
			FROM	banner_placeholders WITH (NOLOCK)
			WHERE	archived = 'N'
		

			SELECT	banner_link_id
				,	store_id
				,	destination_url
			FROM	banners_link_tracking WITH (NOLOCK)
		

				SELECT	banner_id
					,	item_id
				FROM	banner_item WITH (NOLOCK)
				
				
			

				SELECT	b.banner_id
					,	ISNULL( bsl.store_location_id, 0 ) as store_location_id
				FROM	banners b WITH (NOLOCK)
						LEFT JOIN banner_store_location bsl WITH (NOLOCK)
							ON b.banner_id = bsl.banner_id
						LEFT JOIN banner_placeholders bph WITH (NOLOCK) ON bph.banner_placeholder_id = b.banner_placeholder_id
							AND b.archived = bph.archived
				WHERE	b.archived = 'N'
				AND		b.active_ind = 'Y'
				AND		getdate() between b.start_date and b.end_date
			

			SELECT *
			FROM ebay_stores
			WHERE ebay_store_id = ?
			AND active_ind = 'Y'
		

					INSERT INTO banner_tracking (banner_id,tracking_type)
					
						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\ltdev_websites\websites\lordAndTaylor\lordAndTaylor\store.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,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=GS_visit=1
HTTP_HOST=lordandtaylor.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\ltdev_websites\websites\lordAndTaylor\lordAndTaylor\store.cfm
QUERY_STRING=
REMOTE_ADDR=38.107.179.240
REMOTE_HOST=38.107.179.240
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/store.cfm
SERVER_NAME=lordandtaylor.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=228416
CFTOKEN=a2fd244fd1b0aa9a-6D110E7F-5056-1B48-718EE3175AF81324
GS_visit=1
LORDANDTAYLOR_COOKIESTOREID=26

Session Variables:
actuallang=eng
b2corder=Struct (5)
brandselected=
currencyid=USD
ipcountry=
loggedind=N
menucount=0
remote_addr=38.107.179.240
sessionid=1430d8c4ac66bb14be5e7a727b6a684a6359
storeid=26
timersearch=Struct (1)
ukey=14853219
urltoken=CFID=228416&CFTOKEN=a2fd244fd1b0aa9a-6D110E7F-5056-1B48-718EE3175AF81324&jsessionid=1430d8c4ac66bb14be5e7a727b6a684a6359
useremail=
userfirstname=
userlastname=

URL Parameters:
CKEY=US
USECACHE=true