SELECT * from web_settings with (nolock) WHERE web_settings_id = 1

SELECT c.header_name, c.compare_use, c.filter_use from tb_web_attribute_styles a
	INNER JOIN tb_web_attribute_values b WITH (NOLOCK) on (b.WEB_ATTRIBUTE_VALUE_ID = a.WEB_ATTRIBUTE_VALUE_ID)
	INNER JOIN tb_web_attribute_headers c WITH (NOLOCK) on (c.WEB_ATTRIBUTE_HEADER_ID = b.WEB_ATTRIBUTE_HEADER_ID)
	INNER JOIN tb_web_attribute_groups d WITH (NOLOCK) on (d.WEB_ATTRIBUTE_GROUP_ID = c.WEB_ATTRIBUTE_GROUP_ID)
	WHERE c.filter_use='Y' or c.compare_use='Y'
	GROUP BY c.header_name, c.compare_use, c.filter_use

select * from web_category_mappings where url='all-products' or url='/all-products'

select * from application.getWebTaxonomy where upper(web_url)=?  and sort_position<>'NO'

SELECT distinct style_id
		
		, max(url) as url
		, max(realName) as realName
		, max(style) as style
		, max(overallqoh) as overallqoh
		, max(sale) as sale
		, max(new) as new
		, max(SmallPicture) as SmallPicture
		, max(MediumPicture) as MediumPicture
		, max(LargePicture) as LargePicture
		, min(sortposition) as sortposition
		, max(web_taxonomy_id) as web_taxonomy_id
		, max(dept) as dept
		, max(typ) as typ
		, max(subtyp1) as subtyp1
		, max(subtyp2) as subtyp2
		, max(subtyp3) as subtyp3
		, max(brand) as brand
		, max(branddisplay) as branddisplay
		, max(team) as team
		, max(league) as league
		, max(priceRange) as priceRange
		, min(salePriceRangeBottom) as salePriceRangeBottom
		, max(salePriceRangeTop) as salePriceRangeTop
		, max(ListPrice) as ListPrice
		, max(ranking) as ranking
		, max(alternateteam) as alternateteam
		, max(romanticcopylong) as romanticcopylong
		, max(romanticcopyshort) as romanticcopyshort
		, max(depttree) as depttree
		, max(weight) as weight
		, max(attr1list) as attr1list
		, max(hexlist) as hexlist
		, max(sizelist) as sizelist
		, max(name) as name
		, max(inventorytype) as inventorytype
		, max(GOOGLEPRODUCTTAXONOMY) as GOOGLEPRODUCTTAXONOMY
		, max(gender) as gender
		, max(agerange) as agerange
		, max(picture_id) as picture_id
		, max(isFeaturedItem) as isFeaturedItem
		, max(prodReviewsAverage) as prodReviewsAverage
		, max(INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(INTERNALPRICE) as INTERNALPRICE
		, max(TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(TERMSALEPRICE) as TERMSALEPRICE
		, max(TERMSALE) as TERMSALE
		
		
		FROM [dbo].[web_all_products] WHERE pictureid is not null
		   
		
                        	and (
                        	
                        		upper(Brand) LIKE 'ORIENTAL%TRADING'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'MAGNOLIA%LANE'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'ROCK%LION'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'JUNK%BRANDS'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'GAMEDAY%IRONWORKS'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'THE%FAMILY%CLOTHESLINE'
                            	)
                         GROUP BY STYLE_ID
		ORDER BY sortposition

SELECT * FROM GetALLProducts ORDER BY
		new desc, picture_id desc

SELECT distinct style_id
		
		, max(brand) as brand
		, max(branddisplay) as branddisplay
		
		FROM [dbo].[web_all_products] 
        WHERE pictureid is not null

		GROUP BY STYLE_ID

SELECT Upper(brand) as brand,branddisplay, count(distinct
              
                style_id
              
              ) as itemCount 
              FROM GetALLBrands
              WHERE Brand>''
              GROUP BY brand,branddisplay 
              order by brand asc

SELECT contentID, active, Body, METAKEYWORDS, METADESC, parentID, path, HTMLTITLE, releaseDate, FileName, Title, menuTitle, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Type, KEYPOINTS, credits
		    FROM tcontent
		    WHERE (parentID = '9D8C4EC2-155D-2292-0553F4E061215B96') and (urltitle = 'oriental-trading,magnolia-lane,rock-lion,junk-brands,gameday-ironworks,the-family-clothesline') AND (active = 1) AND (type='PAGE') AND ( (display = 1) or (display=2 and displaystart<='2024-09-25 13:59:58.0' and displaystop>='2024-09-25 13:59:58.0') 
		    )

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '183DF292-155D-2292-05CD90B735988F90') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '17B239A1-155D-2292-0511D9290403C1F4') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '17B6794D-155D-2292-057225F49C7C6629') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '17D68E89-155D-2292-054557E1D340E780') AND (active = 1)

