Candy Magazine : Magazines

select ProductID,ProductName,ImagePath,Designer,SalePrice,Price, GRoupID,PreOrder,0 as LC,(select top 1 TypeID from mss_Types where TypeID in (select typeid from mss_types where [sign]='DESIGNERS') and TypeID in (select TypeID from mss_Index where ProductID=cache_products.ProductID)) AS DesignerID from cache_Products where (publishdate < getdate() or publishdate is null) and 1=1 and exists (select top 1 1 from mss_index where typeid=1 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=1043 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=1212 and productid=cache_Products.productid) order by PublishDate desc
PREVIOUS NEXT : 1~2 OF 2 ITEMS

Candy Magazine News:

5
  • Thu, December 20, 2012
    The holiday season is upon us, and this year it's time to HOLIDAY YOUR WAY ! We asked publishing intellectual and creator of Candy magazine (get your copy of #5 here )  Luis Venegas  to curate a list of perfect holiday gifts. ... MORE

  • Thu, June 28, 2012
    Hide your wives, hide your husbands because Electric Youth!  #8 is on its way to OC! Shot entirely by photographer Xevi Muntané (who is responsible for THAT cover) and with digital art by  CLOAQUE , the issue is dedicated to Spain's ... MORE

  • Tue, June 26, 2012
    Once a week in Silver Lake, LA, Ivory and OCLA's Michelangelo teach others about astrology. Now, at the turn of every sign, these two stargazers are here to offer us advice on love, life, sex, and fashion. CANCER Warrior you are... ... MORE

  • Thu, June 30, 2011
    Consistently setting a new creative standard and doing it all the way from Madrid, the publishing extraordinaire Luis Venegas has just unleashed his latest issues of Fanzine137  and  Electric YouTH! MAGATEEN ! The last time he fed us his ... MORE

  • Tue, February 8, 2011
    Just in time for Valentines Day, Acne's Johnny Johansson and Candy Magazine 's E.I.C, Luis Venegas , team up to bring you a sweet-as-candy capsule collaboration. ... MORE

  • Mon, January 24, 2011
    Last night saw the first ever Acne men's runway show in Paris on the Boulevard de la Bastille. A very jovial crowd with a Swedish twist enjoyed the musical stylings of Abba, champagne on ice, and delicacies from the Sarl King Hot Dog stand--not so ... MORE

  • Wed, October 6, 2010
    To those of you who know of OC's sWEET TOOTH these days, it probably comes as no surprise that Luis Venegas has what we crave. ... MORE

  • Wed, December 30, 2009
    If you’re looking for girls who are boys, who like boys to be girls, who do boys like they’re girls, and girls like they’re boys – then you’ve come to the right place. ... MORE


ecommerce web design web development