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=1212 and productid=cache_Products.productid) order by PublishDate desc
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
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
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
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
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
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
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