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 (16))) 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     Aerosmith Live in LA Sweepstakes   Ending in 8 days (6-3-2012) Added 5-25-2012 Aerosmith’s Global Warming Tour is heading to Los Angeles this August and Ryan [ read more... ] Domestic Vacations sweepstakes By: ryanseacrest.com Big and Rich That's Why I Pray Sweeps   Ending in 3 days (5-29-2012) Added 5-24-2012 Enter to win a trip to the CMA's to walk the red carpet with Big and Rich. Incl [ read more... ] Domestic Vacations sweepstakes By: crookandchase.com Corona Mana Concert Trip Sweeps   Ending in 66 days (7-31-2012) Added 5-23-2012 Would you like to attend a special Maná concert experience in Las Vegas with th [ read more... ] Domestic Vacations sweepstakes By: coronaextrausa.com TODAY and DailyCandy NYC Getaway   Ending in 6 days (6-1-2012) Added 5-22-2012 PRIZE: There will be one (1) prize awarded (“Prize”) to Winner. Prize will c [ read more... ] Concert sweepstakes By: today.com Americana Music Festival Sweepstakes   Ending in 55 days (7-20-2012) Added 5-21-2012 Enter to win a trip for 2 to the nnual Americana Music Festival in Nashville, TN [ read more... ] Domestic Vacations sweepstakes By: visitmusiccity.com Summer With The Star Sweepstakes   Ending in 9 days (6-4-2012) Added 5-21-2012 Enter to win a trip for 4 to Punta Cana, Dominican Republic, including airfare, [ read more... ] Concert sweepstakes By: summerwiththestars.com ESSENCE Music Festival Sweepstakes   Ending in 39 days (7-4-2012) Added 5-20-2012 PRIZE AND ITS APPROXIMATE RETAIL VALUE (“ARV”): One (1) Grand Prize: A 4 day [ read more... ] Concert sweepstakes By: essencefestbest.venturaassociates.net Air Supply Ultimate Fan Giveaway   Ending in 44 days (7-9-2012) Added 5-19-2012 One lucky winner will have the chance to win 2 tickets to see Air Supply perform [ read more... ] Concert sweepstakes By: apps.facebook.com Country Music Fantasy Sweepstakes   Ending in 2 days (5-28-2012) Added 5-17-2012 Enter to win a trip for 2 to Nashville, TN to attend the CMT Music Awards, June [ read more... ] Domestic Vacations sweepstakes By: cmt.com Nickelback in Las Vegas Flyaway   Ending in 5 days (5-31-2012) Added 5-16-2012 PRIZES One (1) Grand Prize for two (2) people: Tickets to see Nickelback in Las [ read more... ] Concert sweepstakes By: myhitsongsonline.com «  1 1 2 3 4 »