articole de pescuit Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

transport gratuit Transport Gratuit

Comenzile peste 400 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

plata in rate Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

suport Suport 10-18

Suportul telefonic este 10-18. Orice intrebare ai avea, stim ca nu poate astepta. Apeleaza serviciul Suport 10-18! Un consultant asteapta sa iti preia apelul in intervalul orar 10-18 de luni pana vineri.

Vezi mai multe detalii

returnare Returnare simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


CIORAPI PRIMAVERA SPRING LIGHT SCURTI DRYARN MARIMEA 39-42
Exclusiv online!

CIORAPI PRIMAVERA SPRING LIGHT SCURTI DRYARN MARIMEA 39-42

vp.657.39
Livrare 24-48 ore

30,90Lei

JACHETA VERNEY-CARRON IBEX KAKI MARIMEA XL
Exclusiv online!

JACHETA VERNEY-CARRON IBEX KAKI MARIMEA XL

lvc.phve001.xl
Livrare 24-48 ore

1.159,29Lei

CIORAPI DRYARN LUNGI PRIMAVERA SPRING THERMAL MARIMEA 39 42

CIORAPI DRYARN LUNGI PRIMAVERA SPRING THERMAL MARIMEA 39 42

vp.954.39
Livrare imediată!

53,84Lei

BLUZA FIRST LAYER PRIMAVERA SPRING DRYARN MARIMEA XL
Exclusiv online!

BLUZA FIRST LAYER PRIMAVERA SPRING DRYARN MARIMEA XL

vp.53.xl
Livrare 24-48 ore

116,81Lei

JACHETA BROWNING HELLS CANYON 2 KHAKI MARIMEA 2XL
Exclusiv online!

JACHETA BROWNING HELLS CANYON 2 KHAKI MARIMEA 2XL

bo.30498637.2xl
Livrare 24-48 ore

606,10Lei

CIORAPI PRIMAVERA SPRING LIGHT SCURTI DRYARN MARIMEA 43-46
Exclusiv online!

CIORAPI PRIMAVERA SPRING LIGHT SCURTI DRYARN MARIMEA 43-46

vp.657.43
Livrare 24-48 ore

16,73Lei

BLUZA FIRST LAYER PRIMAVERA SPRING DRYARN MARIMEA L
Exclusiv online!

BLUZA FIRST LAYER PRIMAVERA SPRING DRYARN MARIMEA L

vp.53.l
Livrare 24-48 ore

192,40Lei

Camasa Verney-Carron Vitry Marimea L

Camasa Verney-Carron Vitry Marimea L

lvc.lvch174.l
Livrare imediată!

205,92Lei

PANTALONI BROWNING HELLS CANYON 2 VERDE MARIMEA 2XL
Exclusiv online!

PANTALONI BROWNING HELLS CANYON 2 VERDE MARIMEA 2XL

bo.30298637.2xl
Livrare 24-48 ore

294,54Lei

PANTALON TREESCO SAVANE KAKI MARIMEA 52
Exclusiv online!

PANTALON TREESCO SAVANE KAKI MARIMEA 52

bt.1055.52
Livrare 24-48 ore

183,66Lei

PANTALON TREESCO SAVANE KAKI MARIMEA 54
Exclusiv online!

PANTALON TREESCO SAVANE KAKI MARIMEA 54

bt.1055.54
Livrare 24-48 ore

183,66Lei

CIORAPI DRYARN PRIMAVERA SPRING BACK COUNTRY LIGHT MARIMEA 43 46
Exclusiv online!

CIORAPI DRYARN PRIMAVERA SPRING BACK COUNTRY LIGHT MARIMEA 43 46

vp.898.43
Livrare 24-48 ore

49,42Lei

CIZME 2 VARIO CAUCIUC VERDE AIGLE PARCOURS MARIMEA 47
Exclusiv online!

CIZME 2 VARIO CAUCIUC VERDE AIGLE PARCOURS MARIMEA 47

ai.84227.47
Livrare 24-48 ore

858,06Lei

CIORAPI DRYARN PRIMAVERA SPRING BACK COUNTRY LIGHT MARIMEA 39 42
Exclusiv online!

CIORAPI DRYARN PRIMAVERA SPRING BACK COUNTRY LIGHT MARIMEA 39 42

vp.898.39
Livrare 24-48 ore

90,40Lei

CIORAPI DE LANA LUNGI PRIMAVERA SPRING WINTER PROOF MARIMEA 39 42
Exclusiv online!

CIORAPI DE LANA LUNGI PRIMAVERA SPRING WINTER PROOF MARIMEA 39 42

vp.896.39
Livrare 24-48 ore

102,49Lei

CIORAPI VERNEY CARRON SAGI MARIMEA 44 46
Exclusiv online!

CIORAPI VERNEY CARRON SAGI MARIMEA 44 46

lvc.lvpi088.44
Livrare 24-48 ore

84,00Lei

Vesta Treesco Camo Blaze Marimea L
Exclusiv online!

Vesta Treesco Camo Blaze Marimea L

bt.1259.l
Livrare 24-48 ore

269,82Lei

Vesta Treesco Camo Blaze Marimea M

Vesta Treesco Camo Blaze Marimea M

bt.1259.m
Livrare imediată!

269,82Lei

Camasa Verney-Carron Vitry Marimea XXL
Exclusiv online!

Camasa Verney-Carron Vitry Marimea XXL

lvc.lvch174.2xl
Livrare 24-48 ore

205,92Lei

PANTALON TREESCO RAMBOUILLET IMPERMEABIL MARO MARIMEA 46
Exclusiv online!

PANTALON TREESCO RAMBOUILLET IMPERMEABIL MARO MARIMEA 46

bt.1092.1.42
Livrare 24-48 ore

328,98Lei

Afişare 321 - 340 din 567 (29 pagini)
Queries: 5, Total time: 19.635 ms [By time] [By id] [By file]
1 (0.177)
SELECT data
FROM `oc_session`
WHERE session_id = '637453a35c477789f9fbabb760'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (16.773)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (MATCH(pd.tag) AGAINST('+marimea' IN BOOLEAN MODE)) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:737
4 (2.479)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 320, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.097)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38