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 (19))) and ifnull(p.Featured,'') = '') Order by YEAR(p.Date) DESC, MONTH(p.Date) DESC, DAY(p.Date) DESC, p.webid desc

Events Sweepstakes For the outgoing sweeper: these sweepstakes are centered on specific events. This is your chance to win free concert tickets, get invited to movie premieres, attend prestigious awards ceremonies, meet and greet celebrities, and more. Some events get more attention than others- for example, Superbowl sweepstakes get tens of thousands of entries, while some concert sweepstakes don't get nearly as many. Events sweepstakes often include arrangements for travel to the locations where the events take place- but examine them closely, because some are intended for local audiences.   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 ConcertSportsMovieTheaterTelevision     Get The Gift of Speed Sweepstakes   Ending in 44 days (7-9-2012) Added 5-25-2012 Enter to win a 2013 Chevrolet Camaro ZL1 (ARV $58,000) and a trip for 2 to India [ read more... ] Cars sweepstakes By: wincamarozl1.com DRF Triple Crown Sweepstakes   Ending in 2 days (5-28-2012) Added 5-25-2012 Be there live as I’ll Have Another continues his historic run at the Triple Cr [ read more... ] Domestic Vacations sweepstakes By: drf.com Turner Sports Ryder Cup Sweepstakes   Ending in 69 days (8-3-2012) Added 5-21-2012 Enter to win a trip for 2 to the 2012 Ryder Cup at the Medinah Country Club in M [ read more... ] Domestic Vacations sweepstakes By: rydercup.com Frosted Flakes Share The Race Giveaway   Ending in 51 days (7-16-2012) Added 5-20-2012 Grand Prize: (2 winners) 4-day/3-night trip for winner and one guest to the Prof [ read more... ] Sports sweepstakes By: kelloggsracing.com Road Trip with the Dodgers Sweepstakes   Ending in -1 days (5-25-2012) Added 5-20-2012 PRIZES: One (1) prize (the “Prize”) will be awarded. The Prize will consist [ read more... ] Sports sweepstakes By: mlb.mlb.com Tinactin Tough Acts to Follow Giveaway   Ending in 188 days (11-30-2012) Added 5-19-2012 Prize: There is a total of one (1) prize available to be won in connection with [ read more... ] Sports sweepstakes By: toughactstofollow.com AT and T Perfect Storm Sweepstakes   Ending in 4 days (5-30-2012) Added 5-18-2012 Join AT&T in Las Vegas as the Pacific Typhoon meets the Desert Storm for a once [ read more... ] Domestic Vacations sweepstakes By: theperfectstormsweepstakes.com United Airlines Team USA Sweepstakes   Ending in 4 days (5-30-2012) Added 5-16-2012 Grand Prize (3): A [Five (5) day/[Four] (4) night trip for two (2) to London, En [ read more... ] Sports sweepstakes By: united.com Hurley U.S Open of Surfing Sweepstakes   Ending in 23 days (6-18-2012) Added 5-15-2012 Tillys.com, Shop the Latest Surf and Skate Clothing, Shoes and Accessories. Grea [ read more... ] Sports sweepstakes By: tillys.com Team Up With USA Basketball Sweepstake   Ending in 66 days (7-31-2012) Added 5-15-2012 Weekly Prize Winner Selection: Weekly Prize winners will be selected in twelve ( [ read more... ] Sports sweepstakes By: promo.espn.go.com «  1 1 2 3 4 5 »