Akcije

OBAVIJEST

Cijenjeni kupci ,

Dana 12.12.2017. nećemo raditi.

Hvala na razumijevanju

Yoga shop Prema Vama

      Kontakt: 

info@premavama.com

     +385(1)3750 702 

       +385(0)91 3750 222

Prikazuje se jedan rezultat

  • Akcija! Zen-zvono

    Peter Hess® ZEN zvono

    400,00 Kn 320,00 Kn
    Dodaj u košaricu
  • string(1260) "SELECT SQL_CALC_FOUND_ROWS wpv5_posts.ID FROM wpv5_posts INNER JOIN wpv5_postmeta ON ( wpv5_posts.ID = wpv5_postmeta.post_id ) INNER JOIN wpv5_postmeta AS mt1 ON ( wpv5_posts.ID = mt1.post_id ) WHERE 1=1 AND wpv5_posts.ID IN (0,644) AND ( ( ( wpv5_postmeta.meta_key = '_visibility' AND wpv5_postmeta.meta_value LIKE '{4a37b504a4e7b39084b1818d22a3e37237f96b369561a4e486969834cbb06923}visible{4a37b504a4e7b39084b1818d22a3e37237f96b369561a4e486969834cbb06923}' ) OR ( wpv5_postmeta.meta_key = '_visibility' AND wpv5_postmeta.meta_value LIKE '{4a37b504a4e7b39084b1818d22a3e37237f96b369561a4e486969834cbb06923}catalog{4a37b504a4e7b39084b1818d22a3e37237f96b369561a4e486969834cbb06923}' ) OR ( wpv5_postmeta.meta_key = '_visibility' AND wpv5_postmeta.meta_value LIKE '{4a37b504a4e7b39084b1818d22a3e37237f96b369561a4e486969834cbb06923}filtered{4a37b504a4e7b39084b1818d22a3e37237f96b369561a4e486969834cbb06923}' ) ) AND ( mt1.meta_key = '_stock_status' AND mt1.meta_value = 'instock' ) ) AND wpv5_posts.post_type IN ('product', 'product_variation') AND (wpv5_posts.post_status = 'publish' OR wpv5_posts.post_status = 'acf-disabled') GROUP BY wpv5_posts.ID ORDER BY wpv5_posts.menu_order ASC, wpv5_posts.post_title ASC LIMIT 0, 30"