Filters

Penn State Collectibles

Display your Nittany Lion pride loud and proud! Find the perfect gift or next addition to your fan cave with our selection of Penn State collectibles.

Sort By

Items per page:

Now Viewing 1 -2 of 2 Items

BADEN SPORTS Penn State 6.5" Autograph Micro Print Football $19.99

BADEN SPORTS Penn State Autograph Print Logo Football $34.99

Sort By

Items per page:

Now Viewing 1 -2 of 2 Items

Debugging Information

ColdFusion Server Standard	2021,0,16,330307
Template	/category.cfm
Time Stamp	24-Sep-24 11:59 PM
Locale	English (US)
User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP	172.71.255.30
Host Name	172.71.255.30

Execution Time

Total Time	Avg Time	Count	Template
250 ms	250 ms	1	C:\websites\FamilyClothesLine\category.cfm
78 ms	78 ms	1	C:/websites/FamilyClothesLine/includes/footer.cfm
31 ms	31 ms	1	C:/websites/FamilyClothesLine/includes/sidenav.cfm
31 ms	31 ms	1	C:/websites/FamilyClothesLine/includes/views/departments.cfm
16 ms	16 ms	1	C:/websites/FamilyClothesLine/Application.cfm
16 ms	8 ms	2	C:/websites/FamilyClothesLine/includes/views/thumbnails.cfm
16 ms	16 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc \| getALLBrandsFromOverallQuery([complex value]) ] from C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc
16 ms	16 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CD0BD-155D-2292-054CCD5667F7D9EA) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
15 ms	15 ms	1	C:/websites/FamilyClothesLine/includes/header.cfm
15 ms	15 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getPagesByTag(homepage, 9D8C4EC2-155D-2292-0553F4E061215B96, 20) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	C:/websites/FamilyClothesLine/functions/categoryfunctions.cfm
0 ms	0 ms	1	C:/websites/FamilyClothesLine/includes/application/check_db.cfm
0 ms	0 ms	1	C:/websites/FamilyClothesLine/includes/application/create_query_string.cfm
0 ms	0 ms	1	C:/websites/FamilyClothesLine/includes/application/paypal_config.cfm
0 ms	0 ms	1	C:/websites/FamilyClothesLine/includes/application/url_variable_defaults.cfm
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cart.cfc \| getCartQtyTotal() ] from C:/websites/FamilyClothesLine/functions/cart.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc \| createLowerPagination(2, 1, 32, 5, https://www.pennstateclothes.com/collectibles/browse/brand/oriental-trading,tutu-spirit,magnolia-lane,zeppelin-products,baden-sports,mascot-factory,aurora/color/brown, [complex value], [complex value]) ] from C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc \| seoTagGenerator(false, check, [complex value], [complex value]) ] from C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getChildren(3F9597FE-155D-2292-05E8913CE1548D0A) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(17B239A1-155D-2292-0511D9290403C1F4) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(17B6794D-155D-2292-057225F49C7C6629) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(17D68E89-155D-2292-054557E1D340E780) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(183DF292-155D-2292-05CD90B735988F90) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(6DB63DB6-155D-2292-055A9BC44BA8A9E1) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8C4D64-155D-2292-057BD50838A99E44) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CA66B-155D-2292-05DE8B8AB7B7713C) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CB0E6-155D-2292-0583324B1B016B6B) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CB7F4-155D-2292-054C1ED3FABCF731) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CB84F-155D-2292-05707305148F2AC9) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CB957-155D-2292-058B97FF271F2C79) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CC048-155D-2292-056970FA6984D7F3) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CC0BB-155D-2292-0522EFDD9954F2CE) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CC0EC-155D-2292-05A3E8C5C5F88E8B) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CC11C-155D-2292-05E840C5D0DCDB59) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CCF27-155D-2292-055AD9DC216B7FE8) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CCF52-155D-2292-0598D81371BC6686) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CCF7D-155D-2292-05E2CD3025D163D5) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CCFA5-155D-2292-055603E678ECA072) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CCFCD-155D-2292-0525FBB21D88F78C) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CD025-155D-2292-05EF10583C25003F) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CD0E8-155D-2292-054CD3CC2B771CEE) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CD112-155D-2292-05D3835227C916B1) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/tracking.cfc \| googleTrackingPixel(UA-901015-1) ] from C:/websites/FamilyClothesLine/functions/tracking.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| prepUrlVar(15-to-20) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| prepUrlVar(25-to-50) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| prepUrlVar(BADEN SPORTS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	2	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| prepUrlVar(WHITE/BROWN) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	3	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| resolveUrlVar(brown) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| resolveUrlVar(oriental-trading,tutu-spirit,magnolia-lane,zeppelin-products,baden-sports,mascot-factory,aurora) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| titlecase(BROWN) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| titlecase(COLLECTIBLES) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| titlecase(ORIENTAL TRADING,TUTU SPIRIT,MAGNOLIA LANE,ZEPPELIN PRODUCTS,BADEN SPORTS,MASCOT FACTORY,AURORA) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| titlecase(oriental trading,tutu spirit,magnolia lane,zeppelin products,baden sports,mascot factory,aurora) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
266 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

session.settings (Datasource=celerantSQL, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\Application.cfm @ 23:59:52.052

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

getQueryStr (Datasource=celerantSQL, Time=16ms, Records=1) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 23:59:52.052

select * from web_category_mappings where url='collectibles' or url='/collectibles'

Getwebdepts (Datasource=celerantSQL, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 23:59:52.052

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

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = COLLECTIBLES

getWebUrl (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 23:59:52.052

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

getWebUrl (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 23:59:52.052

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

GetALLProducts1248 (Datasource=celerantSQL, Time=32ms, Records=2) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 23:59:52.052

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 ltrim(typ)='COLLECTIBLES'
		
                        	and (
                        	
                        		upper(Brand) LIKE 'ORIENTAL%TRADING'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'TUTU%SPIRIT'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'MAGNOLIA%LANE'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'ZEPPELIN%PRODUCTS'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'BADEN%SPORTS'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'MASCOT%FACTORY'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'AURORA'
                            	)
                         and upper(attr1list) like '%BROWN,%' GROUP BY STYLE_ID
		ORDER BY sortposition

results (Datasource=, Time=0ms, Records=2) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 23:59:52.052

SELECT * FROM GetALLProducts1248 ORDER BY
		new desc, picture_id desc

GetALLBrands1248 (Datasource=celerantSQL, Time=16ms, Records=2) in C:\websites\FamilyClothesLine\functions\clientCustomizations.cfc @ 23:59:52.052

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'
		
			and ltrim(typ)='COLLECTIBLES'
		and upper(attr1list) like '%BROWN,%' GROUP BY STYLE_ID

results (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\clientCustomizations.cfc @ 23:59:52.052

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

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=3) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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

checkTaxonomyLevel (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 23:59:52.052

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

getLandingPageSubCats (Datasource=, Time=0ms, Records=0) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 23:59:52.052

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

getCurrentDept (Datasource=celerantSQL, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 23:59:52.052

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

getTaxTree (Datasource=celerantSQL, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 23:59:52.052

select typ, web_url from tb_web_taxonomy where dept='Souvenirs' and typ     <>''  and typ='COLLECTIBLES' and typ<>'EMPTY' and subtyp_1='EMPTY'  order by sort_position desc

getFilterItems (Datasource=, Time=0ms, Records=2) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 23:59:52.052

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

getFilterItems (Datasource=, Time=0ms, Records=2) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 23:59:52.052

select * from temp order by ranking asc

getFilterItems (Datasource=, Time=0ms, Records=0) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 23:59:52.052

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

getTypParent (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 23:59:52.052

SELECT web_url
            FROM application.getWebTaxonomy
            WHERE upper(dept)='SOUVENIRS' and typ = 'EMPTY'

getCurrentDept (Datasource=celerantSQL, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\includes\views\departments.cfm @ 23:59:52.052

select dept, typ, subtyp_1, subtyp_2, subtyp_3 from tb_web_taxonomy where web_url='collectibles' Order By SORT_POSITION ASC

getTaxTree (Datasource=celerantSQL, Time=16ms, Records=0) in C:\websites\FamilyClothesLine\includes\views\departments.cfm @ 23:59:52.052

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

getCurrentDept (Datasource=celerantSQL, Time=15ms, Records=0) in C:\websites\FamilyClothesLine\includes\views\departments.cfm @ 23:59:52.052

SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount 
                FROM web_all_products 
                WHERE dept='SOUVENIRS' and typ='COLLECTIBLES' and upper(subtyp1)<>'EMPTY' 
				and style_id IN (7143,669)
                GROUP BY subtyp1

this.GetFilterQuery (Datasource=, Time=0ms, Records=2) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 23:59:52.052

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

this.GetFilterQuery (Datasource=, Time=0ms, Records=2) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 23:59:52.052

select * from temp order by ranking asc

getColors (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 23:59:52.052

select distinct hexLIST 
        from getproducts 
        group by hexLIST

getSizes (Datasource=, Time=0ms, Records=0) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 23:59:52.052

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

getSizes (Datasource=celerantSQL, Time=0ms, Records=0) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 23:59:52.052

SELECT DISTINCT siz, max(size_order) as size_order
		FROM tb_size_entries
		WHERE upper(siz) IN ('') and upper(siz) <> 'NS' and upper(siz) <> 'N/S'
		GROUP BY siz
		ORDER BY max(size_order), siz

getThis (Datasource=muraDB, Time=15ms, Records=13) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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-24 23:59:52.0' and displaystop>='2024-09-24 23:59:52.0') 
		    ) ORDER BY orderno

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 23:59:52.052

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)

getWebTaxonomy (Datasource=celerantSQL, Time=0ms, Records=448) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 23:59:52.052

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

getDepts (Datasource=celerantSQL, Time=16ms, Records=10) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 23:59:52.052

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

getTyps (Datasource=celerantSQL, Time=0ms, Records=9) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 23:59:52.052

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

getTyps (Datasource=celerantSQL, Time=0ms, Records=8) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 23:59:52.052

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

getTyps (Datasource=celerantSQL, Time=0ms, Records=5) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 23:59:52.052

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

getTyps (Datasource=celerantSQL, Time=0ms, Records=6) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 23:59:52.052

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

getTyps (Datasource=celerantSQL, Time=0ms, Records=3) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 23:59:52.052

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

getTyps (Datasource=celerantSQL, Time=0ms, Records=22) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 23:59:52.052

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

getTyps (Datasource=celerantSQL, Time=15ms, Records=3) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 23:59:52.052

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

getTyps (Datasource=celerantSQL, Time=0ms, Records=5) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 23:59:52.052

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

getTyps (Datasource=celerantSQL, Time=0ms, Records=23) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 23:59:52.052

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

getTyps (Datasource=celerantSQL, Time=0ms, Records=5) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 23:59:52.052

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

Scope Variables

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=CFTOKEN=bec9d6b6fe985cc3-8957C08D-B9F2-E922-9B1AF0D0B613FEEC; CFID=42751; CFID=42751; CFGLOBALS=urltoken%3DCFID%23%3D42751%26CFTOKEN%23%3Dbec9d6b6fe985cc3%2D8957C08D%2DB9F2%2DE922%2D9B1AF0D0B613FEEC%23lastvisit%3D%7Bts%20%272024%2D09%2D24%2023%3A59%3A47%27%7D%23hitcount%3D4%23timecreated%3D%7Bts%20%272024%2D09%2D24%2023%3A59%3A37%27%7D%23cftoken%3Dbec9d6b6fe985cc3%2D8957C08D%2DB9F2%2DE922%2D9B1AF0D0B613FEEC%23cfid%3D42751%23; __cflb=02DiuH7CwonCo2wcgBjAszNcmNicJwt5tmmqSZ2jUixWY; CFTOKEN=bec9d6b6fe985cc3-8957C08D-B9F2-E922-9B1AF0D0B613FEEC
HTTP_HOST=www.pennstateclothes.com
HTTP_REFERER=
HTTP_URL=/category.cfm?mapping=collectibles/browse/brand/oriental-trading,tutu-spirit,magnolia-lane,zeppelin-products,baden-sports,mascot-factory,aurora/color/brown
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=collectibles/browse/brand/oriental-trading,tutu-spirit,magnolia-lane,zeppelin-products,baden-sports,mascot-factory,aurora/color/brown
REMOTE_ADDR=172.71.255.30
REMOTE_HOST=172.71.255.30
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=42751
cftoken=bec9d6b6fe985cc3-8957C08D-B9F2-E922-9B1AF0D0B613FEEC
hitcount=4
lastvisit={ts '2024-09-24 23:59:47'}
timecreated={ts '2024-09-24 23:59:37'}
urltoken=CFID=42751&CFTOKEN=bec9d6b6fe985cc3-8957C08D-B9F2-E922-9B1AF0D0B613FEEC

Cookie Variables:
CFGLOBALS=urltoken=CFID#=42751&CFTOKEN#=bec9d6b6fe985cc3-8957C08D-B9F2-E922-9B1AF0D0B613FEEC#lastvisit={ts '2024-09-24 23:59:47'}#hitcount=4#timecreated={ts '2024-09-24 23:59:37'}#cftoken=bec9d6b6fe985cc3-8957C08D-B9F2-E922-9B1AF0D0B613FEEC#cfid=42751#
CFID=42751
CFTOKEN=bec9d6b6fe985cc3-8957C08D-B9F2-E922-9B1AF0D0B613FEEC
__cflb=02DiuH7CwonCo2wcgBjAszNcmNicJwt5tmmqSZ2jUixWY

Form Fields:
KWORD=

Session Variables:
cartstatus=NEW
cfid=42751
cftoken=bec9d6b6fe985cc3-8957C08D-B9F2-E922-9B1AF0D0B613FEEC
checkout=Struct (4)
couponreset=NO
cs=https://www.pennstateclothes.com/collectibles/browse/brand/oriental-trading,tutu-spirit,magnolia-lane,zeppelin-products,baden-sports,mascot-factory,aurora/color/brown
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/collectibles/browse/brand/oriental-trading,tutu-spirit,magnolia-lane,zeppelin-products,baden-sports,mascot-factory,aurora/color/brown
password=
phone=
pickupstore=1
qualifyingpromoitems=0
sessionid=PENNSTATECLOTHESRESPONSIVE5_42751_bec9d6b6fe985cc3-8957C08D-B9F2-E922-9B1AF0D0B613FEEC
settings=Query (1)
shipmethodlist=0,1
urltoken=CFID=42751&CFTOKEN=bec9d6b6fe985cc3-8957C08D-B9F2-E922-9B1AF0D0B613FEEC
username=
website=Struct (1)

URL Parameters:
mapping=collectibles/browse/brand/oriental-trading,tutu-spirit,magnolia-lane,zeppelin-products,baden-sports,mascot-factory,aurora/color/brown

Debug Rendering Time: 31 ms

home > souvenirs > collectibles > oriental trading, tutu spirit, magnolia lane, zeppelin products, baden sports, mascot factory, aurora

Penn State Collectibles