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]	GRAY,DUMMYCOLOR	CHAMPION	Champion	LADIES	LADIES &GT; CREW SWEATSHIRTS &GT; SCREEN PRINTED	50	0	50	YES	11935-DEFAULT-l.jpg	[empty string]	50	11935-DEFAULT-m.jpg	Ladies Champ Reverse Weave Crew	Y	26	25-to-50	0.00	0	[empty string]	LADIES CHAMP REVERSE WEAVE CREW	<FONT SIZE="+1"><B>Ladies Champion Reverse Weave Crew</B></FONT><UL><LI>80% Cotton/ 20% polyester crew neck sweatshirt</LI><LI>Double layer rib at neck, cuffs and waist</LI><LI>Single layer at side panel for ease of movement</LI><LI>V-notch for athletic feel</LI><LI>Screen printed front chest logo.</LI></UL>	[empty string]	N	50	50	LRG,MED,XLRG,SMALL,XXL,DUMMYSIZE	11935-DEFAULT-s.jpg	1000	C5030GRY	505	SCREEN PRINTED	EMPTY	EMPTY	[empty string]	0	0	0	CREW SWEATSHIRTS	champion/ladies-champ-reverse-weave-crew-505	2
2	[empty string]	[empty string]	CHURCH HILL	Church Hill	GIFTS	GIFTS &GT; OFFICE / EXECUTIVE &GT; DIPLOMA FRAMES	190	0	190	YES	11230-DEFAULT-l.jpg	[empty string]	190	11230-DEFAULT-m.jpg	Church Hill Gold Embossed Double Frame	Y	9999	150-to-200	0.00	0	[empty string]	Church Hill Gold Embossed Double Frame	<FONT SIZE="+1"><B>Church Hill Gold Embossed Double Frame</B></FONT><UL> <LI>Double Diploma Edition in Galleria Frame - Our Embossed Double Diploma Edition features two openings, and has the official school 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 17 inches x 24 inches.</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>	[empty string]	N	190	190	[empty string]	11230-DEFAULT-s.jpg	1000	116420	527	DIPLOMA FRAMES	EMPTY	EMPTY	[empty string]	0	0	0	OFFICE / EXECUTIVE	church-hill/church-hill-gold-embossed-double-frame-527	8
3	[empty string]	SILVER,DUMMYCOLOR	STRAN	STRAN	GIFTS	GIFTS &GT; AUTO &GT; CAR ACCESSORIES &GT; LICENSE PLATES	19	0	19	YES	11806-DEFAULT-l.jpg	[empty string]	19	11806-DEFAULT-m.jpg	Ps Alumni License Plate Frame	Y	63	15-to-20	0.00	0	[empty string]	PS Alumni License Plate Frame	<FONT SIZE="+1"><B>Penn State Alumni License Plate Frame</B></FONT><UL><LI>Painted metal license plate frame</LI><LI>Designed thinner around the edges to be used in all 50 states</LI><LI>Made in the USA</LI></UL>	[empty string]	N	19	19	ONESIZE,DUMMYSIZE	11806-DEFAULT-s.jpg	1000	THIN-PSALUM	1561	CAR ACCESSORIES	LICENSE PLATES	EMPTY	[empty string]	0	0	0	AUTO	stran/ps-alumni-license-plate-frame-1561	2
4	[empty string]	NAVY,DUMMYCOLOR	LIONS PRIDE	Lions Pride	SPORTSWEAR	SPORTSWEAR &GT; T-SHIRTS &GT; SHORT SLEEVE &GT; SCREEN PRINTED	20	0	20	YES	12718-DEFAULT-l.jpg	[empty string]	20	12718-DEFAULT-m.jpg	Penn State One Team T- Shirt	Y	258	15-to-20	0.00	0	[empty string]	PENN STATE ONE TEAM T-SHIRT	<FONT SIZE="+1"><B>Penn State One Team Tee Shirt</B></FONT><UL><LI>100% cotton screen printed Hanes Beefy T-Shirt</LI><LI>Penn State One Team full chest design </LI><LI>Show your support for our outstanding University</LI></UL>	[empty string]	N	18	20	LRG,MED,XLRG,XXXL,SMALL,XXL,DUMMYSIZE	12718-DEFAULT-s.jpg	1000	3614	1730	SHORT SLEEVE	SCREEN PRINTED	EMPTY	[empty string]	0	0	0	T-SHIRTS	lions-pride/penn-state-one-team-tshirt-1730	2
5	[empty string]	GRAY,DUMMYCOLOR	LIONS PRIDE	Lions Pride	SPORTSWEAR	SPORTSWEAR &GT; HOODED SWEATSHIRTS &GT; ZIPPER	49	0	49	YES	12505-DEFAULT-l.jpg	[empty string]	49	12505-DEFAULT-m.jpg	Canvas Full Zip Tri Blend Hood	Y	36	25-to-50	0.00	0	[empty string]	CANVAS FULL ZIP TRI BLEND HOOD	<FONT SIZE="+1"><B>CANVAS Full Zip Tri Blend Hood</B></FONT><UL><LI>50% polyester/37.5% combed and ringspun cotton/12.5% rayon</LI><LI>Super soft sponge fleece creates a classic college look that keeps you warm through the winter semester</LI><LI>Pouch pockets</LI><LI>Rib cuffs and waistband</LI><LI>Screen printed full chest logo</LI></UL>	[empty string]	N	49	49	LRG,MED,XLRG,SMALL,XXL,DUMMYSIZE	12505-DEFAULT-s.jpg	1000	C3909GRY	2244	ZIPPER	EMPTY	EMPTY	[empty string]	0	0	0	HOODED SWEATSHIRTS	lions-pride/canvas-full-zip-tri-blend-hood-2244	1
6	[empty string]	WHITE,DUMMYCOLOR	LIONS PRIDE	Lions Pride	SPORTSWEAR	SPORTSWEAR &GT; HOODED SWEATSHIRTS &GT; SCREEN PRINTED	45	0	45	YES	12543-DEFAULT-l.jpg	[empty string]	45	12543-DEFAULT-m.jpg	Ps Sport Lace Hockey Hood	Y	70	25-to-50	0.00	0	[empty string]	PS SPORT LACE HOCKEY HOOD	<FONT SIZE="+1"><B>Penn State Sport Lace Hockey Hood</B></FONT><UL><LI>10 oz 80% ring spun cotton and 20% polyester fleece fabric </LI><LI>Front pouch pocket and navy laces</LI><LI>Screen printed Athletic Lion logo with hockey</LI></UL>	[empty string]	N	45	45	LRG,MED,XLRG,SMALL,XXL,DUMMYSIZE	12543-DEFAULT-s.jpg	1000	8830WHT	2291	SCREEN PRINTED	EMPTY	EMPTY	[empty string]	0	0	0	HOODED SWEATSHIRTS	lions-pride/ps-sport-lace-hockey-hood-2291	2
7	[empty string]	WHITE,DUMMYCOLOR	PING	Ping	SPORTSWEAR	SPORTSWEAR &GT; CREW SWEATSHIRTS &GT; QUARTER ZIP CREWS	65	0	65	YES	12760-DEFAULT-l.jpg	[empty string]	65	12760-DEFAULT-m.jpg	Ping 1/4 Zip Performance Crew	Y	3	50-to-100	0.00	0	[empty string]	PING 1/4 ZIP PERFORMANCE CREW	<FONT SIZE="+1"><B>PING Ranger 1/4 Zip Performance Crew</B></FONT><UL><LI>A layering piece that will keep you warm and comfortable on the course so that you are free of distractions.</LI><LI>100% polyester</LI><LI>Sonic Weld pocket on arm with pass through MP3 player hole</LI><LI>Contrast cover stitching with PING gel print on left shoulder</LI><LI>Embroidered Penn State logo on the left chest</LI></UL>	[empty string]	N	65	65	LRG,MED,SMALL,XXL,DUMMYSIZE	12760-DEFAULT-s.jpg	1000	10F3104WHT	2378	QUARTER ZIP CREWS	EMPTY	EMPTY	[empty string]	0	0	0	CREW SWEATSHIRTS	ping/ping-1-4-zip-performance-crew-2378	2
8	[empty string]	NAVY,DUMMYCOLOR	OTSPO	OTSPO	SPORTSWEAR	SPORTSWEAR &GT; JERSEYS &GT; HOCKEY	80	0	80	YES	12566-DEFAULT-l.jpg	[empty string]	80	12566-DEFAULT-m.jpg	Adult Replica Hockey Jersey	Y	27	50-to-100	0.00	0	[empty string]	ADULT REPLICA HOCKEY JERSEY	<p><font size="+1"><b>Adult Replica Penn State Hockey Jersey</b></font></p> <ul> <li>Replica hockey jersey by OT Sports</li> <li>Same pattern as the Division 1 Penn State hockey team</li> <li>Oversized -meant to be worn with pads</li> <li>Pro Aero Mesh polyester body</li> <li>Embroidered twill Penn State athletic lion head logo on center chest</li> </ul>	[empty string]	N	80	80	LRG,MED,XLRG,XXL,DUMMYSIZE	12566-DEFAULT-s.jpg	1000	REPHOCN	2325	HOCKEY	EMPTY	EMPTY	[empty string]	0	0	0	JERSEYS	otspo/adult-replica-hockey-jersey-2325	3
9	[empty string]	NAVY,DUMMYCOLOR	NIKE	Nike	SPORTSWEAR	SPORTSWEAR &GT; JERSEYS &GT; FOOTBALL &GT; TWILL JERSEY	120	0	120	YES	13001-DEFAULT-l.jpg	[empty string]	120	13001-DEFAULT-m.jpg	Nike Limited Twill Jersey # 8	Y	197	100-to-150	0.00	0	[empty string]	NIKE LIMITED TWILL JERSEY #8	<font color="red"> <B>Please Read:</B></font> <font color="blue"><LI>Lions Pride is currently taking pre orders on the 2013 Nike Limited Twill Jerseys.</LI> <LI>They're only available in number 8.</LI> <LI>They are due to arrive from Nike in mid July.</LI> <LI>We will be shipping them to you as soon as they arrive.</LI> <LI>Our target shipping dates are between July 15 and August 1.</LI> <LI>If you are ordering multiple items on your order, we will ship the in stock items immediately and will back order the jersey.</LI> <LI>You will only be charged one time for shipping costs.</LI> <LI>Your order will be invoiced immediately. </LI> <LI>Please contact us with any other questions.</LI> <br></font> <FONT SIZE="+1"><B>Nike Limited Twill Jersey #8</B></FONT><UL><LI>2013 Penn State football home 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>Soft-hand twill numbers and direct embroidery Swoosh design trademark</LI><LI>UP printed woven jock tag at left hem</LI><LI>Embroidered Penn State lion logo at the v-neck</LI></UL>	[empty string]	N	120	120	LRG,MED,XLRG,XXXL,SMALL,XXL,DUMMYSIZE	13001-DEFAULT-s.jpg	1000	2855008	2494	FOOTBALL	TWILL JERSEY	EMPTY	[empty string]	0	0	0	NIKE JERSEY	nike/nike-limited-twill-jersey-8-2494	2
10	[empty string]	NAVY,DUMMYCOLOR	BIG10	BIG10	SPORTSWEAR	SPORTSWEAR &GT; T-SHIRTS &GT; SHORT SLEEVE &GT; SCREEN PRINTED	22	0	22	YES	12679-DEFAULT-l.jpg	[empty string]	20	12679-DEFAULT-m.jpg	Lady Lion Big 10 Champion Tee	Y	64	15-to-20	0.00	1	[empty string]	LADY LION BIG 10 CHAMPION TEE	<p id="description"><span style="font-size: large;"><strong><span class="prodTitle">Lady Lion Big 10 Champions Tee</span></strong></span></p> <ul class="infoTXT"> <li><span style="font-size: small;">Lady Lions 2012 and 2013 Big 10 Champions tee shirt.</span></li> <li><span style="font-size: small;">100% cotton Hanes Beefy t-shirt.<br /> </span></li> <li><span style="font-size: small;">Screen printed logo on the front chest<br /> </span></li> <li><span style="font-size: small;">Screen printed 1" LP lion logo on left sleeve</span></li> </ul>	[empty string]	N	20	20	LRG,MED,XLRG,SMALL,XXL,DUMMYSIZE	12679-DEFAULT-s.jpg	1000	3663	2509	SHORT SLEEVE	SCREEN PRINTED	EMPTY	[empty string]	0	0	0	T-SHIRTS	big10/lady-lion-big-10-champion-tee-2509	1
11	[empty string]	NAVY,DUMMYCOLOR	LIONS PRIDE	Lions Pride	SPORTSWEAR	SPORTSWEAR &GT; T-SHIRTS &GT; SHORT SLEEVE &GT; SCREEN PRINTED	18	0	18	YES	12735-DEFAULT-l.jpg	[empty string]	18	12735-DEFAULT-m.jpg	Iron Lion Dominator Tee Shirt	Y	271	15-to-20	0.00	1	[empty string]	IRON LION DOMINATOR TEE SHIRT	<p> </p> <p><font size="+1"><b>Iron Lion <font size="+1">Dominator</font> Tee </b><span style="font-size: large;"><b>Shirt</b></span></font></p> <ul> <li>100% cotton screen printed Hanes Beefy T-Shirt</li> <li>Full chest screen printed Iron Lion on the front and Dominator on the back</li> <li>Small LP lion logo screen printed on the left sleeve</li> <li>Iron Lion - Made famous by the new PS Football strength and conditioning coaches</li> </ul> <p> </p>	[empty string]	N	18	18	LRG,MED,XLRG,XXXL,SMALL,XXL,DUMMYSIZE	12735-DEFAULT-s.jpg	1000	3656	2398	SHORT SLEEVE	SCREEN PRINTED	EMPTY	[empty string]	0	0	0	T-SHIRTS	lions-pride/iron-lion-dominator-tee-shirt-2398	1
12	[empty string]	WHITE,DUMMYCOLOR	CUTTER AND BUCK	Cutter and Buck	LADIES	LADIES &GT; JACKETS &GT; HEAVY WEIGHT	155	0	155	YES	12551-DEFAULT-l.jpg	[empty string]	155	12551-DEFAULT-m.jpg	C + B Ladies Weathertec Jacket	Y	4	150-to-200	0.00	1	[empty string]	C+B LADIES WEATHERTEC JACKET	<FONT SIZE="+1"><B>Cutter & Buck Ladies Weathertec Sanders Jacket</B></FONT><UL><LI>A great waterproof jacket for the active, style-conscious woman, the CB WeatherTec Sanders will protect you from the elements.</LI> <LI>Breathable, fully lined and seam sealed</LI> <LI>This jacket features a fleece lined collar, chin guard, pieced front and back body</LI><LI>Adjustable draw cord hem, elastic snow skirt, articulated sleeves, front zipper pockets, waterproof chest pocket, and overall waterproofing</LI> <LI>100% polyester.</LI> <LI>Machine wash, hang to dry.</LI></UL>	[empty string]	N	155	155	MED,XLRG,XXL,DUMMYSIZE	12551-DEFAULT-s.jpg	1000	01187W	2303	HEAVY WEIGHT	EMPTY	EMPTY	[empty string]	0	0	0	JACKETS	cutter-and-buck/cb-ladies-weathertec-jacket-2303	4
13	[empty string]	PINK,DUMMYCOLOR	LIONS PRIDE	Lions Pride	BABY	BABY &GT; BIBS	8	0	8	YES	11762-DEFAULT-l.jpg	[empty string]	8	11762-DEFAULT-m.jpg	Bib W/Snap Closure	Y	22	5-to-10	0.00	1	[empty string]	Bib w/ Snap Closure	<FONT SIZE="+1"><B>Bib w/ Snap Closure</B></FONT><UL><LI>Terrycloth Bib with snap closures</LI><LI>Screen printed logo</LI></UL>	[empty string]	N	8	8	ONESIZE,DUMMYSIZE	11762-DEFAULT-s.jpg	1000	3511	704	EMPTY	EMPTY	EMPTY	[empty string]	0	0	0	BIBS	lions-pride/bib-w-snap-closure-704	1
14	[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	2	[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	N/A,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	7
15	[empty string]	NEON,DUMMYCOLOR	LIONS PRIDE	Lions Pride	LADIES	LADIES &GT; PANTS &GT; SLEEPWEAR	26	0	26	YES	12786-DEFAULT-l.jpg	[empty string]	26	12786-DEFAULT-m.jpg	Boxercraft Ladies Flannel Pant	Y	34	25-to-50	0.00	4	[empty string]	BOXERCRAFT LADIES FLANNEL PANT	<FONT SIZE="+1"><B>BoxerCraft Ladies Flannel Pant</B></FONT><UL><LI>Features a roomy cut and covered elastic band with imprintable taping</LI><LI>Constructed from the finest quality 100% cotton, double-brushed flannel</LI><LI>Lightweight and comfy 4 oz. material</LI><LI>Junior fit</LI></UL>	[empty string]	N	26	26	LRG,MED,XLRG,SMALL,DUMMYSIZE	12786-DEFAULT-s.jpg	1000	F19NEON	2526	SLEEPWEAR	EMPTY	EMPTY	[empty string]	0	0	0	PANTS	lions-pride/boxercraft-ladies-flannel-pant-2526	1
16	[empty string]	NAVY,DUMMYCOLOR	CHARLES RIVER	Charles River	LADIES	LADIES &GT; JACKETS &GT; LIGHT WEIGHT	79	0	79	YES	12669-DEFAULT-l.jpg	[empty string]	79	12669-DEFAULT-m.jpg	Cr Lady Nor ` Easter Rain Jacket	Y	18	50-to-100	0.00	6	[empty string]	CR LADY NOR`EASTER RAIN JACKET	<p><span style="font-size: large;"><strong>Women's Nor'easter Rain Jacket</strong></span></p> <ul> <li>Breathable, wind and waterproof HydraLyte Nylon, unlined</li> <li>Taped seams throughout to seal out wind and rain</li> <li>Concealed hood in collar</li> <li>2 way front zipper and zippered side pockets</li> <li>Princess seams for a flattering appearance</li> <li>Stylish chest pockets with hook and loop closure</li> <li>Embroidered Penn State logo</li> </ul> <p> </p>	[empty string]	N	79	79	LRG,MED,XLRG,SMALL,XXL,DUMMYSIZE	12669-DEFAULT-s.jpg	1000	5375NVY	2421	LIGHT WEIGHT	EMPTY	EMPTY	[empty string]	0	0	0	JACKETS	charles-river/cr-lady-noreaster-rain-jacket-2421	2
17	[empty string]	NAVY,DUMMYCOLOR	LIONS PRIDE	Lions Pride	SPORTSWEAR	SPORTSWEAR &GT; T-SHIRTS &GT; SHORT SLEEVE &GT; SCREEN PRINTED	22	0	22	YES	12680-DEFAULT-l.jpg	[empty string]	22	12680-DEFAULT-m.jpg	Ps Wrestling Nat Champ T	Y	52	15-to-20	0.00	7	[empty string]	PS WRESTLING NAT CHAMP T	<p id="description"><span style="font-size: large;"><strong><span class="prodTitle">Wrestling National Champions Tee</span></strong></span></p> <ul class="infoTXT"> <li><span style="font-size: small;">Penn State Wrestling 2011, 2012, 2013 National Champions tee shirt.</span></li> <li><span style="font-size: small;">100% cotton Hanes Beefy t-shirt.<br /> </span></li> <li><span style="font-size: small;">Screen printed logo on the front chest<br /> </span></li> <li><span style="font-size: small;">Screen printed 1" LP lion logo on left sleeve</span></li> <li><span style="font-size: small;">Available in store by Monday afternoon, March 25</span></li> </ul>	[empty string]	N	20	22	LRG,MED,XLRG,XXXL,SMALL,XXL,DUMMYSIZE	12680-DEFAULT-s.jpg	1000	3664	2513	SHORT SLEEVE	SCREEN PRINTED	EMPTY	[empty string]	0	0	0	WRESTLING	lions-pride/ps-wrestling-nat-champ-t-2513	1
18	[empty string]	GLASS,DUMMYCOLOR	CAMPUS CREATIONS	Campus Creations	GIFTS	GIFTS &GT; HOME &GT; DRINKWARE &GT; ETCHED GLASSWARE	14	0	14	YES	11512-DEFAULT-l.jpg	[empty string]	14	11512-DEFAULT-m.jpg	16 Oz Etched Pint Glass	Y	1	10-to-15	0.00	8	[empty string]	16 oz Etched Pint Glass	<FONT SIZE="+1"><B>16 oz Etched Pint Glass1</B></FONT><UL><LI>6 oz. Pint glass with etched Penn State seal. </LI> <LI>This item is also sold in a set of 4.</LI></UL>	[empty string]	N	14	14	N/A,DUMMYSIZE	11512-DEFAULT-s.jpg	1000	X-8	445	DRINKWARE	ETCHED GLASSWARE	EMPTY	[empty string]	0	0	0	HOME	campus-creations/16-oz-etched-pint-glass-445	1
19	[empty string]	GREEN,DUMMYCOLOR	LEGACY	Legacy	HATS	HATS &GT; ADULT &GT; ADJUSTABLE	20	0	20	YES	12700-DEFAULT-l.jpg	[empty string]	20	12700-DEFAULT-m.jpg	Legacy Adjustable Ps Lion Hat	Y	25	15-to-20	0.00	12	[empty string]	LEGACY ADJUSTABLE PS LION HAT	<p> <p><font size="+1"><b>Legacy Relaxed Twill Adjustable PS Lion Hat</b></font></p> <ul> <li>100% cotton twill, sandwashed</li> <li>Unstructured low profile fit</li> <li>Fabric strap closure with brass slide buckle</li> <li>Embroidered logo</li> <li>All of our adjustable hats are one size fits most unless otherwise stated.</li> </ul> </p>	[empty string]	N	20	20	N/A,DUMMYSIZE	12700-DEFAULT-s.jpg	1000	370384	2493	ADJUSTABLE	EMPTY	EMPTY	[empty string]	0	0	0	ADULT	legacy/legacy-adjustable-ps-lion-hat-2493	1
20	[empty string]	AS SHOWN,DUMMYCOLOR	ROSS	ROSS	HATS	HATS &GT; ADULT &GT; KNIT &GT; HATS	24	0	24	YES	12404-DEFAULT-l.jpg	[empty string]	24	12404-DEFAULT-m.jpg	Zoozatz Furry Adult Mascot Hat	Y	82	15-to-20	0.00	12	[empty string]	ZooZatz Furry Adult Mascot Hat	<FONT SIZE="+1"><B>ZooZatz Furry Adult Mascot Ear Flap Hat</B></FONT><UL><LI>Official NCAA Licensed ZooZatz Mascot furry winter</LI><LI>Toasty warm & crazy comfortable- no hat headaches with ZooZatZ hats!</LI><LI>One size fits most, recommended ages 5 and up </LI></UL>	[empty string]	Y	18	18	N/A,DUMMYSIZE	12404-DEFAULT-s.jpg	1000	POO54A	2135	KNIT	HATS	EMPTY	[empty string]	0	0	0	ADULT	ross/zoozatz-furry-adult-mascot-hat-2135	1
21	[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	7	15-to-20	0.00	13	[empty string]	iPhone 5 Case with Stadium Image	<FONT SIZE="+1"><B>iPhone 5 Case with Stadium Image</B></FONT> <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 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	N/A,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
22	[empty string]	As Shown,DUMMYCOLOR	US LI	US LI	GIFTS	GIFTS &GT; AUTO &GT; CAR ACCESSORIES &GT; HITCH COVERS	10	0	10	YES	11018-DEFAULT-l.jpg	[empty string]	10	11018-DEFAULT-m.jpg	2 " Trailer Hitch Cover	Y	45	5-to-10	0.00	19	[empty string]	2" Trailer Hitch Cover	<FONT SIZE="+1"><B>Hitch Cover- 2" Trailer Hitch Cover</B></FONT><UL><LI>Plastic and rubber hitch cover with the Penn State sports logo on it.</LI> <LI>Fits 2" receiver. </LI><LI>No hitch pin required. </LI><LI>Fits GMC, Chevy, Dodge, Jeep, Toyota Tocoma, Sequoiya. Nissan, BMW, Mercedes, Lincoln Navigator, and Ford Excursion, Expedition, F150, F250, Ranger.</LI></UL>	[empty string]	N	10	10	N/A,DUMMYSIZE	11018-DEFAULT-s.jpg	1000	HITCH	1667	CAR ACCESSORIES	HITCH COVERS	EMPTY	[empty string]	0	0	0	AUTO	us-li/2-trailer-hitch-cover-1667	0.5
23	[empty string]	NAVY,DUMMYCOLOR	COLLEGIATE PACIFIC	Collegiate Pacific	GIFTS	GIFTS &GT; HOME &GT; BANNERS &GT; BANNERS	28	0	28	YES	12624-DEFAULT-l.jpg	[empty string]	28	12624-DEFAULT-m.jpg	Penn State One Team Banner	Y	35	25-to-50	0.00	20	[empty string]	PENN STATE ONE TEAM BANNER	<p><strong><span style="font-size: large;">One Team Banner</span></strong></p> <ul> <li>Traditional wool felt banner with "One Team" logo</li> <li>18"x36"</li> <li>Show your team spirit in your office, car or at home with these old fashioned banners.</li> <li>This banner has two grommets, one on each side of the top of the banner.</li> </ul>	[empty string]	N	28	28	ONESIZE,DUMMYSIZE	12624-DEFAULT-s.jpg	1000	7447OT	2340	BANNERS	BANNERS	EMPTY	[empty string]	0	0	0	HOME	collegiate-pacific/penn-state-one-team-banner-2340	0
24	[empty string]	As Shown,DUMMYCOLOR	MCM	MCM	GIFTS	GIFTS &GT; OFFICE / EXECUTIVE &GT; OFFICE ACCCESSORIES &GT; COMPUTER	22	0	22	YES	12209-DEFAULT-l.jpg	[empty string]	22	12209-DEFAULT-m.jpg	Plastic Ipad Case	N	17	20-to-25	0.00	71	[empty string]	Plastic iPad Case	<FONT SIZE="+1"><B>Plastic iPad Case</B></FONT><UL><LI>Turn your iPad into a Penn State Nittany Lion iPad with this snap on plastic cover</LI><LI>Adds a little extra protection for your iPad</LI></UL>	[empty string]	N	22	22	N/A,DUMMYSIZE	12209-DEFAULT-s.jpg	1000	CM7776	1774	OFFICE ACCCESSORIES	COMPUTER	EMPTY	[empty string]	0	0	0	OFFICE / EXECUTIVE	mcm/plastic-ipad-case-1774	1

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 productage, sortposition