SELECT contentID, active, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Body, METAKEYWORDS, METADESC, HTMLTITLE, credits, target
            FROM tcontent
            WHERE (parentID = '3F9597FE-155D-2292-05E8913CE1548D0A') AND (active = 1)
            ORDER BY orderno

select dept, typ, subtyp_1, subtyp_2, subtyp_3,category_style from application.getWebTaxonomy where 
		
		dept='' and typ='' and subtyp_1='' and subtyp_2='' and subtyp_3='' 
		order by dept asc, typ asc, subtyp_1 asc, subtyp_2 asc, subtyp_3 asc

SELECT
        
        pricerange as price
        
        , count(distinct
        
          style_id
        
        ) as itemCount FROM getproducts WHERE
        
        pricerange
        
        >''
        
        GROUP BY
        
        pricerange order by pricerange asc

select * from temp order by ranking asc

select distinct
        
          sizeList
          
        from getproducts where
        
          sizeList
          
        >'' group by  
        
          sizeList

select distinct
        
          attr1List
        
        from getproducts where
        
          attr1List
        
        >'' group by  
        
          attr1List

SELECT dept, web_url 
                FROM tb_web_taxonomy 
                WHERE dept>'' and typ='EMPTY' and dept<>'EMPTY'  
                ORDER BY sort_position

SELECT DISTINCT dept, count(distinct style_id) as itemCount 
                FROM web_all_products 
                WHERE dept<>'EMPTY' 
				and style_id IN (12740,12713,12712,12728,12722,12726,12721,12725,12720,12724,12719,12723,12718,12698,12689,12690,12691,12697,12682,12662,12663,12659,12658,12657,12258,12259,12610,12611,12600,12585,12566,12559,12558,12564,12583,12584,12565,12582,12581,12563,12580,12562,12579,12561,12578,12560,12577,12576,12575,12556,12573,12557,12574,12572,12552,12571,12551,12570,12550,12569,12549,12568,12548,12567,12547,12516,12489,12486,12423,12427,12407,12410,12409,12408,12347,12337,12324,12321,12306,12305,12287,12292,12286,12283,12284,12282,12278,12268,12267,12261,12224,12195,12242,12210,11970,12174,12173,12175,12113,12112,12111,12110,12109,12097,12096,12095,12094,12090,12089,12088,12085,12073,12047,12035,12045,12033,12044,12032,12043,12031,12042,12049,12041,12030,12040,12029,12039,12038,12037,12028,12027,12048,12026,12036,12001,12002,12003,11974,11971,11967,11963,11955,11954,11956,11939,11816,11770,11771,11698,11695,11694,11693,11692,11603,11669,11605,11602,11586,11584,11514,11513,11400,11413,11412,11414,11398,11394,11397,11393,11395,11391,11396,11392,11388,11308,11292,11265,11264,11263,11262,11261,11258,11233,11257,11253,11228,11249,11248,11247,11246,11245,11242,11241,11252,11251,11227,11226,11250,11225,11237,11220,11236,11235,11219,11218,11234,11190,11157,11161,11160,11159,11151,11132,11095,11083,11057,11024,11022,11021,11020,10963,10977,10973,10974,10980,10976,10975,10981,10979,10954,10964,10998,10958,11003,10989,10990,11001,10969,10987,10957,10986,10960,10991,11002,10988,11004,10995,11010,10994,10997,10999,10984,11019,11007,11013,11005,11015,11016,11018,11008,10946,10944,10950,10943,10945,10935,10940,10938,10933,10936,10939,10942,10951,10961,10953,10955,10967,10941,10971,10930,10948,10965,10937,10931,10928,10924,10925,10927,10921,10922,10914,10919,10913,10915,10905,10910,10908,10903,10906,10909,10912,10920,10911,10900,10917,10907,10901,10898,10600,10598,10062,10715,10717,10714,10692,10693,10694,10695,10540,10539,10534,10533,10531,10526,10524,10525,10511,10501,10500,10466,10465,10464,10463,10470,10469,10332,10330,10329,10157,10154,10153,10113,10111,10071,9914,9913,9832,9652,9745,9735,9736,9728,9730,9671,9062,9449,9413,9404,9403,9333,9314,9322,9325,9324,9323,9234,9203,9208,9200,9209,9173,9148,9147,9146,9145,9059,9058,9095,9094,9086,9084,9083,9082,9060,9051,9008,9006,9005,8994,8967,8926,8927,8925,8924,8911,8863,8825,8830,8827,8826,8821,8055,8727,8724,8726,8725,8611,8489,8544,8269,8177,8297,8285,8293,8244,8073,8081,7385,7937,7936,7925,7926,7928,7734,7684,7685,7591,7588,7587,7586,7582,7550,7569,7570,7548,5329,7535,7534,7339,7336,7338,7290,7289,7287,7267,7273,7272,7198,7151,7144,7033,7005,6681,6362,5381,5382,5374,5373,5368,4829,4805,4795,4743,4323,4041,4015,3944,3943,3941,3719,2797,2714,2713,2021,2020,1602,1310,468,793,500,586,255,1340,898,1215,780,783,1224,1183,1313,752,1334,896,497,762,766,1225,1222,773,1329,1350,1217,1335,1184,1294,1361,1355)
                GROUP BY dept

