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 (17))) 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     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 Alex de Grassi Signature Sweepstakes   Ending in 66 days (7-31-2012) Added 5-22-2012 Don't miss your chance to follow in a master fingerstylist's footsteps! One luck [ read more... ] Musical Items sweepstakes By: acousticguitar.com Win Jackson X Series Guitar Giveaway   Ending in 33 days (6-28-2012) Added 5-20-2012 PRIZES. The first six names selected in the Drawing will be deemed to be the pot [ read more... ] Musical Items sweepstakes By: jacksonguitars.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 Triple Telecaster Giveaway   Ending in 50 days (7-15-2012) Added 5-14-2012 Enter to win one of three Telecaster guitars - Baja Telecaster guitar, American [ read more... ] Musical Items sweepstakes By: proguitarshop.com Zager Acoustic Guitar Sweepstakes   Ending in 13 days (6-8-2012) Added 5-13-2012 If you're about to spend $3000+ on a high dollar acoustic, do yourself a favor a [ read more... ] Musical Items sweepstakes By: premierguitar.com EVH Eddie Van Halen Amp Sweepstakes   Ending in 10 days (6-5-2012) Added 5-13-2012 Here’s your chance to win an EVH 5150III 100-watt amp head autographed by Eddi [ read more... ] Musical Items sweepstakes By: evhgear.com Dano Pro Electric Guitar Giveaway   Ending in 5 days (5-31-2012) Added 5-9-2012 The Dano Pro Electric Guitar is a first-ever reissue based on the guitar model f [ read more... ] Musical Items sweepstakes By: guitarworld.com Fender Squire Giveaway   Ending in 23 days (6-18-2012) Added 5-9-2012 Squier is going to pick out ten grand-prize winners, each of whom will pick out [ read more... ] Musical Items sweepstakes By: fender.com REO Speedwagon Rock Icons Sweeps   Ending in 35 days (6-30-2012) Added 5-9-2012 Yamaha F325 full-size acoustic guitar autographed by the current lineup of REO [ read more... ] Musical Items sweepstakes By: goldminemag.com «  1 1 2 3 »