Jardine Gifts Penn State Souvenirs & Gifts

home > souvenirs > sds design, jardine eyewear, jardine gifts, megan elmer, sporticulture, yeti

Filters  

Type

Penn State Souvenirs & Gift Items

True Nittany Lion fans love to display their PSU pride at all times! Show off your Penn State loyalty with our selection of Penn State gifts and souvenirs.

Sort By
Items per page:

Now Viewing 1 -14 of 14 Items

Sort By
Items per page:

Now Viewing 1 -14 of 14 Items


Officially Licensed Penn State Clothing, Apparel and Merchandise

Need help? Call us 888-237-1946

Returns Gift Cards Customer Service Need Help? Call Us 888-237-1946
0 Sign In

Debugging Information
ColdFusion Server Standard 2021,0,16,330307
Template /category.cfm
Time Stamp 24-Sep-24 04:21 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.69.58.154
Host Name 172.69.58.154

Execution Time

Total Time Avg Time Count Template
235 ms 235 ms 1 top level C:\websites\FamilyClothesLine\category.cfm
79 ms 79 ms 1 C:/websites/FamilyClothesLine/includes/footer.cfm
62 ms 62 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/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(9D8CB957-155D-2292-058B97FF271F2C79) ] 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 | getPagesByTag(homepage, 9D8C4EC2-155D-2292-0553F4E061215B96, 20) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
15 ms 15 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc | getALLBrandsFromOverallQuery([complex value]) ] from C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc
0 ms 0 ms 1 C:/websites/FamilyClothesLine/Application.cfm
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 14 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(14, 1, 32, 5, https://www.pennstateclothes.com/souvenirs/browse/price/20-to-25/brand/sds-design,jardine-eyewear,jardine-gifts,megan-elmer,sporticulture,yeti, [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(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(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(AHEAD) ] 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(BLACK) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 2 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(CLEAR) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(CREATIVE KNITWEAR) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(EAGLES WINGS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(FRANKLIN SPORTS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(GAMEDAY IRONWORKS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(GAMETIME SIDEKICKS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 2 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(GOLD) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(HANNAS HANDIWORKS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(JARDINE GIFTS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(JENKINS GAME DAY) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(LOGO INC) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(LOKAI) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(MAGNOLIA LANE) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(MASCOT FACTORY) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(MASTERPIECES PUZZLE CO.) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 2 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(MIRROR) ] 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(NAVY/WHITE) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(NEIL ENTERPRISES) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(NORDIC COMPANY) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(PETS FIRST) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(PURA VIDA) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(R.F.S.J. INC.) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 2 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(SILVER) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(SISKIYOU) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(SPORTICULTURE) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(SPORTULA) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(STENCIL U) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(STONE ARMORY) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(STORM DUDS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(TEAM GOLF) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(VICTORY TAILGATE) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 2 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(WHITE) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(ZEPPELIN PRODUCTS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | resolveUrlVar(20-to-25) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | resolveUrlVar(sds-design,jardine-eyewear,jardine-gifts,megan-elmer,sporticulture,yeti) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | titleCase(BAGS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | titleCase(CAR ACCESSORIES) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | titleCase(DRINKWARE) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | titleCase(JEWELRY & TATTOOS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | titleCase(TAILGATING SUPPLIES) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | titleCase(TRAVEL ACCESSORIES) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | titlecase(20 TO 25) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | titlecase(SDS DESIGN,JARDINE EYEWEAR,JARDINE GIFTS,MEGAN ELMER,SPORTICULTURE,YETI) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | titlecase(sds design,jardine eyewear,jardine gifts,megan elmer,sporticulture,yeti) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
16 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
251 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 @ 16:21:07.007
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 @ 16:21:07.007
select * from web_category_mappings where url='souvenirs' or url='/souvenirs'
Getwebdepts (Datasource=celerantSQL, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 16:21:07.007
select * from tb_web_taxonomy where upper(web_url)=?  and sort_position<>'NO'
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = SOUVENIRS

getWebUrl (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 16:21:07.007
select web_url from application.getWebTaxonomy where upper(dept)='SOUVENIRS' and typ='EMPTY'
myCatVars.subCategories (Datasource=, Time=0ms, Records=23) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 16:21:07.007
select * from application.getWebTaxonomy where dept='Souvenirs' and typ<>'EMPTY' and subtyp_1='EMPTY' and sort_position<>'NO' order by sort_position desc
GetALLProducts1010 (Datasource=celerantSQL, Time=47ms, Records=14) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 16:21:07.007
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(pricerange)='20-to-25'
					
                        	and (
                        	
                        		upper(Brand) LIKE 'SDS%DESIGN'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'JARDINE%EYEWEAR'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'JARDINE%GIFTS'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'MEGAN%ELMER'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'SPORTICULTURE'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'YETI'
                            	)
                         GROUP BY STYLE_ID
		ORDER BY sortposition
results (Datasource=, Time=0ms, Records=14) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 16:21:07.007
SELECT * FROM GetALLProducts1010 ORDER BY
		new desc, picture_id desc
GetALLBrands1010 (Datasource=celerantSQL, Time=15ms, Records=79) in C:\websites\FamilyClothesLine\functions\clientCustomizations.cfc @ 16:21:07.007
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 (upper(pricerange)='20-to-25')
					GROUP BY STYLE_ID
results (Datasource=, Time=0ms, Records=29) in C:\websites\FamilyClothesLine\functions\clientCustomizations.cfc @ 16:21:07.007
SELECT Upper(brand) as brand,branddisplay, count(distinct
              
                style_id
              
              ) as itemCount 
              FROM GetALLBrands1010
              WHERE Brand>''
              GROUP BY brand,branddisplay 
              order by brand asc
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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
getLandingPageSubCats (Datasource=, Time=0ms, Records=23) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 16:21:07.007
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
getCurrentDept (Datasource=celerantSQL, Time=16ms, Records=1) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 16:21:07.007
select dept, typ, subtyp_1, subtyp_2, subtyp_3 from tb_web_taxonomy where web_url='souvenirs'
getFilterItems (Datasource=, Time=0ms, Records=0) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 16:21:07.007
select distinct
        
          sizeList
          
        from getproducts where
        
          sizeList
          
        >'' group by  
        
          sizeList
getFilterItems (Datasource=, Time=0ms, Records=8) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 16:21:07.007
select distinct
        
          attr1List
        
        from getproducts where
        
          attr1List
        
        >'' group by  
        
          attr1List
getCurrentDept (Datasource=celerantSQL, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\includes\views\departments.cfm @ 16:21:07.007
select dept, typ, subtyp_1, subtyp_2, subtyp_3 from tb_web_taxonomy where web_url='souvenirs' Order By SORT_POSITION ASC
getTaxTree (Datasource=celerantSQL, Time=0ms, Records=23) in C:\websites\FamilyClothesLine\includes\views\departments.cfm @ 16:21:07.007
SELECT typ, web_url 
                FROM tb_web_taxonomy 
                WHERE dept='Souvenirs' and typ>'' and subtyp_1='EMPTY' and typ<>'EMPTY' 				
                ORDER BY sort_position
getDeptUrl (Datasource=celerantSQL, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\includes\views\departments.cfm @ 16:21:07.007
SELECT  web_url 
                FROM tb_web_taxonomy 
                WHERE dept='Souvenirs' and typ = 'EMPTY' 				
                ORDER BY sort_position
getCurrentDept (Datasource=celerantSQL, Time=31ms, Records=6) in C:\websites\FamilyClothesLine\includes\views\departments.cfm @ 16:21:07.007
SELECT DISTINCT typ, count(distinct style_id) as itemCount 
                FROM web_all_products 
                WHERE dept='SOUVENIRS' and upper(typ)<>'EMPTY' and style_id IN (12523,12394,12255,12254,12256,12257,12025,11459,10504,11295,11204,10503,9603,8746)  
                GROUP BY typ
this.GetFilterQuery (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 16:21:07.007
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 @ 16:21:07.007
select * from temp order by ranking asc
getColors (Datasource=, Time=0ms, Records=8) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 16:21:07.007
select distinct hexLIST 
        from getproducts 
        group by hexLIST
getSizes (Datasource=, Time=0ms, Records=0) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 16:21:07.007
select distinct sizeList 
	from GETPRODUCTS 
	where sizeList <>''  
	group by sizeList
getSizes (Datasource=celerantSQL, Time=0ms, Records=0) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 16:21:07.007
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=16ms, Records=13) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 16:21:07.007
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 16:21:07.0' and displaystop>='2024-09-24 16:21:07.0') 
		    ) ORDER BY orderno
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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=16ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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=16ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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=15ms, Records=10) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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=16ms, Records=3) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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 @ 16:21:07.007
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=675cf1bd85c55fef-78F15BC4-AE9A-DAE7-7DB4A7C07199DDE8; CFGLOBALS=urltoken%3DCFID%23%3D15013%26CFTOKEN%23%3D675cf1bd85c55fef%2D78F15BC4%2DAE9A%2DDAE7%2D7DB4A7C07199DDE8%23lastvisit%3D%7Bts%20%272024%2D09%2D24%2016%3A21%3A02%27%7D%23hitcount%3D2%23timecreated%3D%7Bts%20%272024%2D09%2D24%2016%3A21%3A02%27%7D%23cftoken%3D675cf1bd85c55fef%2D78F15BC4%2DAE9A%2DDAE7%2D7DB4A7C07199DDE8%23cfid%3D15013%23; CFID=15013; __cflb=02DiuH7CwonCo2wcgBjAszNcmNicJwt5tqanijTLDeNd2; CFTOKEN=675cf1bd85c55fef-78F15BC4-AE9A-DAE7-7DB4A7C07199DDE8; CFID=15013
HTTP_HOST=www.pennstateclothes.com
HTTP_REFERER=
HTTP_URL=/category.cfm?mapping=souvenirs/browse/brand/sds-design,jardine-eyewear,jardine-gifts,megan-elmer,sporticulture,yeti/price/20-to-25
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=souvenirs/browse/brand/sds-design,jardine-eyewear,jardine-gifts,megan-elmer,sporticulture,yeti/price/20-to-25
REMOTE_ADDR=172.69.58.154
REMOTE_HOST=172.69.58.154
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=15013
cftoken=675cf1bd85c55fef-78F15BC4-AE9A-DAE7-7DB4A7C07199DDE8
hitcount=2
lastvisit={ts '2024-09-24 16:21:02'}
timecreated={ts '2024-09-24 16:21:02'}
urltoken=CFID=15013&CFTOKEN=675cf1bd85c55fef-78F15BC4-AE9A-DAE7-7DB4A7C07199DDE8

Cookie Variables:
CFGLOBALS=urltoken=CFID#=15013&CFTOKEN#=675cf1bd85c55fef-78F15BC4-AE9A-DAE7-7DB4A7C07199DDE8#lastvisit={ts '2024-09-24 16:21:02'}#hitcount=2#timecreated={ts '2024-09-24 16:21:02'}#cftoken=675cf1bd85c55fef-78F15BC4-AE9A-DAE7-7DB4A7C07199DDE8#cfid=15013#
CFID=15013
CFTOKEN=675cf1bd85c55fef-78F15BC4-AE9A-DAE7-7DB4A7C07199DDE8
__cflb=02DiuH7CwonCo2wcgBjAszNcmNicJwt5tqanijTLDeNd2

Form Fields:
KWORD=

Session Variables:
cartstatus=NEW
cfid=15013
cftoken=675cf1bd85c55fef-78F15BC4-AE9A-DAE7-7DB4A7C07199DDE8
checkout=Struct (4)
couponreset=NO
cs=https://www.pennstateclothes.com/souvenirs/browse/price/20-to-25/brand/sds-design,jardine-eyewear,jardine-gifts,megan-elmer,sporticulture,yeti
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/price/20-to-25/brand/sds-design,jardine-eyewear,jardine-gifts,megan-elmer,sporticulture,yeti
password=
phone=
pickupstore=1
qualifyingpromoitems=0
sessionid=PENNSTATECLOTHESRESPONSIVE5_15013_675cf1bd85c55fef-78F15BC4-AE9A-DAE7-7DB4A7C07199DDE8
settings=Query (1)
shipmethodlist=0,1
urltoken=CFID=15013&CFTOKEN=675cf1bd85c55fef-78F15BC4-AE9A-DAE7-7DB4A7C07199DDE8
username=
website=Struct (1)

URL Parameters:
mapping=souvenirs/browse/brand/sds-design,jardine-eyewear,jardine-gifts,megan-elmer,sporticulture,yeti/price/20-to-25
Debug Rendering Time: 31 ms