Zaphir

Obavijest

     Trenutno radimo po dogovoru, a online narudžbe primamo 24 sata.

Kontakt: 385 91 3750 222

Yoga shop Prema Vama

 

PREMA VAMA d.o.o.

Ilica 315, 10000 Zagreb

info@premavama.com

www.premavama.com

T: +385-1-3750702

 

 

  • ZAPHIR-BLUE-MOON

    Zaphir Blue Moon

    380,00 Kn
    Dodaj u košaricu
  • ZAPHIR-CRYSTALIDE

    Zaphir Crystalide

    380,00 Kn
    Dodaj u košaricu
  • ZAPHIR-SUFI

    Zaphir Sufi

    380,00 Kn
    Dodaj u košaricu
  • ZAPHIR-SUNRAY

    Zaphir Sunray

    380,00 Kn
    Dodaj u košaricu
  • ZAPHIR-TWILIGHT

    Zaphir Twilight

    380,00 Kn
    Dodaj u košaricu
  • string(1610) "SELECT SQL_CALC_FOUND_ROWS wpv5_posts.ID FROM wpv5_posts LEFT JOIN wpv5_term_relationships ON (wpv5_posts.ID = wpv5_term_relationships.object_id) 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 ) LEFT JOIN wpv5_orbis_naturalsort_posts ON (wpv5_posts.ID = wpv5_orbis_naturalsort_posts.post_id) WHERE 1=1 AND wpv5_posts.ID NOT IN (2820,3256,3875,4257,4258,4259,4261,4262,4263,4275,4297,4298,4299,4300,4301,190,191,193,194,328,338,357,358,364,406,407,426,649,650,651,654,655,799,800,801,1002,1003,2461,2462,2463,2464,2473,2474,2475,2476,2528,2529,2818,2819,2833,2834,2835,2836,2837,2838,2934,3117,3123,3234,3240,3254,3877,5176) AND ( wpv5_term_relationships.term_taxonomy_id IN (276) ) AND ( ( ( wpv5_postmeta.meta_key = '_visibility' AND wpv5_postmeta.meta_value LIKE '{96176377a6e239ffb85c072574ad7a5f28a221e8d0b96a473ccc8d8126807fb5}visible{96176377a6e239ffb85c072574ad7a5f28a221e8d0b96a473ccc8d8126807fb5}' ) OR ( wpv5_postmeta.meta_key = '_visibility' AND wpv5_postmeta.meta_value LIKE '{96176377a6e239ffb85c072574ad7a5f28a221e8d0b96a473ccc8d8126807fb5}catalog{96176377a6e239ffb85c072574ad7a5f28a221e8d0b96a473ccc8d8126807fb5}' ) ) AND ( mt1.meta_key = '_stock_status' AND mt1.meta_value = 'instock' ) ) AND wpv5_posts.post_type IN ('product_variation', 'product') 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_orbis_naturalsort_posts.ns_title ASC, wpv5_posts.post_title ASC LIMIT 0, 30"