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]	Navy,DUMMYCOLOR	LEGACY	Legacy	HATS	HATS &GT; ADULT &GT; ADJUSTABLE	20	0	20	YES	13668-DEFAULT-l.jpg	[empty string]	20	13668-DEFAULT-m.jpg	Legacy Dominate The State Hat	Y	33	15-to-20	0.00	0	[empty string]	Legacy Dominate the State Hat	<p><span style="font-size: large;"><strong>Legacy Dominate the State Hat</strong></span></p> <ul> <li><span style="font-size: small;">100% cotton twill</span></li> <li><span style="font-size: small;">Unstructured low profile fit</span></li> <li><span style="font-size: small;">Fabric strap closure with brass slide buckle</span></li> <li><span style="font-size: small;">Embroidered logo</span></li> <li><span style="font-size: small;">All of our adjustable hats are one size fits most unless otherwise stated.</span></li> </ul> <p> </p>	[empty string]	N	20	20	ADJ,DUMMYSIZE	13668-DEFAULT-s.jpg	1000	404478	3540	EMPTY	EMPTY	EMPTY	[empty string]	0	0	0	FRANKLIN	legacy/legacy-dominate-the-state-hat-3540	2
2	[empty string]	DARK GRAY,DUMMYCOLOR	LIONS PRIDE	Lions Pride	SPORTSWEAR	SPORTSWEAR &GT; T-SHIRTS &GT; SHORT SLEEVE &GT; SCREEN PRINTED	20	0	20	YES	13635-DEFAULT-l.jpg	[empty string]	20	13635-DEFAULT-m.jpg	Dominate The State Tee	Y	451	15-to-20	0.00	0	[empty string]	Dominate the State Tee	<p><span style="font-family: Arial;"><span style="font-size: large;">Dominate the State T-Shirt</span></span><span style="font-size: medium;"><br /> </span></p> <ul> <li><span style="font-size: small;">"We are going to dominate the state," said Coach James Franklin about recruiting at his introductory Penn State press conference.</span></li> <li><span style="font-size: small;">Get your Dominate the State - We Are Penn State Football tee shirt now.</span></li> <li><span style="font-size: small;">Hanes Beefy Tee</span></li> <li><span style="font-size: small;">90% cotton 10% polyester blend t-shirt</span></li> <li><span style="font-size: small;">Screen printed 2 color logo on the front chest</span></li> </ul>	[empty string]	N	18	20	L,M,XL,3XL,S,XXL,DUMMYSIZE	13635-DEFAULT-s.jpg	1000	3728	3479	SHORT SLEEVE	SCREEN PRINTED	EMPTY	[empty string]	0	0	0	T-SHIRTS	lions-pride/dominate-the-state-tee-3479	2
3	[empty string]	White,DUMMYCOLOR	LEAGUE	League	LADIES	LADIES &GT; T-SHIRTS &GT; LONG SLEEVE	39	0	39	YES	13664-DEFAULT-l.jpg	[empty string]	39	13664-DEFAULT-m.jpg	League Ra Ra Jersey Ls Tee	Y	76	25-to-50	0.00	0	[empty string]	League Ra Ra Jersey LS Tee	<p> </p> <p style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><strong><span style="font-size: large;"><span style="font-family: Arial;">League Ra Ra Spirit Jersey Long Sleeve T-Shirt</span></span></strong></p> <ul style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"> <li><span style="font-family: Arial;"><span style="font-size: small;">Oversized heavy weight long sleeve tee</span></span></li> <li><span style="font-family: Arial;"><span style="font-size: small;">100% cotton</span></span></li> <li><span style="font-family: Arial;"><span style="font-size: small;">Screen printed Penn State logos on front and back</span></span></li> </ul> <p> </p>	[empty string]	N	39	39	L,M,S,DUMMYSIZE	13664-DEFAULT-s.jpg	1000	MF615WHT	3377	LONG SLEEVE	EMPTY	EMPTY	[empty string]	0	0	0	T-SHIRTS	league/league-ra-ra-jersey-ls-tee-3377	2
4	[empty string]	Navy/White,DUMMYCOLOR	MEAN	MEAN	GIFTS	GIFTS &GT; MISCELLANEOUS &GT; GLASSES	35	0	35	YES	13590-DEFAULT-l.jpg	[empty string]	35	13590-DEFAULT-m.jpg	Maxx Hd Ps Sunglasses	Y	28	25-to-50	0.00	2	[empty string]	Maxx HD PS Sunglasses	<FONT SIZE="+1"><B>Maxx HD PS Sunglasses</B></FONT><UL><LI>Show off your Nittany Lion pride with these incredible Penn State shades!</LI> <LI>Officially licensed</LI> <LI>Sleek, bold, full sized sunglasses</LI> <LI>Engineered with a no slip rubber nose piece and arm grips</LI> <LI>Full lens coverage without peripheral distortion</LI> <LI>Signature High Definition lenses</LI> <LI>Quality metal logos with vibrant team colors</LI> <LI>Lenses exceed ANSI impact standards</LI> <LI>100% UVA & UVB protection</LI></UL>	[empty string]	N	35	35	1 Size,DUMMYSIZE	13590-DEFAULT-s.jpg	1000	MAXXNVY	3297	GLASSES	EMPTY	EMPTY	[empty string]	0	0	0	MISCELLANEOUS	mean/maxx-hd-ps-sunglasses-3297	1
5	[empty string]	Navy,DUMMYCOLOR	LIONS PRIDE	Lions Pride	SPORTSWEAR	SPORTSWEAR &GT; T-SHIRTS &GT; SHORT SLEEVE &GT; SCREEN PRINTED &GT; SPORT TEES	18	0	18	YES	13522-DEFAULT-l.jpg	[empty string]	18	13522-DEFAULT-m.jpg	Penn State Wrestling T- Shirt	Y	68	15-to-20	0.00	0	[empty string]	Penn State Wrestling T-Shirt	<p><font size="+1"><b>PS Wrestling T-Shirt</b></font></p> <ul> <li>Hanes 100% ring spun cotton t-shirt with a full chest screen printed Penn State over Lion head Wrestling design.</li> <li>Perfect way to show your support for the team</li> </ul>	[empty string]	N	18	18	L,M,XL,3XL,S,XXL,DUMMYSIZE	13522-DEFAULT-s.jpg	1000	3712	3231	SHORT SLEEVE	SCREEN PRINTED	SPORT TEES	[empty string]	0	0	0	T-SHIRTS	lions-pride/penn-state-wrestling-tshirt-3231	1
6	[empty string]	Navy,DUMMYCOLOR	NIKE	Nike	SPORTSWEAR	SPORTSWEAR &GT; HOODED SWEATSHIRTS &GT; SCREEN PRINTED	75	0	75	YES	13592-DEFAULT-l.jpg	[empty string]	75	13592-DEFAULT-m.jpg	Nike Dri- Fit Hockey Hoodie	Y	38	50-to-100	0.00	0	[empty string]	Nike Dri-Fit Hockey Hoodie	<FONT SIZE="+1"><B>Nike Dri-Fit Hockey Hoodie</B></FONT><UL><LI>100% Polyester Therma-FIT fabric</LI><LI>Therma-FIT performance fleece pull over hoody</LI><LI>Penn State Hockey and lion head logo design</LI><LI>Swoosh desighn trademark on upper left shoulder</LI></UL>	[empty string]	N	75	75	L,M,XL,S,XXL,DUMMYSIZE	13592-DEFAULT-s.jpg	1000	M41132NVY	3213	SCREEN PRINTED	EMPTY	EMPTY	[empty string]	0	0	0	HOODED SWEATSHIRTS	nike/nike-drifit-hockey-hoodie-3213	3
7	[empty string]	BROWN,DUMMYCOLOR	MASCOT FACTORY	Mascot Factory	GIFTS	GIFTS &GT; MISCELLANEOUS &GT; STUFFED ANIMALS	20	0	20	YES	13251-DEFAULT-l.jpg	[empty string]	20	13251-DEFAULT-m.jpg	Nittany Lion Plush Mascot	Y	222	15-to-20	0.00	0	[empty string]	Nittany Lion Plush Mascot	<FONT SIZE="+1"><B>Nittany Lion Plush Mascot</B></FONT><UL><LI>11 inch plush Nittany Lion mascot</LI><LI>Perfect for a Penn State fan</LI><LI>Great for decoration or for children to play with</LI><LI>You'll never have to chant "We want the Lion" again, you'll have your very own.</LI></UL>	[empty string]	N	20	20	1 Size,DUMMYSIZE	13251-DEFAULT-s.jpg	1000	NITLION	3082	STUFFED ANIMALS	EMPTY	EMPTY	[empty string]	0	0	0	MISCELLANEOUS	mascot-factory/nittany-lion-plush-mascot-3082	1
8	[empty string]	Navy,DUMMYCOLOR	NIKE	Nike	SPORTSWEAR	SPORTSWEAR &GT; JERSEYS &GT; FOOTBALL &GT; REPLICA JERSEY	90	0	90	YES	13389-DEFAULT-l.jpg	[empty string]	90	13389-DEFAULT-m.jpg	Nike Replica Game Jersey # 14	Y	194	50-to-100	0.00	2	[empty string]	Nike Replica Game Jersey #14	<FONT SIZE="+1"><B>Nike Replica Game Jersey #14</B></FONT><UL><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></UL>	[empty string]	N	90	90	L,M,XL,S,XXL,DUMMYSIZE	13389-DEFAULT-s.jpg	1000	2809614	2979	FOOTBALL	REPLICA JERSEY	EMPTY	[empty string]	0	0	0	JERSEYS	nike/nike-replica-game-jersey-14-2979	2
9	[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	56	10-to-15	0.00	5	[empty string]	16oz. MK Matte Gray Logo Mug	<FONT SIZE="+1"><B>16 oz. MK Matte Finish Gray Logo Mug</B></FONT><UL><LI>16 oz cobalt blue 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> The matte finish on the blue mug makes the printed white Penn State seal dramatic enough to wake you up, after you've had your first cup of course.</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
10	[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	41	25-to-50	0.00	0	[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 checkered design</li> <li>These mesh shorts are sure to make a statement</li> </ul>	[empty string]	N	38	38	L,M,XL,S,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
11	[empty string]	Pink,DUMMYCOLOR	LIONS PRIDE	Lions Pride	BABY	BABY &GT; ONESIES / ROMPERS	9	0	9	YES	12860-DEFAULT-l.jpg	[empty string]	9	12860-DEFAULT-m.jpg	Peace Love Lions Creeper	Y	23	5-to-10	0.00	0	[empty string]	Peace Love Lions Creeper	<FONT SIZE="+1"><B>Peace Love Lions Creeper</B></FONT><UL><LI>100% cotton with white printing this creeper features over lapping shoulder hems for easy on and off over the head</LI><LI>A snap crotch for easy diaper changing.</LI> <LI>A great little shirt to show your young one's Penn State Pride</LI></UL>	[empty string]	N	9	9	12m,18m,DUMMYSIZE	12860-DEFAULT-s.jpg	1000	3668	2549	EMPTY	EMPTY	EMPTY	[empty string]	0	0	0	ONESIES / ROMPERS	lions-pride/peace-love-lions-creeper-2549	1
12	[empty string]	As Shown,DUMMYCOLOR	KEYSCAPER	Keyscaper	GIFTS	GIFTS &GT; OFFICE / EXECUTIVE &GT; OFFICE ACCCESSORIES &GT; CELL PHONE	20	0	20	YES	12561-DEFAULT-l.jpg	[empty string]	20	12561-DEFAULT-m.jpg	Iphone 5 Case With Stadium Image	Y	11	15-to-20	0.00	1	[empty string]	iPhone 5/5S Case with Stadium Image	<p><font size="+1"><b>iPhone 5/5S Case with Stadium Image</b></font></p> <ul> <li>Lightweight and stylish, these awesome cases go the distance.</li> <li>Combine durability with your favorite team, and you've got a winning combination.</li> <li>Fits iPhone 5/5S AT&T, Verizon and Sprint models.</li> <li>Awesome full color printing. Not a sticker or wrap!</li> <li>Sleek, durable protection</li> <li>Cases provide access to all controls and covers back and sides of iPhone.</li> <li>Printed in the USA.</li> </ul>	[empty string]	N	20	20	1 Size,DUMMYSIZE	12561-DEFAULT-s.jpg	1000	KIPH5F-S	2317	OFFICE ACCCESSORIES	CELL PHONE	EMPTY	[empty string]	0	0	0	OFFICE / EXECUTIVE	keyscaper/iphone-5-case-with-stadium-image-2317	0

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 , 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, sortposition ORDER BY style_id desc