Filters

Type

Shorts

Penn State Clothing for Women

Support the Nittany Lions and look good while doing it! Find your perfect fit in our wide selection of Penn State women's clothing.

Sort By

Items per page:

Now Viewing 1 -1 of 1 Items

THE FAMILY CLOTHESLINE Penn State Women's Soffe Authentic Shorts $19.99

Sort By

Items per page:

Now Viewing 1 -1 of 1 Items

Debugging Information

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

Execution Time

Total Time	Avg Time	Count	Template
266 ms	266 ms	1	C:/websites/FamilyClothesLine/category.cfm
110 ms	110 ms	1	C:/websites/FamilyClothesLine/includes/footer.cfm
46 ms	46 ms	1	C:/websites/FamilyClothesLine/includes/sidenav.cfm
31 ms	31 ms	1	C:/websites/FamilyClothesLine/includes/views/departments.cfm
31 ms	31 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc \| getALLBrandsFromOverallQuery([complex value]) ] from C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc
16 ms	16 ms	1	C:/websites/FamilyClothesLine/Application.cfm
16 ms	16 ms	1	C:/websites/FamilyClothesLine/includes/header.cfm
16 ms	16 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(17B6794D-155D-2292-057225F49C7C6629) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
16 ms	16 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CB7F4-155D-2292-054C1ED3FABCF731) ] from C:/websites/FamilyClothesLine/functions/cms.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
16 ms	16 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc \| getContentById(9D8CD112-155D-2292-05D3835227C916B1) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
16 ms	16 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	C:/websites/FamilyClothesLine/includes/views/thumbnails.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(1, 1, 32, 5, https://www.pennstateclothes.com/womens/browse/brand/press-box,nike,lululemon,the-family-clothesline/size/s/color/oxford-grey, [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(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(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/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(CHAMPION) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	5	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| prepUrlVar(DUMMYSIZE) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	2	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| prepUrlVar(HEATHER GREY) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| prepUrlVar(L) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	2	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| prepUrlVar(LIGHT BLUE) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| prepUrlVar(M) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	2	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| prepUrlVar(NAVY) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	2	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| prepUrlVar(OXFORD GREY) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	2	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| prepUrlVar(PINK) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| prepUrlVar(S) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| prepUrlVar(THE FAMILY CLOTHESLINE) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| prepUrlVar(XL) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| prepUrlVar(XS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	3	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| resolveUrlVar(oxford-grey) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| resolveUrlVar(press-box,nike,lululemon,the-family-clothesline) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	3	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| resolveUrlVar(s) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| titleCase(SHORTS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| titlecase(OXFORD GREY) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| titlecase(PRESS BOX,NIKE,LULULEMON,THE FAMILY CLOTHESLINE) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| titlecase(S) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc \| titlecase(press box,nike,lululemon,the family clothesline) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
282 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

session.settings (Datasource=celerantSQL, Time=16ms, Records=1) in C:\websites\FamilyClothesLine\Application.cfm @ 06:03:25.025

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

getHeaders (Datasource=celerantSQL, Time=0ms, Records=0) in C:\websites\FamilyClothesLine\Application.cfm @ 06:03:25.025

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

getQueryStr (Datasource=celerantSQL, Time=16ms, Records=1) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 06:03:25.025

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

Getwebdepts (Datasource=celerantSQL, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 06:03:25.025

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

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = WOMENS

getWebUrl (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 06:03:25.025

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

myCatVars.subCategories (Datasource=, Time=0ms, Records=8) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 06:03:25.025

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

GetALLProducts1003 (Datasource=celerantSQL, Time=31ms, Records=1) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 06:03:25.025

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)='Womens'
		
                        	and (
                        	
                        		upper(Brand) LIKE 'PRESS%BOX'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'NIKE'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'LULULEMON'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'THE%FAMILY%CLOTHESLINE'
                            	)
                         and upper(Sizelist) like '%S,%' and upper(attr1list) like '%OXFORD GREY,%' GROUP BY STYLE_ID
		ORDER BY sortposition

results (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 06:03:25.025

SELECT * FROM GetALLProducts1003 ORDER BY
		new desc, picture_id desc

GetALLBrands1003 (Datasource=celerantSQL, Time=31ms, Records=3) in C:\websites\FamilyClothesLine\functions\clientCustomizations.cfc @ 06:03:25.025

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)='Womens'
		and upper(Sizelist) like '%S,%' and upper(attr1list) like '%OXFORD GREY,%' GROUP BY STYLE_ID

results (Datasource=, Time=0ms, Records=2) in C:\websites\FamilyClothesLine\functions\clientCustomizations.cfc @ 06:03:25.025

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

getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 06:03:25.025

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 @ 06:03:25.025

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=16ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 06:03:25.025

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 @ 06:03:25.025

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 @ 06:03:25.025

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 @ 06:03:25.025

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

getLandingPageSubCats (Datasource=, Time=0ms, Records=8) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 06:03:26.026

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

getCurrentDept (Datasource=celerantSQL, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 06:03:26.026

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

getFilterItems (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 06:03:26.026

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=1) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 06:03:26.026

select * from temp order by ranking asc

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

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

getTaxTree (Datasource=celerantSQL, Time=0ms, Records=10) in C:\websites\FamilyClothesLine\includes\views\departments.cfm @ 06:03:26.026

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

getDeptUrl (Datasource=celerantSQL, Time=15ms, Records=1) in C:\websites\FamilyClothesLine\includes\views\departments.cfm @ 06:03:26.026

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

getCurrentDept (Datasource=celerantSQL, Time=16ms, Records=1) in C:\websites\FamilyClothesLine\includes\views\departments.cfm @ 06:03:26.026

SELECT DISTINCT typ, count(distinct style_id) as itemCount 
                FROM web_all_products 
                WHERE dept='WOMENS' and upper(typ)<>'EMPTY' and style_id IN (9728)  
                GROUP BY typ

this.GetFilterQuery (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 06:03:26.026

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=1) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 06:03:26.026

select * from temp order by ranking asc

getColors (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 06:03:26.026

select distinct hexLIST 
        from getproducts 
        group by hexLIST

getSizes (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 06:03:26.026

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

getSizes (Datasource=celerantSQL, Time=0ms, Records=5) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 06:03:26.026

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

getThis (Datasource=muraDB, Time=16ms, Records=13) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 06:03:26.026

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 06:03:26.0' and displaystop>='2024-09-25 06:03:26.0') 
		    ) ORDER BY orderno

getThis (Datasource=muraDB, Time=16ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 06:03:26.026

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)