Coș cumpărături
Coș cumpărături
Suport Clienți: 0773.771.771 si 0773.774.774 Luni - Vineri 08:00 - 16:30

Categorii produse

Cupa 8312

Alege varianta

Cod produsDimPrețStoc
8312H-K15.5 cm14.58 RON Da
8312F-K20 cm21.6 RON Da
8312E-K21.5 cm24.3 RON Da
8312C-K24.5 cm28.8 RON Da
8312A-K30 cm45.9 RON Da
8312G-K17.5 cm16.38 RON Nu

Opțiune personalizare produs

Preț: 16.2 14.58 RON/buc.
Economisiți : 1.62 RON
Promoția expiră în
Cod produs: 8312H-K

RemoveAdd

Detalii

Cupa realizata din metal cu insertie din plastic si baza de marmura.

Aceasta cupa se personalizeaza cu textul trimis de dvs.
Personalizarea se face pe placuta de metalex gravata laser.

Error: MYSQL ERROR:

SELECT DISTINCT prod.no_mlm_credit_for_this,prod.is_voucher,
					   prod.ws_contact_for_price,prod.not_discountable,
					   prod.min_cant_um1_pr_comenzi_os,prod.oversell,prod.um2_factor,
					   prod.cod_varianta,
					   prod.product_group_title,
					   prod.product_group_title,
					   prod.meta_kw,
					   prod.meta_kw,
					   prod.is_new,
					   prod.ordercol,
					   prod.meta_description,
					   prod.meta_description,
					   img.rec_id as img_id,img.file_name,img_desc.description_text,
					   um.den as um1_txt,um2.den as um2_txt,
					   sts.status_text as sts_text,
					   prod.product_group_description,
					   prod.product_short_description,
					   prod.producator_txt,prod.producator_id,
					   pr_publ_index.is_promo,
					   prod.last_modified_ts,
					   prod.ws_badge_id,
					   IF(npnpromo.rec_id IS NOT NULL,1,0) AS has_npn_promo,
					   npnpromo.promo_name AS npn_promo_name,
					   npnpromo.nr_condition_products_in_cart AS npn_nr_condition_products_in_cart,
					   npnpromo.nr_produse_bonus AS npn_nr_produse_bonus,
					   warr.txt AS warranty_period
					   
					   ,ccind3.*
					   
					    ,cate.parents_cache AS cat_parents_cache,cate.category_name, cate.rec_id AS web_cat_id, cate.google_category_id 

				FROM product_groups_777 AS prod
				JOIN product_site_publication_index_777 AS pr_publ_index
					ON pr_publ_index.product_id=prod.cod_varianta AND pr_publ_index.is_published
						AND pr_publ_index.site_id = '81'
				LEFT JOIN cat_produse_web_index_777 as cwpi ON cwpi.product_id=prod.cod_varianta
				LEFT JOIN poze_produse_777 AS img ON prod.cod_varianta=img.produs_id 
															AND NOT img.hidden
															AND img.poza_principala
				LEFT JOIN images_descriptions_777 AS img_desc on img_desc.image_id=img.rec_id
				LEFT JOIN UM_777 AS um ON um.rec_id=prod.um1_id
				LEFT JOIN UM_777 AS um2 ON um2.rec_id=prod.um2_id
				LEFT JOIN fisademagazie_stoc_statuses_777 AS sts ON sts.rec_id=prod.status_id
				LEFT JOIN sale_promo_nplusone_condition_products_777 AS promo_cond_prod
					ON promo_cond_prod.cod_varianta = prod.cod_varianta
				LEFT JOIN sale_promo_nplusone_777 AS npnpromo
					ON npnpromo.rec_id = promo_cond_prod.promo_id
						AND npnpromo.active
						AND NOT npnpromo.archived
						AND NOW() BETWEEN npnpromo.promo_start AND npnpromo.promo_end
				LEFT JOIN warranty_periods_777 AS warr
					ON warr.rec_id = prod.warranty_period_id
				 JOIN categorii_produse_web_777 AS cate
					ON cwpi.cat_id=cate.rec_id 
						AND NOT cate.cat_deleted 

				WHERE NOT prod.deleted AND
				((1  AND cwpi.cat_id IN (26)) )
				GROUP BY prod.cod_varianta
				ORDER BY  RAND() LIMIT 0,5


Unknown table 'bocp_777_ivparhivsrl.ccind3'