Magnolia Lane Penn State Tailgate Supplies

home > souvenirs > tailgating supplies > gift card, great american, alex ani, authentic street signs, islide, masterpieces puzzle co_, magnolia lane

Filters  

Type

Penn State Tailgate Supplies

Everyone knows the home of tailgating is State College, and it's crucial to own the proper Penn State tailgate supplies for football season. Find fold-up chairs, grilling accessories and much more in stock for the biggest games of the season!

Sort By
Items per page:

Now Viewing 1 -12 of 12 Items

Sort By
Items per page:

Now Viewing 1 -12 of 12 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 25-Sep-24 11:23 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.70.131.96
Host Name 172.70.131.96

Execution Time

Total Time Avg Time Count Template
250 ms 250 ms 1 top level C:\websites\FamilyClothesLine\category.cfm
110 ms 110 ms 1 C:/websites/FamilyClothesLine/includes/footer.cfm
62 ms 62 ms 1 C:/websites/FamilyClothesLine/includes/sidenav.cfm
47 ms 47 ms 1 C:/websites/FamilyClothesLine/includes/views/departments.cfm
16 ms 16 ms 1 C:/websites/FamilyClothesLine/Application.cfm
16 ms 16 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc | createLowerPagination(12, 1, 32, 5, https://www.pennstateclothes.com/tailgating-supplies/browse/brand/gift-card,great-american,alex-ani,authentic-street-signs,islide,masterpieces-puzzle-co_,magnolia-lane, [complex value], [complex value]) ] from C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc
16 ms 16 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8C4D64-155D-2292-057BD50838A99E44) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
16 ms 16 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CC0EC-155D-2292-05A3E8C5C5F88E8B) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
16 ms 16 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CCFCD-155D-2292-0525FBB21D88F78C) ] 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
16 ms 16 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | titleCase(FOOD ACCESSORIES) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
15 ms 15 ms 1 C:/websites/FamilyClothesLine/includes/header.cfm
15 ms 15 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(183DF292-155D-2292-05CD90B735988F90) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
15 ms 15 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 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 12 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 | getALLBrandsFromOverallQuery([complex value]) ] from C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/clientCustomizations.cfc | seoTagGenerator(false, , [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(6DB63DB6-155D-2292-055A9BC44BA8A9E1) ] 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(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(9D8CD025-155D-2292-05EF10583C25003F) ] from C:/websites/FamilyClothesLine/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/cms.cfc | getContentById(9D8CD0BD-155D-2292-054CCD5667F7D9EA) ] 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(20-to-25) ] 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(ALL SPORTS FANATICS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(CAPRI DESIGNS) ] 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(DIVINE CREATIONS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(DOONEY & BOURKE) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(EPIC SPORTS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(HOTHANDS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(IMPERIAL) ] 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(KWIK-COVERS) ] 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(LULULEMON) ] 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 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(MAYFLOWER) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(MV SPORT) ] 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(PICNIC TIME) ] 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(STORM DUDS) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(TEAM SPORTS AMERICA) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(UNIVERSITY BLANKET) ] 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/NAVY) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | prepUrlVar(YETI) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | resolveUrlVar(gift-card,great-american,alex-ani,authentic-street-signs,islide,masterpieces-puzzle-co_,magnolia-lane) ] from C:/websites/FamilyClothesLine/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/FamilyClothesLine/functions/utilities.cfc | titlecase(GIFT CARD,GREAT AMERICAN,ALEX ANI,AUTHENTIC STREET SIGNS,ISLIDE,MASTERPIECES PUZZLE CO.,MAGNOLIA LANE) ] 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(gift card,great american,alex ani,authentic street signs,islide,masterpieces puzzle co_,magnolia lane) ] 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 @ 11:23:18.018
SELECT * from web_settings with (nolock) WHERE web_settings_id = 1
getHeaders (Datasource=celerantSQL, Time=16ms, Records=0) in C:\websites\FamilyClothesLine\Application.cfm @ 11:23:18.018
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=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 11:23:18.018
select * from web_category_mappings where url='tailgating-supplies' or url='/tailgating-supplies'
Getwebdepts (Datasource=celerantSQL, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 11:23:18.018
select * from tb_web_taxonomy where upper(web_url)=?  and sort_position<>'NO'
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = TAILGATING-SUPPLIES

getWebUrl (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 11:23:18.018
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 @ 11:23:18.018
select web_url from application.getWebTaxonomy where upper(dept)='SOUVENIRS' and upper(typ)='TAILGATING SUPPLIES' and subtyp_1='EMPTY'
GetALLProducts1326 (Datasource=celerantSQL, Time=32ms, Records=12) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 11:23:18.018
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)='TAILGATING SUPPLIES'
		
                        	and (
                        	
                        		upper(Brand) LIKE 'GIFT%CARD'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'GREAT%AMERICAN'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'ALEX%ANI'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'AUTHENTIC%STREET%SIGNS'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'ISLIDE'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'MASTERPIECES%PUZZLE%CO_'
                            	
                            		or 
                            	
                        		upper(Brand) LIKE 'MAGNOLIA%LANE'
                            	)
                         GROUP BY STYLE_ID
		ORDER BY sortposition
results (Datasource=, Time=0ms, Records=12) in C:\websites\FamilyClothesLine\functions\categoryfunctions.cfm @ 11:23:18.018
SELECT * FROM GetALLProducts1326 ORDER BY
		new desc, picture_id desc
GetALLBrands1326 (Datasource=celerantSQL, Time=0ms, Records=128, Cached Query) in C:\websites\FamilyClothesLine\functions\clientCustomizations.cfc @ 11:23:18.018
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)='TAILGATING SUPPLIES'
		GROUP BY STYLE_ID
