SELECT DISTINCT `main_table`.*, `6u0_clnews_news_category`.`category_id`, `6u0_clnews_category`.`path` FROM `6u0_clnews_news` AS `main_table`
 LEFT JOIN `6u0_clnews_news_category` ON main_table.news_id = 6u0_clnews_news_category.news_id
 LEFT JOIN `6u0_clnews_category` ON 6u0_clnews_news_category.category_id = 6u0_clnews_category.category_id
 INNER JOIN `6u0_clnews_news_store` AS `news_store_table` ON main_table.news_id = news_store_table.news_id WHERE (6u0_clnews_news_category.category_id IN (3) OR ((INSTR(6u0_clnews_category.path,'/3/')  > 1) OR (INSTR(6u0_clnews_category.path,'3/')  = 1))) AND (news_store_table.store_id in ('2', 0)) AND (status = 1) AND (((((`publicate_from_time` <= '2020-04-05 09:38:31') OR (`publicate_from_time` IS null))))) AND (((((`publicate_to_time` >= '2020-04-05 09:38:31') OR (`publicate_to_time` IS null))))) ORDER BY news_time DESC LIMIT 40 OFFSET 80

Events & News


Fair "Skin & Beauty" 2016 in Scandinavia

9/6/2016  |  Eventi & News

Our distributor in Sweden, "Grevinnans Rum AB", will participate with the products Prima Spremitura at the twentieth anniversary of the event "Skin & Beauty" on 8-9 September 2016 in Stockholm, Scandinavia.

www.hudochkosmetikmassan.se

http://www.grevinnansrum.se/


Need some help?
Write us on whatsapp

Contact Us on WhatsApp: +39 340 8792491