Penn State Souvenirs & Gift Items

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='souvenirs' or url='/souvenirs'

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

select web_url from application.getWebTaxonomy where upper(dept)='SOUVENIRS' and typ='EMPTY'

select * from application.getWebTaxonomy where dept='Souvenirs' and typ<>'EMPTY' and subtyp_1='EMPTY' and sort_position<>'NO' order by sort_position desc

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 ltrim(dept)='Souvenirs'
		
                        	and (
                        	
                        		upper(Brand) LIKE 'TEAM%SPORTS%AMERICA'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'YETI'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'HANNAS%HANDIWORKS'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'JUNK%BRANDS'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'SDS%DESIGN'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'LOGO%INC'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'WORTHY%PROMOTIONAL'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'MAGNOLIA%LANE'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'COLOR%SHOUT'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'FROM%THE%HEART'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'NIKE'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'LOGOFIT'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'HUGGLE%HOUNDS'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'BLAKEWAY%PANORAMAS'
                            	)
                         GROUP BY STYLE_ID
		ORDER BY sortposition

SELECT * FROM GetALLProducts1010 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

		
			and ltrim(dept)='Souvenirs'
		GROUP BY STYLE_ID

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

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='Souvenirs' 
		order by dept asc, typ asc, subtyp_1 asc, subtyp_2 asc, subtyp_3 asc

select dept, typ, subtyp_1, subtyp_2, subtyp_3, active, web_url, category_style from application.getWebTaxonomy where 
			
			
					dept='Souvenirs'
					and typ<>'EMPTY'
					and subtyp_1='EMPTY'
				
			
			order by sort_position desc

select dept, typ, subtyp_1, subtyp_2, subtyp_3 from tb_web_taxonomy where web_url='souvenirs'

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, typ, subtyp_1, subtyp_2, subtyp_3 from tb_web_taxonomy where web_url='souvenirs' Order By SORT_POSITION ASC

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

SELECT  web_url 
                FROM tb_web_taxonomy 
                WHERE dept='Souvenirs' and typ = 'EMPTY' 				
                ORDER BY sort_position