results (Datasource=, Time=0ms, Records=27) in C:\websites\FamilyClothesLine\functions\clientCustomizations.cfc @ 11:23:18.018
SELECT Upper(brand) as brand,branddisplay, count(distinct
              
                style_id
              
              ) as itemCount 
              FROM GetALLBrands1326
              WHERE Brand>''
              GROUP BY brand,branddisplay 
              order by brand asc
getThis (Datasource=muraDB, Time=15ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 11:23:18.018
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 @ 11:23:18.018
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 @ 11:23:18.018
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 @ 11:23:18.018
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 @ 11:23:18.018
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 @ 11:23:18.018
select dept, typ, subtyp_1, subtyp_2, subtyp_3,category_style from application.getWebTaxonomy where 
		
		dept='Souvenirs' and typ='TAILGATING SUPPLIES' 
		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 @ 11:23:18.018
select dept, typ, subtyp_1, subtyp_2, subtyp_3, active, web_url, category_style from application.getWebTaxonomy where 
			
			
					dept='Souvenirs'
					and typ='TAILGATING SUPPLIES'
					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 @ 11:23:18.018
select dept, typ, subtyp_1, subtyp_2, subtyp_3 from tb_web_taxonomy where web_url='tailgating-supplies'
getTaxTree (Datasource=celerantSQL, Time=0ms, Records=1, Cached Query) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 11:23:18.018
select typ, web_url from tb_web_taxonomy where dept='Souvenirs' and typ     <>''  and typ='TAILGATING SUPPLIES' and typ<>'EMPTY' and subtyp_1='EMPTY'  order by sort_position desc
getFilterItems (Datasource=, Time=0ms, Records=3) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 11:23:18.018
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=3) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 11:23:18.018
select * from temp order by ranking asc
getFilterItems (Datasource=, Time=0ms, Records=0) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 11:23:18.018
select distinct
        
          sizeList
          
        from getproducts where
        
          sizeList
          
        >'' group by  
        
          sizeList
getFilterItems (Datasource=, Time=0ms, Records=3) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 11:23:18.018
select distinct
        
          attr1List
        
        from getproducts where
        
          attr1List
        
        >'' group by  
        
          attr1List
getTypParent (Datasource=, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 11:23:18.018
SELECT web_url
            FROM application.getWebTaxonomy
            WHERE upper(dept)='SOUVENIRS' and typ = 'EMPTY'
getCurrentDept (Datasource=celerantSQL, Time=16ms, Records=1) in C:\websites\FamilyClothesLine\includes\views\departments.cfm @ 11:23:18.018
select dept, typ, subtyp_1, subtyp_2, subtyp_3 from tb_web_taxonomy where web_url='tailgating-supplies' Order By SORT_POSITION ASC
getTaxTree (Datasource=celerantSQL, Time=0ms, Records=8) in C:\websites\FamilyClothesLine\includes\views\departments.cfm @ 11:23:18.018
SELECT subtyp_1, web_url 
                FROM tb_web_taxonomy 
                WHERE dept='SOUVENIRS' and typ='TAILGATING SUPPLIES' and subtyp_1>'' and subtyp_2='EMPTY' and subtyp_1<>'EMPTY' 
                ORDER BY sort_position
getCurrentDept (Datasource=celerantSQL, Time=15ms, Records=1) in C:\websites\FamilyClothesLine\includes\views\departments.cfm @ 11:23:18.018
SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount 
                FROM web_all_products 
                WHERE dept='SOUVENIRS' and typ='TAILGATING SUPPLIES' and upper(subtyp1)<>'EMPTY' 
				and style_id IN (11955,11954,11603,9142,9143,9144,8911,8269,8293,7273,7272,7005)
                GROUP BY subtyp1
this.GetFilterQuery (Datasource=, Time=0ms, Records=3) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 11:23:18.018
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=3) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 11:23:18.018
select * from temp order by ranking asc
getColors (Datasource=, Time=0ms, Records=3) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 11:23:18.018
select distinct hexLIST 
        from getproducts 
        group by hexLIST
