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

Travel Sweepstakes Are you seeking fun in the sun, a chance to see the sights of Europe, or an escape to exotic lands? You can use our travel sweepstakes category to find the dream vacation you're looking for. Enter to win a trip here- search through domestic vacations, international getaways, and relaxing cruises. Spin a globe and stop it randomly; we bet that wherever your finger landed, we have a vacation sweepstakes that could get you there. Look at these sweepstakes carefully. Some trips are all expenses paid and even include food and spending money, but others may only include airfare or accommodations.   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 Domestic VacationsInternational VacationsCruises     Delta Airlines Dream Trip Sweepstakes   Ending in 39 days (7-5-2012) Added 5-26-2012 Grand Prize (1) – Four day, three night trip for two to Finger Lakes Wine Coun [ read more... ] Domestic Vacations sweepstakes By: fingerlakeswinecountry.com Get The Gift of Speed Sweepstakes   Ending in 43 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 Enjoy The Game With Jesse Ortiz Sweeps   Ending in 21 days (6-17-2012) Added 5-25-2012 Enter to win one round of golf at the San Francisco Olympic Club, including a tw [ read more... ] Domestic Vacations sweepstakes By: bobbyjones.com Romney Victory Dine with the Donald   Ending in 26 days (6-22-2012) Added 5-25-2012 Twenty-five (25) potential winners will be chosen by random drawing at Romney fo [ read more... ] Domestic Vacations sweepstakes By: mittromney.com Womans Day Ivins UT Getaway Giveaway   Ending in 59 days (7-25-2012) Added 5-25-2012 Woman's Day is your source for healthy recipes, relationship advice and DIY home [ read more... ] Domestic Vacations sweepstakes By: womansday.com King Arthur Vermont Dream Giveaway   Ending in 34 days (6-30-2012) Added 5-25-2012 Enter to win a trip for 2 to Vermont, including airfare, hotel, private cooking [ read more... ] Domestic Vacations sweepstakes By: facebook.com Arby's Universal Orlando Sweepstakes   Ending in 16 days (6-12-2012) Added 5-25-2012 Enter to win a trip for 4 to Universal Orlando Resort in Orlando, Florida, inclu [ read more... ] Domestic Vacations sweepstakes By: arbyssweeps.com Aerosmith Live in LA Sweepstakes   Ending in 7 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 Ultimate Memphis Music Weekend Sweeps   Ending in 22 days (6-18-2012) Added 5-25-2012 Root for the drivers of two Elvis-themed cars at the 12th annual NHRA Thunder Va [ read more... ] Domestic Vacations sweepstakes By: elvis.com DRF Triple Crown Sweepstakes   Ending Tomorrow (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 «  1 1 2 3 4 5 6 7 8 9  10 11 12 13 14 15 16 17 18 19  20 21 22 23 24 »