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 (18))) 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     HDCamera and Greenies product Giveaway   Ending in 5 days (5-31-2012) Added 5-7-2012 PRIZES AND ODDS: Fifteen (15) Prizes (Three (3) per Drawing): each, (a) a high-d [ read more... ] Pet Stuff sweepstakes By: petco.greenies.com Greenies Smart Treating Sweepstakes   Ending in 219 days (12-31-2012) Added 5-5-2012 (1) Grand Prize: A one-year supply (awarded as coupons) of winner’s choice of: [ read more... ] Pet Stuff sweepstakes By: smarttreating.com SheKnows.Com My Perfect Pet Giveaway   Ending Tomorrow (5-27-2012) Added 5-4-2012 Sheknows.com, Helps Empower Women Through Articles And Discussion Related To Wom [ read more... ] Pet Stuff sweepstakes By: sheknows.com Macmillan A Dogs Journey Sweepstakes   Ending in 20 days (6-15-2012) Added 5-2-2012 Macmillan, Full US collection of fiction, nonfiction, and children’s book titl [ read more... ] Pet Stuff sweepstakes By: us.macmillan.com Invisible Fence Sweepstakes   Ending in 219 days (12-31-2012) Added 2-11-2012 Enter to win an Invisible Fence Brand Outdoor Solution for your pet. To put it s [ read more... ] Pet Stuff sweepstakes By: invisiblefence.com Nutro Pet Food Sweepstakes   Ending in 35 days (6-30-2012) Added 1-2-2012 Learn about NUTRO natural pet foods — natural dog food and natural cat food fr [ read more... ] Pet Stuff sweepstakes By: nutro.com Grit.Com Chick n Coop Giveaway   Ending in 8 days (6-3-2012) Added 12-22-2011 GRIT Magazine: Celebrating Rural America Since 1882. GRIT celebrates country lif [ read more... ] Pet Stuff sweepstakes By: grit.com