Magazine Sweepstakes | Sweepstakes on WinPrizesOnline.com

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

Magazine Sweepstakes Win Prizes Online brings you the best magazine sweepstakes from across the internet. We sift through hundreds of publications so you don't have to. This is the place to find all the sweepstakes offered in magazines such as Cosmo, Glamour, Elle, and OK! magazines. These sweepstakes offer all varieties of prizes: beauty products, tech, trips, and much more.

Sort By:	Entry:

Tickets to Lucky Magazine's NYC Gala

Ending in 145 days
(10-18-2012)

Added 10-11-2011

Two VIP tickets to Lucky Magazine's NYC Lucky Shops red carpet event for Lucky S [ read more... ]

Television sweepstakes
By: prettyconnected.com