SELECT DISTINCT typ, count(distinct style_id) as itemCount 
                FROM web_all_products 
                WHERE dept='SOUVENIRS' and upper(typ)<>'EMPTY' and style_id IN (12621,12554,12553,12546,12526,12518,12519,12515,12493,12487,12474,12467,12471,11964,12401,12398,12285,12237,12234,12235,12236,12232,12233,12231,12229,12230,12228,12227,12171,12170,12169,12168,12165,12135,12115,12116,12123,12097,12073,12050,12063,12051,12062,12061,12060,12064,12059,12058,12057,12056,12055,12054,12053,12052,12020,12023,12024,12022,11999,11974,11973,11963,11955,11954,11956,11953,11828,11706,11603,11666,11667,11665,11668,11654,11629,11627,11628,11626,11619,11599,11588,11527,11473,11386,11361,11354,11349,11347,11348,11293,11289,11294,11287,11190,11180,11181,11164,11165,11166,11178,11177,11176,11175,11174,11173,11172,11171,11170,11169,11168,11167,11108,11107,11105,11101,11080,11079,11083,10897,10896,10895,10894,10893,10892,10891,10890,10889,10888,10887,10886,10885,10884,10883,10882,10881,10880,10879,10878,10877,10876,10875,10874,10873,10872,10871,10870,10869,10868,10867,10865,10864,10863,10862,10861,10860,10859,10590,10791,10783,10690,10486,10485,10419,10361,10360,10367,9875,10364,10333,10332,10330,10329,10116,9874,10061,9947,9946,8856,9918,9917,9912,9911,9902,9896,9895,9892,9832,9831,9833,9703,9701,9618,9568,9533,9446,9104,9072,9071,9069,9063,9064,9065,9066,9067,8986,8985,8984,8921,8911,8820,8796,8617,8616,8612,8269,8542,8477,8476,8480,8370,8293,8132,8131,8031,7729,7273,7272,7202,7198,7005,6991,6983,6782,6781,6783,6780,6717,6716,6595,6594,6202,6201,6046,5847,5400,4833,4695,4612,3894,3746,3743,2737,3048,2684,2686,2352,2319,1805,1085,255,462,1078,1077,577,972,522,566,565,511,510,509,508,950,977,976,913,918,973,942,908,917,915,916)  
                GROUP BY typ

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 ('6','L','M','OSFM','S') 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-08-19 17:29:47.0' and displaystop>='2024-08-19 17:29:47.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=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.pennstateclothes.com
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=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.pennstateclothes.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=fikker-61vm-nk2N=MgPGRI6oXLV7DSLWJk4y6wNi63F1ZE0E
HTTP_HOST=www.pennstateclothes.com
HTTP_REFERER=https://pennstateclothes.com/souvenirs/browse/brand/team-sports-america,yeti,hannas-handiworks,junk-brands,sds-design,logo-inc,worthy-promotional,magnolia-lane,color-shout,from-the-heart,nike,logofit,huggle-hounds,blakeway-panoramas
HTTP_URL=/category.cfm?mapping=souvenirs/browse/brand/team-sports-america,yeti,hannas-handiworks,junk-brands,sds-design,logo-inc,worthy-promotional,magnolia-lane,color-shout,from-the-heart,nike,logofit,huggle-hounds,blakeway-panoramas
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
LOCAL_ADDR=208.117.84.111
PATH_INFO=
PATH_TRANSLATED=C:\Websites\FamilyClothesLine\category.cfm
QUERY_STRING=mapping=souvenirs/browse/brand/team-sports-america,yeti,hannas-handiworks,junk-brands,sds-design,logo-inc,worthy-promotional,magnolia-lane,color-shout,from-the-heart,nike,logofit,huggle-hounds,blakeway-panoramas
REMOTE_ADDR=172.69.7.64
REMOTE_HOST=172.69.7.64
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=22312004
cftoken=25c338990ef62f54-3D760DDA-E42F-F461-79D6D15AC1D69E57
hitcount=1
lastvisit={ts '2024-08-19 17:29:47'}
timecreated={ts '2024-08-19 17:29:47'}
urltoken=CFID=22312004&CFTOKEN=25c338990ef62f54-3D760DDA-E42F-F461-79D6D15AC1D69E57

Cookie Variables:
CFID=22312004
CFTOKEN=25c338990ef62f54-3D760DDA-E42F-F461-79D6D15AC1D69E57
fikker-61vm-nk2N=MgPGRI6oXLV7DSLWJk4y6wNi63F1ZE0E

Form Fields:
KWORD=

Session Variables:
cartstatus=NEW
cfid=22312004
cftoken=25c338990ef62f54-3D760DDA-E42F-F461-79D6D15AC1D69E57
checkout=Struct (4)
couponreset=NO
cs=https://www.pennstateclothes.com/souvenirs/browse/brand/team-sports-america,yeti,hannas-handiworks,junk-brands,sds-design,logo-inc,worthy-promotional,magnolia-lane,color-shout,from-the-heart,nike,logofit,huggle-hounds,blakeway-panoramas
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/souvenirs/browse/brand/team-sports-america,yeti,hannas-handiworks,junk-brands,sds-design,logo-inc,worthy-promotional,magnolia-lane,color-shout,from-the-heart,nike,logofit,huggle-hounds,blakeway-panoramas
password=
phone=
pickupstore=1
qualifyingpromoitems=0
sessionid=PENNSTATECLOTHESRESPONSIVE5_22312004_25c338990ef62f54-3D760DDA-E42F-F461-79D6D15AC1D69E57
settings=Query (1)
shipmethodlist=0,1
urltoken=CFID=22312004&CFTOKEN=25c338990ef62f54-3D760DDA-E42F-F461-79D6D15AC1D69E57
username=
website=Struct (1)

URL Parameters:
mapping=souvenirs/browse/brand/team-sports-america,yeti,hannas-handiworks,junk-brands,sds-design,logo-inc,worthy-promotional,magnolia-lane,color-shout,from-the-heart,nike,logofit,huggle-hounds,blakeway-panoramas