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 (21))) 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     Win 1 of 19 Copies of Pearl Mountain   Ending in 13 days (6-8-2012) Added 5-17-2012 This giveaway is open worldwide and there are 19 Copies to giveaway. Prize valu [ read more... ] Computers and Accessories sweepstakes By: linkiescontestlinkies.com FatMAXed SuperPack   Ending in 18 days (6-13-2012) Added 5-15-2012 Enter to win the Stanley Fat MAXed Super Pack by filling out the entry form. Dea [ read more... ] Hardware sweepstakes By: apps.facebook.com Propane Water Heater Contest   Ending in 27 days (6-22-2012) Added 4-21-2012 Simply the cleanest, greenest, and most convenient way to enjoy hot water on the [ read more... ] Hardware sweepstakes By: apps.facebook.com GOJO Tool Chest Giveaway   Ending in 19 days (6-14-2012) Added 3-12-2012 GOJO is celebrating American workers, the folks who don't let dirt and grease ge [ read more... ] Hardware sweepstakes By: toughsoils-promotions.gojo.com Win Workshop Makeover Sweepstakes   Ending in 65 days (7-30-2012) Added 12-3-2011 Get Woodworking Tips, Techniques, Project Plans, Tool Reviews, and Woodworking V [ read more... ] Hardware sweepstakes By: popularwoodworking.upickem.net