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 (43))) 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     R. Kelly Love Letter Cruise Sweeps   Ending in 32 days (6-28-2012) Added 5-24-2012 Enter to win one of six cruises for two aboard the Carnival Destiny for the R. K [ read more... ] Cruises sweepstakes By: thesweathotel.com Smooth Jazz Cruise Cabin Giveaway   Ending in 2 days (5-29-2012) Added 5-14-2012 As part of its celebration of Jazz Appreciation Month in April, Watercolors pres [ read more... ] Cruises sweepstakes By: siriusxm.com Fun on Deck Sweepstakes   Ending in 6 days (6-2-2012) Added 4-25-2012 Discover magical Disney Cruise Line vacations with unique cruise activities for [ read more... ] Cruises sweepstakes By: funondeckcruise.com Discover Salty Treasure Sweepstakes   Ending Today (5-27-2012) Added 4-23-2012 Bugles has been a snack treat for the whole family spanning six decades. Enter t [ read more... ] Cruises sweepstakes By: snackcruisegiveaway.com ScubaDiving Aqua Cat Cruise Sweepstake   Ending in 48 days (7-14-2012) Added 3-18-2012 Scuba Diving covers the latest in scuba diving gear, dive travel and scuba divin [ read more... ] Cruises sweepstakes By: scubadiving.com AMEX Spring Travel Sweepstakes   Ending in 4 days (5-31-2012) Added 3-13-2012 This month, American Express Travel is giving away a cruise from Royal Caribbean [ read more... ] Cruises sweepstakes By: f.email.americanexpress.com