Penn State Merchandise Store - Nittany Lions Clothing, Gifts, Jerseys, Hats, Apparel

Featured Penn State Gear

query

RESULTSET

query
	ALTERNATETEAM	ATTR1LIST	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	ISFEATUREDITEM	LARGEPICTURE	LEAGUE	LISTPRICE	MEDIUMPICTURE	NAME	NEW	OVERALLQOH	PRICERANGE	PRODREVIEWSAVERAGE	PRODUCTAGE	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SIZELIST	SMALLPICTURE	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TEAM	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TYP	URL	WEIGHT
1	[empty string]	DARK GRAY,DUMMYCOLOR	LIONS PRIDE	Lions Pride	SPORTSWEAR	SPORTSWEAR &GT; T-SHIRTS &GT; SHORT SLEEVE &GT; SPORT TEES	20	0	20	YES	13635-DEFAULT-l.jpg	[empty string]	20	13635-DEFAULT-m.jpg	Dominate The State Tee	Y	365	15-to-20	0.00	0	[empty string]	Dominate the State Tee	<FONT SIZE="+1"><B>Dominate the State T-Shirt</B></FONT><UL><LI>"We are going to dominate the state," said Coach James Franklin about recruiting at his introductory PSU press conference.</LI>Get your Dominate the State - We Are Penn State Football tee now<LI>Hanes Beefy Tee</LI><LI>90% cotton 10% polyester blend t-shirt</LI><LI>Screen printed 2 color logo on the front chest</LI><LI>Small Lions Pride lion face logo on the left sleeve</LI></UL>	[empty string]	N	18	20	L,M,XL,3XL,S,XXL,DUMMYSIZE	13635-DEFAULT-s.jpg	1000	3728	3479	SHORT SLEEVE	SPORT TEES	EMPTY	[empty string]	0	0	0	T-SHIRTS	lions-pride/dominate-the-state-tee-3479	2
2	[empty string]	BLACK,DUMMYCOLOR	CUTTER AND BUCK	Cutter and Buck	LADIES	LADIES &GT; SHIRTS	60	0	60	YES	13226-DEFAULT-l.jpg	[empty string]	60	13226-DEFAULT-m.jpg	C B Lady Rolled Sleeve Shirt	Y	14	50-to-100	0.00	4	[empty string]	C B Lady Rolled Sleeve Shirt	<FONT SIZE="+1"><B>C B Lady Rolled Sleeve Shirt</B></FONT><UL><LI>100% Cotton</LI><LI>Ring in the new Football season with the smart and stylish Georgetown Stripe Rolled Sleeve shirt</LI><LI>Features self-fabric collar, button front, chest pockets with button flaps, princess seams, curved hem, rolled cuff, C&B logo buttons, and C&B pennant on the inside placket</LI><LI>Embroidered Penn State logo</LI></UL>	[empty string]	N	60	60	L,M,XL,S,XXL,DUMMYSIZE	13226-DEFAULT-s.jpg	1000	04130B	3067	EMPTY	EMPTY	EMPTY	[empty string]	0	0	0	SHIRTS	cutter-and-buck/c-b-lady-rolled-sleeve-shirt-3067	1
3	[empty string]	NAVY,DUMMYCOLOR	CUTTER AND BUCK	Cutter and Buck	SPORTSWEAR	SPORTSWEAR &GT; JACKETS &GT; LIGHT WEIGHT	75	0	75	YES	13501-DEFAULT-l.jpg	[empty string]	75	13501-DEFAULT-m.jpg	C + B Kenmore Half Zip Jacket	Y	20	50-to-100	0.00	0	[empty string]	C&B Kenmore Half Zip Jacket	<FONT SIZE="+1"><B>C&B Kenmore Half Zip Jacket</B></FONT><UL><LI>100% Polyester</LI><LI>Sporty, lightweight and water resistant</LI><LI>Kenmore Half zip features reflective welt, contrast seaming detail, elastic hem and cuff, C&B logo zipper pull, and a C&B Tour logo at back neck</LI></UL>	[empty string]	N	75	75	L,M,XL,XXL,DUMMYSIZE	13501-DEFAULT-s.jpg	1000	00900N	3034	LIGHT WEIGHT	EMPTY	EMPTY	[empty string]	0	0	0	JACKETS	cutter-and-buck/cb-kenmore-half-zip-jacket-3034	1
4	[empty string]	GRAY,DUMMYCOLOR	RFSJ	RFSJ	GIFTS	GIFTS &GT; HOME &GT; DRINKWARE &GT; COFFEE MUGS	11	0	11	YES	13124-DEFAULT-l.jpg	[empty string]	11	13124-DEFAULT-m.jpg	16oz.Mk Matte Gray Logo Mug	Y	47	10-to-15	0.00	1	[empty string]	16oz. MK Matte Gray Logo Mug	<p><font size="+1"><b>16 oz. MK Matte Finish Gray Logo Mug</b></font></p> <ul> <li>16 oz gray matte finish diner mug with Penn State Nittany Lion logo in white imprint.</li> <li>It makes for a great big cup of coffee and has a unique hour glass style shape.</li> <li>Makes a great gift for coffee/tea drinkers, or makes a great mug for pens on your desk.</li> </ul>	[empty string]	N	11	11	1 Size,DUMMYSIZE	13124-DEFAULT-s.jpg	1000	TMF4545SG	2948	DRINKWARE	COFFEE MUGS	EMPTY	[empty string]	0	0	0	HOME	rfsj/16oz-mk-matte-gray-logo-mug-2948	1
5	[empty string]	NAVY,DUMMYCOLOR	CUTTER AND BUCK	Cutter and Buck	SPORTSWEAR	SPORTSWEAR &GT; POLO SHIRTS &GT; SHORT SLEEVE &GT; PERFORMANCE	60	0	60	YES	13094-DEFAULT-l.jpg	[empty string]	60	13094-DEFAULT-m.jpg	C + B Hawthorne Stripe Polo	Y	17	50-to-100	0.00	0	[empty string]	C&B Hawthorne Stripe Polo	<FONT SIZE="+1"><B>C&B Hawthorne Stripe Polo</B></FONT><LI>100% Polyester</LI><LI>A classic polo with double horizontal stripes, the moisture wicking Hawthorne features a double faced collar, three-button placket, contrast piping at placket edge, back half moon, ergonomic seaming, open sleeves, logo buttons, and a C&B pennant on the left sleeve hem.</LI>	[empty string]	N	60	60	L,M,XL,S,XXL,DUMMYSIZE	13094-DEFAULT-s.jpg	1000	00659N	2874	SHORT SLEEVE	PERFORMANCE	EMPTY	[empty string]	0	0	0	POLO SHIRTS	cutter-and-buck/cb-hawthorne-stripe-polo-2874	1
6	[empty string]	[empty string]	LEAGUE	League	SPORTSWEAR	SPORTSWEAR &GT; SHORTS &GT; ATHLETIC &GT; MESH	38	0	38	YES	13005-DEFAULT-l.jpg	[empty string]	38	13005-DEFAULT-m.jpg	League Flow Argyle Short	Y	15	25-to-50	0.00	2	[empty string]	League Flow ArgyleShort	<p><font size="+1"><b>League Flow Sublimated Short</b></font></p> <ul> <li>100% polyester</li> <li>Outside body of shorts are sublimated with a navy, white and gray argyle design</li> <li>These mesh shorts are sure to make a statement wherever you wear them</li> <li>8" inseam</li> </ul>	[empty string]	N	38	38	L,XL,XXL,DUMMYSIZE	13005-DEFAULT-s.jpg	1000	CSB450	2785	ATHLETIC	MESH	EMPTY	[empty string]	0	0	0	SHORTS	league/league-flow-argyle-short-2785	1
7	[empty string]	Navy/White,DUMMYCOLOR	CHARLES RIVER	Charles River	SPORTSWEAR	SPORTSWEAR &GT; DRESS SHIRTS &GT; RUGBY	65	0	65	YES	13013-DEFAULT-l.jpg	[empty string]	65	13013-DEFAULT-m.jpg	Criver Stripe Rugby Shirt	Y	57	50-to-100	0.00	1	[empty string]	CRiver Stripe Rugby Shirt	<FONT SIZE="+1"><B>CRiver Stripe Rugby Shirt</B></FONT><UL><LI>100% cotton jersey fabric feels soft and broken-in, right from the start </LI> <LI>Classic 4 inch yarn-dyed rugby stripe</LI><LI>Features a durable 8.5 oz white twill collar stitched with reinforcing tape for added strength.</LI> <LI>A heavy-duty white twill placket conceals rubber buttons.</LI> <LI>Rib knit cuffs. </LI><LI>Reinforced stitching throughout for added durability.</LI></UL>	[empty string]	N	60	65	L,M,XL,3XL,XXS,XS,S,XXL,DUMMYSIZE	13013-DEFAULT-s.jpg	1000	9278	2729	RUGBY	EMPTY	EMPTY	[empty string]	0	0	0	WINTER GEAR	charles-river/criver-stripe-rugby-shirt-2729	2
8	[empty string]	NAVY/WHITE,DUMMYCOLOR	TEAM EFFORT	Team Effort	GIFTS	GIFTS &GT; SPORTS &GT; GOLF ACCESSORIES &GT; BAGS	199.95	0	199.95	YES	12738-DEFAULT-l.jpg	[empty string]	199.95	12738-DEFAULT-m.jpg	Team Effort Cooler Cart Bag	Y	9999	150-to-200	0.00	5	[empty string]	Team Effort Cooler Cart Bag	<FONT SIZE="+1"><B>Team Effort Cooler Cart Bag</B></FONT><UL><LI>The Bucket cooler cart bag features the latest innovations for the practical minded golfer</LI><LI>Insulated thermal-lined beverage pocket with integrated drainage port keeps beverages and snacks coold through the 18th hole and beyond</LI><LI>14 way top organizer with front putter well features 2 sturdy tactile molded rubber handles for easy maneuvering</LI><LI>Rubber non-skid feet offer added stablility and prevent twisting when bag is riding in your cart</LI><LI>Padded shoulder strap with retainer sleeve and removable rain hood</LI><LI>First rait organization and functionality</LI></UL>	[empty string]	N	199.95	199.95	1 Size,DUMMYSIZE	12738-DEFAULT-s.jpg	1000	27BKB	2524	GOLF ACCESSORIES	BAGS	EMPTY	[empty string]	0	0	0	SPORTS	team-effort/team-effort-cooler-cart-bag-2524	15
9	[empty string]	NAVY,DUMMYCOLOR	CUTTER AND BUCK	Cutter and Buck	LADIES	LADIES &GT; CREW SWEATSHIRTS &GT; QUARTER ZIP CREWS	69	0	69	YES	12859-DEFAULT-l.jpg	[empty string]	69	12859-DEFAULT-m.jpg	C + B Ladies Choice Zip Mock	Y	29	50-to-100	0.00	3	[empty string]	C&B Ladies Choice Zip Mock	<FONT SIZE="+1"><B>Cutter & Buck Choice Zip Mock</B></FONT><UL><LI>97% polyester, 3% Spandex. </LI><LI>Fashion meets function in the moisture wicking CB DryTec Choice Zip Mock. </LI><LI>With UV protection of 25+ UPF</LI> <LI>This half zip mock has a contrast collar, contrast cover stitching, open sleeves, and a C&B pennant on the back half moon.</LI> <LI>Machine wash. </LI></UL>	[empty string]	N	69	69	L,M,XL,S,XXL,DUMMYSIZE	12859-DEFAULT-s.jpg	1000	02367N	2503	QUARTER ZIP CREWS	EMPTY	EMPTY	[empty string]	0	0	0	CREW SWEATSHIRTS	cutter-and-buck/cb-ladies-choice-zip-mock-2503	1
10	[empty string]	WHITE,DUMMYCOLOR	NIKE	Nike	SPORTSWEAR	SPORTSWEAR &GT; JERSEYS &GT; FOOTBALL &GT; REPLICA JERSEY	90	0	90	YES	13011-DEFAULT-l.jpg	[empty string]	90	13011-DEFAULT-m.jpg	Nike Replica Game Jersey # 8	Y	148	25-to-50	0.00	1	[empty string]	Nike Replica Game Jersey #8	<div> <p><b style="font-size: large;">Nike Replica Game Jersey #8</b></p> <ul> <li>2013 Penn State football away jersey</li> <li>100% polyester</li> <li>Tailored-fit, soft-hand, matte-look polyester jersey with heat transfer back-neck label and clean finished internal seams</li> <li>Screen printed numbers and Swoosh design trademark</li> <li>Woven jock tag at left hem</li> <li> Embroidered Penn State lion logo at the v-neck</li> </ul> </div>	[empty string]	Y	45	45	L,M,XL,3XL,S,XXL,DUMMYSIZE	13011-DEFAULT-s.jpg	1000	2809608R	2497	FOOTBALL	REPLICA JERSEY	EMPTY	[empty string]	0	0	0	NIKE JERSEY	nike/nike-replica-game-jersey-8-2497	2
11	[empty string]	BLUE,DUMMYCOLOR	LEGACY	Legacy	HATS	HATS &GT; ADULT &GT; ADJUSTABLE	22	0	22	YES	12006-DEFAULT-l.jpg	[empty string]	22	12006-DEFAULT-m.jpg	Legacy Old Fav Adj Trucker Hat	Y	33	20-to-25	0.00	1	[empty string]	Legacy Old Favorite Adjustable Trucker Hat	<FONT SIZE="+1"><B>Legacy Old Favorite Adjustable Trucker Hat</B></FONT><UL><LI>100% cotton twill, enzyme wahsed for a dirty effect</LI><LI>Unstructured low profile fit</LI><LI>Classic green undervisor</LI><LI>Old school snap back closure</LI><LI>Embroidered logo</LI><LI>All of our adjustable hats are one size fits most unless otherwise stated.</LI></UL>	[empty string]	N	22	22	ADJ,DUMMYSIZE	12006-DEFAULT-s.jpg	1000	331196	1108	ADJUSTABLE	EMPTY	EMPTY	[empty string]	0	0	0	ADULT	legacy/legacy-old-fav-adj-trucker-hat-1108	1
12	[empty string]	As Shown,DUMMYCOLOR	CHURCH HILL	Church Hill	GIFTS	GIFTS &GT; OFFICE / EXECUTIVE &GT; DIPLOMA FRAMES	199	0	199	YES	11311-DEFAULT-l.jpg	[empty string]	199	11311-DEFAULT-m.jpg	Church Hill Photo Diploma Frame	Y	9999	150-to-200	0.00	1	[empty string]	Church Hill Photo Diploma Frame	<FONT SIZE="+1"><B>Church Hill Photo Diploma Frame</B></FONT> <UL><LI><B>Best Seller!</B> Year in and year out the wide view collection continues to sell very well.</LI> <LI>Our Panoramic Photo Edition features a beautiful panoramic image of the Nittany Lion Statue mounted above your diploma, with Penn State's name and seal gold embossed on navy museum-quality matting. </LI><LI>It is framed in our Galleria moulding, a solid hardwood with a high-gloss cherry lacquer finish and an inner gold lip.</LI><LI> This moulding is a narrower version of our Gallery frame. </LI><LI>Finished size measures 16" x 20". </LI> <LI>Fits an 8.5" x 11" diploma.</LI><br> <font color="red"><B>NOTE</B> </font> <LI>If this item is "In Stock" it will ship from Lions Pride in 1-2 business days</LI> <LI>If this item is listed as "Drop Ship" it means that the item will ship from the manufacturer </LI><LI>You will need to allow 2-3 weeks for "Drop Ship" delivery.</LI> <LI>Drop shipped items will <U><B>only</B></U> be shipped via ground delivery.</LI></UL>h Hill Photo Diploma Frame</B></FONT> <UL><LI><B>Best Seller!</B> Year in and year out the wide view collection continues to sell very well.</LI> <LI>Our Panoramic Photo Edition features a beautiful panoramic image of the Nittany Lion Statue mounted above your diploma, with Penn State's name and seal gold embossed on navy museum-quality matting. </LI><LI>It is framed in our Galleria moulding, a solid hardwood with a high-gloss cherry lacquer finish and an inner gold lip.</LI><LI> This moulding is a narrower version of our Gallery frame. </LI><LI>Finished size measures 16" x 20". </LI> <LI>Fits an 8.5" x 11" diploma.</LI><br> <font color="red"><B>NOTE</B> </font> <LI>If this item is "In Stock" it will ship from Lions Pride in 1-2 business days</LI> <LI>If this item is listed as "Drop Ship" it means that the item will ship from the manufacturer </LI><LI>You will need to allow 2-3 weeks for "Drop Ship" delivery.</LI> <LI>Drop shipp	[empty string]	N	199	199	1 Size,DUMMYSIZE	11311-DEFAULT-s.jpg	1000	132744	539	DIPLOMA FRAMES	EMPTY	EMPTY	[empty string]	0	0	0	OFFICE / EXECUTIVE	church-hill/church-hill-photo-diploma-frame-539	25

CACHED

true

EXECUTIONTIME

SQL

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 , max(sortposition) as sortposition , 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(sizelist) as sizelist , max(name) as name , 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 , max(PRODUCTAGE) as PRODUCTAGE FROM [dbo].[web_all_products] WHERE pictureid is not null and HPFEATURED='1' GROUP BY STYLE_ID ORDER BY style_id desc