0

SELECT p.webid, trim(p.Title) as Title, REPLACE(trim(p.Title),' ', '-') as CleanTitle, p.Prize, p.chances, p.Sponsor, p.Prize_value, p.URL, q.type as Entry, p.enter, datediff(p.Date, curdate()) as DateAdded, p.Expire as Expire_IN, datediff(Expire, curdate()) as Expire , concat(month(p.Expire),'-',day(p.Expire), '-', year(p.Expire)) as EndDate, concat(month(p.Date),'-',day(p.Date), '-', year(p.Date)) as Date, p.prizecat, p.type_form, p.chances, p.image_thumb, p.image, p.instant, p.blog, ifnull(p.Featured,'') as Featured, p.votes AS user_rating, 'sweepstakes' as OfferText, ifnull(FavTest.webid, '') as MyFavTest, (Select Name from ItemsCategories xC Inner join categories yC on (xC.categoryid = yC.categoryid) where p.webid = xC.webid limit 1) as CatTitle , 0 as Fav, p.domain FROM prizetune_website p Inner join winprizes_types q on (p.Entry = q.id and q.group_id = '1' and 4=4) Left Join prizetune_saved FavTest on (FavTest.webid = p.webid and FavTest.userId=0) Where ( p.Expire>='2012-05-25' AND p.status='u' AND p.exstatus='y' and p.OfferType = 1 And p.webid in (Select x.webid from ItemsCategories x where ( p.webId = x.WebId and x.CategoryID in (14))) and ifnull(p.Featured,'') = '') Order by YEAR(p.Date) DESC, MONTH(p.Date) DESC, DAY(p.Date) DESC, p.webid desc

Hobby Sweepstakes Hobby sweepstakes come in just about all shapes and sizes. These sweepstakes offer prizes from collector\'s items, sports and music equipment, and video games, as well print and digital media- but this barely scratches the surface. If you can call it a hobby, someone out there holding a sweepstakes related to it, and Win Prizes Online will find it and bring it to you. Since hobby sweepstakes attract mostly passionate enthusiasts of particular hobbies, look for what you love and enter for a chance to win, because odds are decent in this category.   Sort By:  Entry Date Expiration Date Rating Most Popular Prize Value (ARV) Chances   Entry:  Show All Enter Free One Time OnlyEnter Free DailyEnter Free WeeklyEnter Free MonthlyUnlimited Free Entries Prize Type:  Show All CDs and DVDsMemorabilia and CollectiblesMusical ItemsSporting GoodsVideo GamesBooks and Magazines     Moonrise Kingdom Sweepstakes   Ending in 34 days (6-29-2012) Added 5-25-2012 Landmark Theatres is America's largest theatre circuit dedicated to independent [ read more... ] Memorabilia and Collectibles sweepstakes By: facebook.com Slash Autographed Guitar Giveaway   Ending in 37 days (7-2-2012) Added 5-24-2012 Apocalyptic Love is the second studio album by current Velvet Revolver and forme [ read more... ] Memorabilia and Collectibles sweepstakes By: gohastings.com Prometheus Directors Chair Giveaway   Ending in 15 days (6-10-2012) Added 5-24-2012 Enter to win a Custom Sir Ridley Scott Director's Chair signed by Ridley Scott ( [ read more... ] Memorabilia and Collectibles sweepstakes By: amctheatres.com Chernobyl Diaries Sweepstakes   Ending in 8 days (6-3-2012) Added 5-22-2012 Chernobyl Diaries is an original story from Oren Peli, who first terrified audie [ read more... ] Memorabilia and Collectibles sweepstakes By: amctheatres.com Carlos Santana Sweepstakes   Ending in 2 days (5-28-2012) Added 5-18-2012 On his brand new record, SHAPE SHIFTER, Carlos Santana brings his masterful guit [ read more... ] Memorabilia and Collectibles sweepstakes By: recordstoreday.com Ashley Tisdale Cell Phone giveaway   Ending in 5 days (5-31-2012) Added 3-26-2012 -14 stands for Just For Teens. An exciting, interesting teen magazine for girls. [ read more... ] Gadgets sweepstakes By: winit.j-14.com David Archuleta iPod Shuffle Giveaway   Ending in 5 days (5-31-2012) Added 3-26-2012 J-14 is a monthly teenage magazine marketed at young preteen and teenage girls. [ read more... ] Gadgets sweepstakes By: winit.j-14.com Great Clips Racing Giveaway   Ending in 188 days (11-30-2012) Added 3-5-2012 Haircare services from Great Clips. We provide quality, no-appointment haircuts [ read more... ] Memorabilia and Collectibles sweepstakes By: greatclips.com Ariana Grande's Signed Journal Sweeps   Ending in 27 days (6-22-2012) Added 2-29-2012 M Magazine is a monthly teen magazine. Enter to win Ariana Grande's signed journ [ read more... ] Memorabilia and Collectibles sweepstakes By: winit.mmm-mag.com Bad to the Bone For 30 Years Sweeps   Ending in 219 days (12-31-2012) Added 1-16-2012 All year long we are celebrating Grave Diggers 30th Anniversary! So on the 30th [ read more... ] Memorabilia and Collectibles sweepstakes By: fs3.formsite.com