SELECT pricerange as price, count(distinct
  
    style_id
  
  ) as itemCount FROM GETPRODUCTS WHERE pricerange > ''
	GROUP BY pricerange order by pricerange asc

select * from temp order by ranking asc

select distinct hexLIST 
        from getproducts 
        group by hexLIST

select distinct sizeList 
	from GETPRODUCTS 
	where sizeList <>''  
	group by sizeList

SELECT DISTINCT siz, max(size_order) as size_order
		FROM tb_size_entries
		WHERE upper(siz) IN ('2T','3T','4T','5/6','2XT','3XT','4XT','3X','2X','4XL','6M','12M','18M','ADJUSTABLE','L','XXL','M','XL','NWBN','S','XS','XS/S','M/L','YM','YL','YS','YXL','YXS') and upper(siz) <> 'NS' and upper(siz) <> 'N/S'
		GROUP BY siz
		ORDER BY max(size_order), siz

SELECT contentID, active, Body, METAKEYWORDS, METADESC, parentID, path, HTMLTITLE, releaseDate, FileName, Title, menuTitle, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Type, KEYPOINTS, credits
		    FROM tcontent
		    WHERE (parentID = '9D8C4EC2-155D-2292-0553F4E061215B96') and (tags like '%homepage%') AND (active = 1) AND (type='PAGE') AND ( (display = 1) or (display=2 and displaystart<='2024-09-25 13:59:58.0' and displaystop>='2024-09-25 13:59:58.0') 
		    ) ORDER BY orderno

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CB7F4-155D-2292-054C1ED3FABCF731') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CC048-155D-2292-056970FA6984D7F3') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CC0BB-155D-2292-0522EFDD9954F2CE') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '6DB63DB6-155D-2292-055A9BC44BA8A9E1') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8C4D64-155D-2292-057BD50838A99E44') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CB957-155D-2292-058B97FF271F2C79') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CB0E6-155D-2292-0583324B1B016B6B') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CCF27-155D-2292-055AD9DC216B7FE8') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CB84F-155D-2292-05707305148F2AC9') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CC0EC-155D-2292-05A3E8C5C5F88E8B') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CA66B-155D-2292-05DE8B8AB7B7713C') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CD025-155D-2292-05EF10583C25003F') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CD112-155D-2292-05D3835227C916B1') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CD0E8-155D-2292-054CD3CC2B771CEE') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CD0BD-155D-2292-054CCD5667F7D9EA') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CC11C-155D-2292-05E840C5D0DCDB59') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CCF52-155D-2292-0598D81371BC6686') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CCFA5-155D-2292-055603E678ECA072') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CCF7D-155D-2292-05E2CD3025D163D5') AND (active = 1)

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, METAKEYWORDS, METADESC, HTMLTITLE, credits
            FROM tcontent
            WHERE (contentID = '9D8CCFCD-155D-2292-0525FBB21D88F78C') AND (active = 1)

select * from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and sort_position<>'NO' and len(web_url)>0

