Zaphir

  Radno vrijeme dućana

ponedjeljak, utorak, srijeda, četvrtak, petak od 15.00 do 19.00 sati

Online narudžbe primamo 24 sata

PREMA VAMA d.o.o.

Ilica 315, 10000 Zagreb

info@premavama.com

www.premavama.com

Mob. +385 97 7582 817

  • ZAPHIR-BLUE-MOON

    Zaphir Blue Moon

    50,00 
    Dodaj u košaricu
  • ZAPHIR-CRYSTALIDE

    Zaphir Crystalide

    50,00 
    Dodaj u košaricu
  • ZAPHIR-SUFI

    Zaphir Sufi - u dolasku

    50,00 
    Dodaj u košaricu
  • ZAPHIR-SUNRAY

    Zaphir Sunray

    50,00 
    Dodaj u košaricu
  • ZAPHIR-TWILIGHT

    Zaphir Twilight

    50,00 
    Dodaj u košaricu
  • string(2131) "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 ) 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 (183,184,223,224,225,226,282,283,284,285,325,334,335,336,347,348,588,589,590,591,592,983,985,991,993,1182,1184,1958,2753,2754,2755,2820,2940,2942,2948,2959,3003,3004,3005,3006,3047,3049,3051,3236,3238,3256,3633,3634,3636,3638,3750,3875,4257,4258,4259,4261,4262,4263,4275,4297,4298,4299,4300,4301,4368,4645,4646,4647,4648,4733,4734,5131,5149,5170,5278,5279,5280,5288,5445,5446,5447,5448,5467,5469,6125,6126,6127,190,191,193,194,239,291,292,293,294,295,321,322,323,324,328,331,338,349,357,358,364,374,375,376,406,407,426,602,603,604,605,649,650,651,654,655,666,667,668,669,763,764,765,766,767,769,770,771,772,783,784,799,800,801,992,1002,1003,1104,1105,1107,1108,1110,1112,1179,1181,1183,1202,1203,1959,2461,2462,2463,2464,2473,2474,2475,2476,2528,2529,2550,2551,2552,2818,2819,2833,2834,2835,2836,2837,2838,2934,2998,3117,3123,3234,3237,3240,3254,3301,3302,3305,3306,3307,3508,3509,3631,3747,3749,3834,3877,4367,4659,4829,5176,5864,5865,5866,5867,5946,6403,7217) AND ( wpv5_term_relationships.term_taxonomy_id IN (276) ) AND ( ( ( wpv5_postmeta.meta_key = '_visibility' AND wpv5_postmeta.meta_value LIKE '{5d829b611e7bb1aea7f97102b8a0a89cef09cfe22fd6fe03ec0d5d1421acf709}visible{5d829b611e7bb1aea7f97102b8a0a89cef09cfe22fd6fe03ec0d5d1421acf709}' ) OR ( wpv5_postmeta.meta_key = '_visibility' AND wpv5_postmeta.meta_value LIKE '{5d829b611e7bb1aea7f97102b8a0a89cef09cfe22fd6fe03ec0d5d1421acf709}catalog{5d829b611e7bb1aea7f97102b8a0a89cef09cfe22fd6fe03ec0d5d1421acf709}' ) ) ) 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"