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

Home Sweepstakes Home sweepstakes is the category where you will find giveaways for everything home and garden. Select the "Hardware" category to find sweepstakes for household and professional tools. "Kid Stuff" is where you'll find toys, games, educational materials, kids clothes, and more. Prizes for home sweepstakes tend to be items being promoted by their brands: cookware sets, coffee makers, various foods, almost anything you would expect to find in a house, so don't be afraid to look for specific household items you want to win. Odds against winning are not as steep in this category.   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 Food and DrinkHome and GardenKid StuffPet StuffHardwareBaby and Prenatal     Handyman Club Grill Giveaway   Ending in 8 days (6-3-2012) Added 5-25-2012 Handyman Club of America is a community of DIY home enthusiasts sharing projects [ read more... ] Home and Garden sweepstakes By: handymanclub.com Char-Griller Duo Sweepstakes   Ending in 18 days (6-13-2012) Added 5-24-2012 Enter to win a Char-Griller Duo S-5050 Gas & Charcoal Grill (ARV $299) or one of [ read more... ] Home and Garden sweepstakes By: facebook.com Eating Well Go Meatless Sweepstakes   Ending in 97 days (8-31-2012) Added 5-24-2012 Enter for a chance to win the Vitamix TurboBlend VS and the EatingWell Fast & Fl [ read more... ] Home and Garden sweepstakes By: eatingwell.com Win an EZ Stringer   Ending in 26 days (6-21-2012) Added 5-24-2012 Ez Stringer makes putting your drawstrings back in your clothes in seconds. [ read more... ] Clothing sweepstakes By: linkiescontestlinkies.com GET SUBMERGED $400 Adventure and Mys   Ending in 12 days (6-7-2012) Added 5-23-2012 GRAND PRIZE: Our Grand Prize winner will receive a Scuba Dive Pack.: an [ read more... ] Sporting Goods sweepstakes By: danipettrey.com Wet and Forget Backyard Sweepstakes   Ending in 97 days (8-31-2012) Added 5-23-2012 Enter to win a backyard prize package including outdoor dining set, Wireless Out [ read more... ] Home and Garden sweepstakes By: wetandforget.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 Food Network June Sweepstakes   Ending in 17 days (6-12-2012) Added 5-21-2012 Be one of 10 lucky winners to receive Bobby Flay’s Grill Topper, and 3-piece G [ read more... ] Home and Garden sweepstakes By: subscribe.hearstmags.com Hanover Party on the Patio Sweepstakes   Ending in 104 days (9-7-2012) Added 5-20-2012 Prize: (1 winner) Patio furnishings and accessories selected from among the in-s [ read more... ] Home and Garden sweepstakes By: partyonthepatio.capecodchips.com Flood Wood-Care Products Sweepstakes   Ending in 50 days (7-15-2012) Added 5-19-2012 In order to be eligible for entry into the Sweepstakes: i) you must be a legal p [ read more... ] Home and Garden sweepstakes By: flood.com «  1 1 2 3 4 5 6 7 8 »