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 (20))) 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     Schwinn Ride of Lifetime Sweepstakes   Ending in 30 days (6-25-2012) Added 5-25-2012 Enter to win the perfect Schwinn product for a friend and if they win, Schwinn w [ read more... ] Sporting Goods sweepstakes By: schwinnbikes.com GET SUBMERGED $400 Adventure and Mys   Ending in 12 days (6-7-2012) Added 5-23-2012 GRAND PRIZE: Our Grand Prize winner will receive a Scuba Dive Pack.: an [ read more... ] Sporting Goods sweepstakes By: danipettrey.com Win NRA prize pack Giveaway   Ending Tomorrow (5-27-2012) Added 5-23-2012 Prize 7 Guns in 7 Days Grand Prize : Seven (7) individuals will win one (1) NRA [ read more... ] Sporting Goods sweepstakes By: thesportsmanchannel.com Win NordicTrack Incline Trainer X9i   Ending in 26 days (6-21-2012) Added 5-22-2012 The Men's Guide To Fitness, Sex, Women, Workouts, Weight Loss, Health, Nutrition [ read more... ] Sporting Goods sweepstakes By: menshealth.com Golfs Metal X Roll Call Sweepstakes   Ending in 20 days (6-15-2012) Added 5-20-2012 Prize: Upon certification by Sponsor as an eligible participant, the winner will [ read more... ] Sporting Goods sweepstakes By: odysseygolf.com SmartSource Summer Blast Off Giveaway   Ending in 16 days (6-11-2012) Added 5-19-2012 Prize: (1 winner) Outdoor dining set consisting of one table, umbrella, base, an [ read more... ] Sporting Goods sweepstakes By: smartsourcesamples.com Seventeen Schwinn Sweepstakes   Ending in 37 days (7-2-2012) Added 5-16-2012 Explore all the categories of Schwinn Bikes including Road, Urban, Hybrid, Mount [ read more... ] Sporting Goods sweepstakes By: seventeen.com Timex Sports Watch Giveaway   Ending in 37 days (7-2-2012) Added 5-16-2012 For more than 150 years, Timex has focused on quality, value and timeless style. [ read more... ] Sporting Goods sweepstakes By: seventeen.com Fit Club Wilson Sweepstakes   Ending in 37 days (7-2-2012) Added 5-16-2012 Five winners! Enter to win a Juice 100 tennis racket, a Juice Tour backpack, a s [ read more... ] Sporting Goods sweepstakes By: seventeen.com American Way Mongoose Sweepstakes   Ending in 5 days (5-31-2012) Added 5-16-2012 With May being National Bike Month, there’s no better time to head to the grea [ read more... ] Sporting Goods sweepstakes By: entry.aapsecure.com «  1 1 2 3 4 »