Penn State Clothing and Nittany Lions Merchandise Shipped from State College, PA 1-800-462-0068

Welcome, Guest

Wish List


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 44 20-to-25 0.00 1 [empty string] Joe Paterno 409 Long Sleeve T <p>&nbsp;</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>&nbsp;</p> [empty string] N 22 22 L,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 32 5-and-under 0.00 3 [empty string] 4 Weeks 4 Thon T-Shirt <p><font size="+1"><b>4 Weeks 4 Thon T-Shirt</b></font></p> <ul> <li>Gildan 100% cotton uni-sex&nbsp; men's cut tee</li> <li>Screen printed logo on the front and the back</li> </ul> [empty string] Y 5 5 L,XL,S,XXL,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 47 25-to-50 0.00 1 [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>&nbsp;</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 23 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&nbsp;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 79 25-to-50 5.00 2 [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 138 25-to-50 0.00 0 [empty string] Nike Unrivaled PSFB Lng Slv T <p>&nbsp;</p> <p><strong><span style="font-size: larger;">Nike Unrivaled PS Football&nbsp; 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>&nbsp;</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 11 50-to-100 0.00 2 [empty string] CB Ladies Micro Print Oxford <p><strong><span style="font-size: larger;">Cutter &amp; 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 &amp; 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 209 20-to-25 0.00 0 [empty string] Boxercraft Flannel NIttany Lion Pant <p>&nbsp;</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>&nbsp;</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 220 25-to-50 0.00 0 [empty string] Ladies Lion Flannel Pant <p>&nbsp;<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>&nbsp;</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 65 0 65 YES 13913-DEFAULT-l.jpg [empty string] 65 13913-DEFAULT-m.jpg Ping Hoizon Perf Stripe Polo N 10 50-to-100 0.00 1 [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 41 50-to-100 0.00 1 [empty string] UA Ladies Verve 1/2 Zip Crew <p>&nbsp;</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>&nbsp;</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 1 [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 37 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 2 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 M,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 9 25-to-50 0.00 5 [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] 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 17 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
17 [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 12 [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
18 [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 28 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
19 [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 12 [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&quot; x 20&quot;.</li> <li>Fits an 8.5&quot; x 11&quot; diploma.</li> <br /> <font color="red"><b>NOTE</b> </font> <li>If this item is &quot;In Stock&quot; it will ship from Lions Pride in 1-2 business days</li> <li>If this item is listed as &quot;Drop Ship&quot; it means that the item will ship from the manufacturer</li> <li>You will need to allow 2-3 weeks for &quot;Drop Ship&quot; 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
20 [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 50 50-to-100 0.00 1 [empty string] Authentic Heavy-weight Rugby <p><font size="+1"><b>Authentic Heavy-weight Rugby</b></font></p> <ul> <li>Barbarian brand&nbsp; 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 0
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

Our Penn State Sports Blog

A Couple Falls and a Finalist After a sweep of the first round, a few Nittany Lions met their match in the second round of wrestling on Friday.  Senior 174 lbs. Matt Brown remains the only Penn State wrestler... View Full Article »
Matt Brown Makes the History Books

National Championship Saturday was a bit different than usual for the Penn State wrestling team. With only one wrestler in the finals and no chance of a team title... View Full Article »