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

Health & Beauty Sweepstakes Spa services, salon hair and skincare products, and gym memberships are just some examples of prizes you can enter to win in our health and beauty sweepstakes category. These prizes appeal to a small niche- making chances of winning a health and beauty sweepstakes relatively healthy. Though the value of the prizes may be smaller, the quality of the products offered is often top notch. Most of these sweepstakes allow one entry, so finish them up and move on to the next!   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 Health and Beauty     Beauty Awards Body Care Sweepstakes   Ending in 32 days (6-27-2012) Added 5-25-2012 Prize: (5 winners) All twelve body care beauty award products mentioned in the J [ read more... ] Health and Beauty sweepstakes By: prevention.com Win Vecco product Sweepstakes   Ending in 203 days (12-15-2012) Added 5-23-2012 A total of seven (7) prizes (1 per entry period) will be awarded. During each en [ read more... ] Health and Beauty sweepstakes By: veccostudio.com Lifetime Moms Make it Happen Sweeps   Ending in 23 days (6-18-2012) Added 5-23-2012 Enter to win $2,500 cash and an assortment of beauty products. Weekly prizes: [ read more... ] Cash sweepstakes By: sweepstakes.lifetimemoms.com Allure Minnie Inspiration Sweepstakes   Ending in 30 days (6-25-2012) Added 5-23-2012 Enter to win spa services at a spa or salon chosen by the Sponsors in or near th [ read more... ] Health and Beauty sweepstakes By: allureaccess.com Womans World Waterpik Giveaway   Ending in 55 days (7-20-2012) Added 5-22-2012 Water Pik, Inc. is celebrating fifty years of innovation, and to mark this miles [ read more... ] Health and Beauty sweepstakes By: winit.womansworldmag.com Jessica Alba Cover Look Sweepstakes   Ending in 35 days (6-30-2012) Added 5-22-2012 Marie Claire magazine, the publication that women turn to for information on fas [ read more... ] Health and Beauty sweepstakes By: marieclaire.com Womans Worlds BeWell and Win Giveaway   Ending in 17 days (6-12-2012) Added 5-22-2012 Prize: (1 winner) Pair of tickets to the BeWell Expo in Los Angeles; and $1,200 [ read more... ] Health and Beauty sweepstakes By: winit.womansworldmag.com Selena Gomez Perfume Giveaway   Ending in 37 days (7-2-2012) Added 5-18-2012 25 lucky winners will win a bottle of Selena Gomez perfume (ARV $55)! CODE WORD [ read more... ] Health and Beauty sweepstakes By: seventeen.com Lush Skin Care Sweepstakes   Ending in 16 days (6-11-2012) Added 5-17-2012 Thirty Redbook readers will each win a gift card to spend on the all-natural ski [ read more... ] Health and Beauty sweepstakes By: redbookmag.com Suave Hair Products Gift Basket   Ending in 10 days (6-5-2012) Added 5-17-2012 Winner receives a gift basket full of Suave Professionals hair care products, in [ read more... ] Health and Beauty sweepstakes By: therealmomreview.blogspot.com «  1 1 2 3 4 5 »