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	JVP	JVP	SPORTSWEAR	SPORTSWEAR &GT; T-SHIRTS &GT; LONG SLEEVE &GT; SCREEN PRINTED	22	0	22	YES	14426-DEFAULT-l.jpg	[empty string]	22	14426-DEFAULT-m.jpg	Joe Paterno 409 Long Sleeve T	N	63	20-to-25	0.00	0	[empty string]	Joe Paterno 409 Long Sleeve T	<p> </p> <p><strong><span style="font-size: larger;">Joe Paterno 409 Long Sleeve Tee<br /> </span></strong></p> <ul> <li>Joe Paterno's 409 wins have been restored!</li> <li>Celebrate the Winningest Coach of All Time with this shirt</li> <li>The lettering within the numbers 409 reflects each of Joe's accomplishments as a coach and philanthropist</li> </ul> <p> </p>	[empty string]	N	22	22	L,M,XL,S,XXL,DUMMYSIZE	14426-DEFAULT-s.jpg	1000	3755	4333	LONG SLEEVE	SCREEN PRINTED	EMPTY	[empty string]	0	0	0	T-SHIRTS	jvp/joe-paterno-409-long-sleeve-t-4333	2
2	[empty string]	SAPPHIRE,DUMMYCOLOR	THON	THON	SPORTSWEAR	SPORTSWEAR &GT; T-SHIRTS &GT; SHORT SLEEVE &GT; SCREEN PRINTED	15	0	15	YES	14423-DEFAULT-l.jpg	[empty string]	15	14423-DEFAULT-m.jpg	4 Weeks 4 Thon Promotional Tee	N	1	10-to-15	0.00	0	[empty string]	4 Weeks 4 Thon T-Shirt	<p><font size="+1"><b>4 Weeks 4 Thon Promotional T-Shirt</b></font></p> <ul> <li>Purchase this shirt for $15 and ALL proceeds will go to THON</li> <li>Or spend $75 or more and we will donate 20% of your purchase price to Thon and you will receive this tee shirt for FREE</li> <li><span style="color: rgb(0, 0, 255);"><strong>If you spend $75 or more and want the FREE tee then be sure to put the requested size in the order comments box and click the submit button.  Do NOT put the free tee in your shopping cart.<br /> </strong></span></li> <li>Gildan 100% cotton uni-sex  men's cut tee</li> <li>Screen printed logo on the front and the back</li> </ul>	[empty string]	N	15	15	XL,DUMMYSIZE	14423-DEFAULT-s.jpg	1000	3751	4328	SHORT SLEEVE	SCREEN PRINTED	EMPTY	[empty string]	0	0	0	THON	thon/4-weeks-4-thon-promotional-tee-4328	1
3	[empty string]	PACIFIC,DUMMYCOLOR	LEAGUE	League	LADIES	LADIES &GT; T-SHIRTS &GT; LONG SLEEVE	48	0	48	YES	14430-DEFAULT-l.jpg	[empty string]	48	14430-DEFAULT-m.jpg	League Color Block Ra Ra Lst	N	52	25-to-50	0.00	0	[empty string]	League Color Block Ra Ra	<p><strong><span style="font-size: large;">League Color Block Ra Ra Jersey Long Sleeve T-Shirt</span></strong></p> <ul> <li><span style="font-size: small;">Oversized heavy weight long sleeve tee</span></li> <li><span style="font-size: small;">100% cotton</span></li> <li><span style="font-size: small;">Screen printed Penn State logos on front and back</span></li> <li><span style="font-size: small;">Laid back, slouchy fit that looks good with everything</span></li> </ul> <p> </p	[empty string]	N	48	48	L,M,XL,S,DUMMYSIZE	14430-DEFAULT-s.jpg	1000	MF620BLU	4308	LONG SLEEVE	EMPTY	EMPTY	[empty string]	0	0	0	T-SHIRTS	league/league-color-block-ra-ra-lst-4308	1
4	[empty string]	NAVY,DUMMYCOLOR	LEAGUE	League	SPORTSWEAR	SPORTSWEAR &GT; JACKETS &GT; LIGHT WEIGHT	55	0	55	YES	14422-DEFAULT-l.jpg	[empty string]	55	14422-DEFAULT-m.jpg	League Embroider Full Zip Hood	N	28	50-to-100	0.00	0	[empty string]	League Embroider Full Zip Hood	<p><span style="font-size: large;"><strong>League Embroidered Full Zip Hood</strong></span></p> <ul> <li>Tri Blend full zip up hood</li> <li>60% cotton / 30% polyester /10% rayon</li> <li>Embroidered PENN STATE letters</li> <li>Sporty vintage look with a preppy attitude</li> <li>Sure to become your favorite hoodie</li> <li>Modern fit</li> </ul>	[empty string]	N	55	55	L,M,XL,DUMMYSIZE	14422-DEFAULT-s.jpg	1000	ML485NVY	4304	ZIPPER	EMPTY	EMPTY	[empty string]	0	0	0	LEAGUE	league/league-embroider-full-zip-hood-4304	3
5	[empty string]	NAVY,DUMMYCOLOR	SPIRIT	Spirit	LADIES	LADIES &GT; T-SHIRTS &GT; LONG SLEEVE	50	0	50	YES	14391-DEFAULT-l.jpg	[empty string]	50	14391-DEFAULT-m.jpg	Spirit Brand Spirit Jersey Lc	N	86	25-to-50	5.00	0	[empty string]	Spirit Brand Spirit Jersey	<p id="description"><span style="font-size: large;"><strong>Spirit Football Jersey - Penn State</strong></span><strong><span style="font-size: larger;"><br /> </span></strong></p> <ul class="infoTXT"> <li><span style="font-size: small;">Authentic. Famous. Original. Spirit Football Jersey. Made in the USA</span></li> <li><span style="font-size: small;">Spirit Jerseys have become the de facto way to show your spirit and solidarity with your school in style and comfort</span></li> <li><span style="font-size: small;">Features unmistakable bold back print in their famous puff ink and unique drop shoulder design</span></li> <li><span style="font-size: small;">Screen printed front logo</span></li> <li><span style="font-size: small;">Designed to fit oversized</span></li> </ul>	[empty string]	N	50	50	S,XS,M,L,DUMMYSIZE	14391-DEFAULT-s.jpg	1000	J470NVY15	4290	LONG SLEEVE	EMPTY	EMPTY	[empty string]	0	0	0	T-SHIRTS	spirit/spirit-brand-spirit-jersey-lc-4290	2
6	[empty string]	WHITE,DUMMYCOLOR	NIKE	Nike	SPORTSWEAR	SPORTSWEAR &GT; T-SHIRTS &GT; LONG SLEEVE &GT; SCREEN PRINTED	32	0	32	YES	14264-DEFAULT-l.jpg	[empty string]	32	14264-DEFAULT-m.jpg	Nike Unrivaled Psfb Lng Slv T	N	143	25-to-50	0.00	0	[empty string]	Nike Unrivaled PSFB Lng Slv T	<p> </p> <p><strong><span style="font-size: larger;">Nike Unrivaled PS Football  Long Sleeve Tee</span></strong></p> <ul> <li><span style="font-size: small;">100% cotton long sleeve t-shirt</span><span style="font-size: larger;"><br /> </span></li> <li>Cotton crew neck t-shirt with Nike Unrivaled design</li> <li>Swoosh design trademark at left shoulder</li> </ul> <p> </p>	[empty string]	N	32	32	L,M,XL,S,XXL,DUMMYSIZE	14264-DEFAULT-s.jpg	1000	33292WHT	4169	LONG SLEEVE	SCREEN PRINTED	EMPTY	[empty string]	0	0	0	WHITE OUT	nike/nike-unrivaled-psfb-lng-slv-t-4169	2
7	[empty string]	BLUE,DUMMYCOLOR	CUTTER BUCK	Cutter Buck	LADIES	LADIES &GT; SHIRTS	65	0	65	YES	14036-DEFAULT-l.jpg	[empty string]	65	14036-DEFAULT-m.jpg	Cb Ladies Micro Print Oxford	N	12	50-to-100	0.00	3	[empty string]	CB Ladies Micro Print Oxford	<p><strong><span style="font-size: larger;">Cutter & Buck Ladies Micro Print Oxford</span></strong></p> <ul> <li>100% cotton plain weave</li> <li>Self fabric banded collar</li> <li>Button front Y-neck</li> <li>Grosgrain ribbon trim at inside sleeve placket</li> <li>Forward shoulders</li> <li>Front darts</li> <li>Curved hem</li> <li>Drop tail</li> <li>Cutter & Buck pennant on teh inside placket</li> <li>Micro geo all over pattern</li> <li>Embroidered Penn State logo</li> </ul>	[empty string]	N	65	65	L,XL,XS,DUMMYSIZE	14036-DEFAULT-s.jpg	1000	04147	3963	EMPTY	EMPTY	EMPTY	[empty string]	0	0	0	SHIRTS	cutter-buck/cb-ladies-micro-print-oxford-3963	1
8	[empty string]	NAVY,DUMMYCOLOR	BOXERCRAFT	Boxercraft	SPORTSWEAR	SPORTSWEAR &GT; PANTS &GT; SWEATPANTS	25	0	25	YES	14392-DEFAULT-l.jpg	[empty string]	25	14392-DEFAULT-m.jpg	Nittany Lion Flannel Pant	N	215	20-to-25	0.00	0	[empty string]	Boxercraft Flannel NIttany Lion Pant	<p> </p> <p><font size="+1"><b>Boxercraft Flannel NIttany Lion Pant</b></font></p> <ul> <li>Custom lion head design is unique to Lions Pride</li> <li>Features a covered elastic waistband with taping, no fly, no pockets</li> <li>Constructed from super-soft, 4 oz 100% cotton flannel</li> <li>Longer length and roomy cut</li> <li>Unisex Fit</li> </ul> <p> </p>	[empty string]	N	25	25	L,M,XL,S,XXL,DUMMYSIZE	14392-DEFAULT-s.jpg	1000	F19	3935	SWEATPANTS	EMPTY	EMPTY	[empty string]	0	0	0	PANTS	boxercraft/nittany-lion-flannel-pant-3935	1
9	[empty string]	NAVY,DUMMYCOLOR	BOXERCRAFT	Boxercraft	LADIES	LADIES &GT; PANTS &GT; SLEEPWEAR	29	0	29	YES	14394-DEFAULT-l.jpg	[empty string]	29	14394-DEFAULT-m.jpg	Ladies Lion Flannel Pant	N	225	25-to-50	0.00	0	[empty string]	Ladies Lion Flannel Pant	<p> <font size="+1"><b>BoxerCraft Ladies Lion Flannel Pant</b></font></p> <ul> <li>Custom Lion logo design is unique to Lions Pride</li> <li>Front accent pocket</li> <li>Stylish cuff</li> <li>2-button false fly</li> <li>Constructed from super-soft, 4 oz 100% cotton flannel</li> <li>Satin tie</li> </ul> <p> </p>	[empty string]	N	29	29	L,M,XL,S,DUMMYSIZE	14394-DEFAULT-s.jpg	1000	F16	3934	SLEEPWEAR	EMPTY	EMPTY	[empty string]	0	0	0	PANTS	boxercraft/ladies-lion-flannel-pant-3934	1
10	[empty string]	NAVY,DUMMYCOLOR	PING	Ping	SPORTSWEAR	SPORTSWEAR &GT; POLO SHIRTS &GT; SHORT SLEEVE &GT; PERFORMANCE	13	0	13	YES	13913-DEFAULT-l.jpg	[empty string]	65	13913-DEFAULT-m.jpg	Ping Hoizon Perf Stripe Polo	N	10	50-to-100	0.00	0	[empty string]	Ping Horizon Polo Shirt	<p><strong><span style="font-size: large;">Ping Horizon Stripe Polo Shirt</span></strong></p> <ul> <li><span style="font-size: small;">100% polyester</span></li> <li><span style="font-size: small;">Classic fit</span></li> <li><span style="font-size: small;">Sensor Cool technology</span></li> <li><span style="font-size: small;">Yarn dye fabric with gradient graphite stripe<br /> </span></li> <li><span style="font-size: small;">Self fabric collar</span></li> <li><span style="font-size: small;">Embroidered Penn State logo</span></li> </ul>	[empty string]	N	65	65	L,M,DUMMYSIZE	13913-DEFAULT-s.jpg	1000	14S1137NVY	3738	SHORT SLEEVE	PERFORMANCE	EMPTY	[empty string]	0	0	0	POLO SHIRTS	ping/ping-hoizon-perf-stripe-polo-3738	2
11	[empty string]	NAVY,DUMMYCOLOR	UNDER ARMOUR	Under Armour	LADIES	LADIES &GT; CREW SWEATSHIRTS &GT; QUARTER ZIP CREWS	65	0	65	YES	14053-DEFAULT-l.jpg	[empty string]	65	14053-DEFAULT-m.jpg	Ua Ladies Verve 1/2 Zip Crew	N	46	50-to-100	0.00	0	[empty string]	UA Ladies Verve 1/2 Zip Crew	<p> </p> <p><strong><span style="font-size: larger;">UA Ladies Verve 1/2 Zip Crew</span></strong></p> <ul> <li>94% polyester/ 6%spandex</li> <li>Super soft fabric delivers stretch and incredible next to skin comfort</li> <li>Comfortable 1/2 zip front for extra coverage and on demand ventilation</li> <li>Thumb holes keep sleeves secure and help seal in your body heat</li> <li>Drop tail enures extra coverage</li> </ul> <p> </p>	[empty string]	N	65	65	L,M,XL,S,DUMMYSIZE	14053-DEFAULT-s.jpg	1000	UW1291NVY	3528	QUARTER ZIP CREWS	EMPTY	EMPTY	[empty string]	0	0	0	CREW SWEATSHIRTS	under-armour/ua-ladies-verve-1-2-zip-crew-3528	2
12	[empty string]	WHITE,DUMMYCOLOR	UNDER ARMOUR	Under Armour	LADIES	LADIES &GT; HOODED SWEATSHIRTS &GT; HOODS	65	0	65	YES	13937-DEFAULT-l.jpg	[empty string]	65	13937-DEFAULT-m.jpg	Ua Ladies French Terry Hood	N	37	50-to-100	0.00	0	[empty string]	UA Ladies French Terry Hood	<FONT SIZE="+1"><B>UA Ladies French Terry Hood</B></FONT><UL><LI>93% polyester/ 7% spandex</LI><LI>Soft & super lightweight french terry fabric gives you warmth without weight</LI><LI>Two piece hood with cross over neck for enhanced comfort</LI><LI>Rib on cuffs, waistband and pockets</LI><LI>Thumbhole construction at cuff</LI></UL>	[empty string]	N	65	65	L,M,XL,S,DUMMYSIZE	13937-DEFAULT-s.jpg	1000	UW1578WHT	3518	HOODS	EMPTY	EMPTY	[empty string]	0	0	0	HOODED SWEATSHIRTS	under-armour/ua-ladies-french-terry-hood-3518	3
13	[empty string]	NAVY,DUMMYCOLOR	NIKE	Nike	HATS	HATS &GT; ADULT &GT; ADJUSTABLE	28	0	28	YES	13747-DEFAULT-l.jpg	[empty string]	28	13747-DEFAULT-m.jpg	Nike Performance Coaches Hat	N	44	10-to-15	0.00	0	[empty string]	Nike Performance Coaches Cap	<p><font size="+1"><b>Nike Performance Coaches Hat</b></font></p> <ul> <li>This is Simply the most comfortable hat you'll ever wear</li> <li>100% Dri-FIT polyester</li> <li>Pinnacle performance in Nike's wearable Legacy91 silhouette</li> <li>Features patented comfortbill construction that reduces weith and improves moisture management without looking too technical</li> <li>High density embroidery center front</li> <li>Swoosh design trademark embroidered on the bill</li> <li>Contrast binding and pop eyelets</li> <li>Hook and loop closure with a silicone grommet at back for a clean finish</li> </ul>	[empty string]	Y	14	14	ADJ,DUMMYSIZE	13747-DEFAULT-s.jpg	1000	29566NVY	3418	ADJUSTABLE	EMPTY	EMPTY	[empty string]	0	0	0	ADULT	nike/nike-performance-coaches-hat-3418	2
14	[empty string]	GRAY,DUMMYCOLOR	CHAMPION	Champion	SPORTSWEAR	SPORTSWEAR &GT; HOODED SWEATSHIRTS &GT; EMBROIDERED	65	0	65	YES	14200-DEFAULT-l.jpg	[empty string]	65	14200-DEFAULT-m.jpg	Champion Heritage Hood	N	13	25-to-50	0.00	0	[empty string]	Champion Heritage Hood	<FONT SIZE="+1"><B>Champion Heritage Hood</B></FONT><UL><LI>60% cotton/ 40% polyester heavyweight french terry with light brushing</LI><LI>Secondary pop of team color in jersey lined hood and draw cords</LI><LI>Rib side panels</LI></UL>	[empty string]	Y	32.5	32.5	L,M,XL,XXL,DUMMYSIZE	14200-DEFAULT-s.jpg	1000	CS1946GRY	3258	EMPTY	EMPTY	EMPTY	[empty string]	0	0	0	STAFF PICKS	champion/champion-heritage-hood-3258	1
15	[empty string]	As Shown,DUMMYCOLOR	BLAKEWAY	Blakeway	GIFTS	GIFTS &GT; OFFICE / EXECUTIVE &GT; WALL HANGINGS &GT; PRINTS	30	0	30	YES	13514-DEFAULT-l.jpg	[empty string]	30	13514-DEFAULT-m.jpg	2013 Homecoming Rolled Poster	N	10	25-to-50	0.00	3	[empty string]	2013 Homecoming Rolled Poster	<FONT SIZE="+1"><B>2013 Homecoming Rolled Poster</B></FONT><UL><LI>Print measures 40 x 13.5 inches</LI><LI>This panorama, taken by Christopher Gjevre, captures the excitement of the Penn State Nittany Lion fans as their team scores a touchdown during a sell-out homecoming game that ultimately resulted in a stunning win over Michigan at Beaver Stadium</LI><LI> Nittany Lion fans showed their Penn State pride and wore white at the game for the all-stadium white out, cheering their team to victory in the fourth overtime</LI></UL>	[empty string]	N	30	30	1 Size,DUMMYSIZE	13514-DEFAULT-s.jpg	1000	PSU4T	3245	WALL HANGINGS	PRINTS	EMPTY	[empty string]	0	0	0	OFFICE / EXECUTIVE	blakeway/2013-homecoming-rolled-poster-3245	1
16	[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	N	1	10-to-15	0.00	0	[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	EMPTY	EMPTY	EMPTY	[empty string]	0	0	0	HOME	rfsj/16oz-mk-matte-gray-logo-mug-2948	1
17	[empty string]	NAVY,DUMMYCOLOR	LEAGUE	League	LADIES	LADIES &GT; HOODED SWEATSHIRTS &GT; HOODS	49	0	49	YES	12951-DEFAULT-l.jpg	[empty string]	49	12951-DEFAULT-m.jpg	League Ladies Vs Hoody	N	24	25-to-50	0.00	0	[empty string]	League Ladies VS Hoody	<p><font size="+1"><b>League Ladies Victory Springs Hoody</b></font></p> <ul> <li>Tri Blend Fleece - 60% cotton/ 30% polyester/10% rayon</li> <li>A trendy new take on the 1/4 zip fleece</li> <li>Preppy with a vintage feel</li> <li>Screen printed logo</li> </ul>	[empty string]	N	49	49	L,XL,DUMMYSIZE	12951-DEFAULT-s.jpg	1000	TR100NVY	2559	HOODS	EMPTY	EMPTY	[empty string]	0	0	0	LEAGUE	league/league-ladies-vs-hoody-2559	3
18	[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	N	9999	150-to-200	0.00	42	[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
19	[empty string]	NAVY,DUMMYCOLOR	CUTTER BUCK	Cutter Buck	SPORTSWEAR	SPORTSWEAR &GT; SWEATERS	79	0	79	YES	12400-DEFAULT-l.jpg	[empty string]	79	12400-DEFAULT-m.jpg	Cutter + Buck 1/4 Zip Sweater	N	1	50-to-100	0.00	0	[empty string]	Cutter & Buck 1/4 Zip Sweater	<p><font size="+1"><b>Cutter & Buck 1/2 Zip Overtime Sweater</b></font></p> <ul> <li>100% cotton</li> <li>This half zip works overtime to keep you warm and fashionable at the same time.</li> <li>Features heathered flatback rib knit, 2x2 rib collar and cuff, contrast exposed zipper, forward shoulder, back yoke, and contrast cover stitching</li> <li>Embroidered Penn State logo</li> </ul>	[empty string]	N	79	79	L,DUMMYSIZE	12400-DEFAULT-s.jpg	1000	00492N	2129	QUARTER ZIP CREWS	EMPTY	EMPTY	[empty string]	0	0	0	WINTER GEAR	cutter-buck/cutter-buck-1-4-zip-sweater-2129	3
20	[empty string]	WHITE/NAVY,DUMMYCOLOR	STOUS	STOUS	GIFTS	GIFTS &GT; AUTO &GT; MAGNETS	3	0	3	YES	12283-DEFAULT-l.jpg	[empty string]	3	12283-DEFAULT-m.jpg	409 Magnet	N	41	5-and-under	0.00	0	[empty string]	5 3/4 x 3 3/8 inch 409 Magnet	<p><font size="+1"><b>5 3/4 x 3 3/8 inch 409 Magnet</b></font></p> <ul> <li>Perfect for just about anywhere. Car, office, tailgate grill or refrigerator.</li> </ul>	[empty string]	N	3	3	1 Size,DUMMYSIZE	12283-DEFAULT-s.jpg	1000	409-2997	1976	MAGNETS	EMPTY	EMPTY	[empty string]	0	0	0	PATERNO	stous/409-magnet-1976	1
21	[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	N	9999	150-to-200	0.00	0	[empty string]	Church Hill Photo Diploma Frame	<p><font size="+1"><b>Church Hill Photo Diploma Frame</b></font></p> <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>	[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
22	[empty string]	NAVY/WHITE,DUMMYCOLOR	BARBARIAN	Barbarian	SPORTSWEAR	SPORTSWEAR &GT; DRESS SHIRTS &GT; RUGBY	79	0	79	YES	12894-DEFAULT-l.jpg	[empty string]	79	12894-DEFAULT-m.jpg	Authentic Heavy- Weight Rugby	N	45	50-to-100	0.00	0	[empty string]	Authentic Heavy-weight Rugby	<p><font size="+1"><b>Authentic Heavy-weight Rugby</b></font></p> <ul> <li>Barbarian brand  preshrunk authentic cotton rugby shirt</li> <li>Embroidered lion head on front</li> <li>Concealed rubber buttons</li> </ul>	[empty string]	N	79	79	L,XL,XXS,XS,XXL,DUMMYSIZE	12894-DEFAULT-s.jpg	1000	STK	424	RUGBY	EMPTY	EMPTY	[empty string]	0	0	0	DRESS SHIRTS	barbarian/authentic-heavyweight-rugby-424	3

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