getSizes (Datasource=, Time=0ms, Records=0) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 11:23:18.018
select distinct sizeList 
	from GETPRODUCTS 
	where sizeList <>''  
	group by sizeList
getSizes (Datasource=celerantSQL, Time=15ms, Records=0) in C:\websites\FamilyClothesLine\includes\sidenav.cfm @ 11:23:18.018
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 @ 11:23:18.018
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 11:23:18.0' and displaystop>='2024-09-25 11:23:18.0') 
		    ) ORDER BY orderno
getThis (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 11:23:18.018
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 @ 11:23:18.018
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 @ 11:23:18.018
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 @ 11:23:18.018
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=16ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 11:23:18.018
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 @ 11:23:18.018
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 @ 11:23:18.018
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 @ 11:23:18.018
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 @ 11:23:18.018
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 @ 11:23:18.018
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 @ 11:23:18.018
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 @ 11:23:18.018
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 @ 11:23:18.018
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 @ 11:23:18.018
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 @ 11:23:18.018
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=15ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 11:23:19.019
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 @ 11:23:19.019
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 @ 11:23:19.019
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 @ 11:23:19.019
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=16ms, Records=1) in C:\websites\FamilyClothesLine\functions\cms.cfc @ 11:23:19.019
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 @ 11:23:19.019
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=0ms, Records=10) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 11:23:19.019
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 @ 11:23:19.019
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 @ 11:23:19.019
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 @ 11:23:19.019
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 @ 11:23:19.019
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 @ 11:23:19.019
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 @ 11:23:19.019
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=0ms, Records=3) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 11:23:19.019
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 @ 11:23:19.019
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=16ms, Records=23) in C:\websites\FamilyClothesLine\includes\footer.cfm @ 11:23:19.019
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 @ 11:23:19.019
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=fikker-61vm-nk2N=MgPGRI6oXLV7DSLWJk4y6wNi63F1ZE0E
HTTP_HOST=www.pennstateclothes.com
HTTP_REFERER=https://pennstateclothes.com/tailgating-supplies/browse/brand/gift-card,great-american,alex-ani,authentic-street-signs,islide,masterpieces-puzzle-co_,magnolia-lane
HTTP_URL=/category.cfm?mapping=tailgating-supplies/browse/brand/gift-card,great-american,alex-ani,authentic-street-signs,islide,masterpieces-puzzle-co_,magnolia-lane
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=tailgating-supplies/browse/brand/gift-card,great-american,alex-ani,authentic-street-signs,islide,masterpieces-puzzle-co_,magnolia-lane
REMOTE_ADDR=172.70.131.96
REMOTE_HOST=172.70.131.96
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=71683
cftoken=73337a2afb565533-A1CB1079-AB49-2A7C-217572680EA58F8F
hitcount=1
lastvisit={ts '2024-09-25 11:23:18'}
timecreated={ts '2024-09-25 11:23:18'}
urltoken=CFID=71683&CFTOKEN=73337a2afb565533-A1CB1079-AB49-2A7C-217572680EA58F8F

Cookie Variables:
CFID=71683
CFTOKEN=73337a2afb565533-A1CB1079-AB49-2A7C-217572680EA58F8F
fikker-61vm-nk2N=MgPGRI6oXLV7DSLWJk4y6wNi63F1ZE0E

Form Fields:
KWORD=

Session Variables:
cartstatus=NEW
cfid=71683
cftoken=73337a2afb565533-A1CB1079-AB49-2A7C-217572680EA58F8F
checkout=Struct (4)
couponreset=NO
cs=https://www.pennstateclothes.com/tailgating-supplies/browse/brand/gift-card,great-american,alex-ani,authentic-street-signs,islide,masterpieces-puzzle-co_,magnolia-lane
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/tailgating-supplies/browse/brand/gift-card,great-american,alex-ani,authentic-street-signs,islide,masterpieces-puzzle-co_,magnolia-lane
password=
phone=
pickupstore=1
qualifyingpromoitems=0
sessionid=PENNSTATECLOTHESRESPONSIVE5_71683_73337a2afb565533-A1CB1079-AB49-2A7C-217572680EA58F8F
settings=Query (1)
shipmethodlist=0,1
urltoken=CFID=71683&CFTOKEN=73337a2afb565533-A1CB1079-AB49-2A7C-217572680EA58F8F
username=
website=Struct (1)

URL Parameters:
mapping=tailgating-supplies/browse/brand/gift-card,great-american,alex-ani,authentic-street-signs,islide,masterpieces-puzzle-co_,magnolia-lane
Debug Rendering Time: 16 ms