SELECT  dept,SHORT_DESC,LONG_DESCRIPTION, web_url from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and typ='EMPTY' Order By SORT_POSITION ASC

SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='MENS' Order By SORT_POSITION ASC

SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='WOMENS' Order By SORT_POSITION ASC

SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='KIDS' Order By SORT_POSITION ASC

SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='JERSEYS' Order By SORT_POSITION ASC

SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='TSHIRTS' Order By SORT_POSITION ASC

SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='SPORTS' Order By SORT_POSITION ASC

SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='SWEATSHIRTS' Order By SORT_POSITION ASC

SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='HEADWEAR' Order By SORT_POSITION ASC

SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='SOUVENIRS' Order By SORT_POSITION ASC

SELECT typ, web_url, SORT_POSITION from tb_web_taxonomy where (active<>0 or dept='SEARCH' or upper(dept)='GIFT CARDS') and subtyp_1='EMPTY'  and typ<>'EMPTY' and upper(dept)='FOOTWEAR' Order By SORT_POSITION ASC

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O="CloudFlare, Inc.", OU=CloudFlare Origin SSL Certificate Authority, L=San Francisco, S=California
CERT_SERVER_SUBJECT=O="CloudFlare, Inc.", OU=CloudFlare Origin CA, CN=CloudFlare Origin Certificate
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\websites\FamilyClothesLine\category.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O="CloudFlare, Inc.", OU=CloudFlare Origin SSL Certificate Authority, L=San Francisco, S=California
HTTPS_SERVER_SUBJECT=O="CloudFlare, Inc.", OU=CloudFlare Origin CA, CN=CloudFlare Origin Certificate
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.pennstateclothes.com
HTTP_REFERER=
HTTP_URL=/category.cfm?mapping=all-products/browse/brand/oriental-trading,magnolia-lane,rock-lion,junk-brands,gameday-ironworks,the-family-clothesline
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
LOCAL_ADDR=216.98.3.62
PATH_INFO=
PATH_TRANSLATED=C:\websites\FamilyClothesLine\category.cfm
QUERY_STRING=mapping=all-products/browse/brand/oriental-trading,magnolia-lane,rock-lion,junk-brands,gameday-ironworks,the-family-clothesline
REMOTE_ADDR=172.70.130.112
REMOTE_HOST=172.70.130.112
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/category.cfm
SERVER_NAME=www.pennstateclothes.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=79600
cftoken=ada43e1b0056107d-A7653FD7-9D40-DE1E-1A9548F8E6AF5B5E
hitcount=1
lastvisit={ts '2024-09-25 13:59:57'}
timecreated={ts '2024-09-25 13:59:57'}
urltoken=CFID=79600&CFTOKEN=ada43e1b0056107d-A7653FD7-9D40-DE1E-1A9548F8E6AF5B5E

Cookie Variables:
CFID=79600
CFTOKEN=ada43e1b0056107d-A7653FD7-9D40-DE1E-1A9548F8E6AF5B5E

Form Fields:
KWORD=

Session Variables:
cartstatus=NEW
cfid=79600
cftoken=ada43e1b0056107d-A7653FD7-9D40-DE1E-1A9548F8E6AF5B5E
checkout=Struct (4)
couponreset=NO
cs=https://www.pennstateclothes.com/all-products/browse/brand/oriental-trading,magnolia-lane,rock-lion,junk-brands,gameday-ironworks,the-family-clothesline
customer_id=
customerdiscount=0
display_cc=YES
displaycount=32
email=
employeeloggedin=false
first_name=
getheaders=,
getwebtaxonomy=Query (447)
last_name=
memberloggedin=N
myreturnurl=https://www.pennstateclothes.com/all-products/browse/brand/oriental-trading,magnolia-lane,rock-lion,junk-brands,gameday-ironworks,the-family-clothesline
password=
phone=
pickupstore=1
qualifyingpromoitems=0
sessionid=PENNSTATECLOTHESRESPONSIVE5_79600_ada43e1b0056107d-A7653FD7-9D40-DE1E-1A9548F8E6AF5B5E
settings=Query (1)
shipmethodlist=0,1
urltoken=CFID=79600&CFTOKEN=ada43e1b0056107d-A7653FD7-9D40-DE1E-1A9548F8E6AF5B5E
username=
website=Struct (1)

URL Parameters:
mapping=all-products/browse/brand/oriental-trading,magnolia-lane,rock-lion,junk-brands,gameday-ironworks,the-family-clothesline