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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Jachetă căptușită Fox Collection HD Marime M

Jachetă căptușită Fox Collection HD Marime M

ccl170
Stoc epuizat

626,18Lei

BLUZA KORDA KOOL QUICK DRY LONG SLEEVE ZIP NECK MARIME S

BLUZA KORDA KOOL QUICK DRY LONG SLEEVE ZIP NECK MARIME S

a8.kcl358
Stoc epuizat

185,83Lei

Jachetă căptușită Fox Collection HD Marime xxl

Jachetă căptușită Fox Collection HD Marime xxl

ccl173
Stoc epuizat

626,00Lei

Jachetă căptușită Fox Collection HD Marime L

Jachetă căptușită Fox Collection HD Marime L

ccl171
Stoc epuizat

626,18Lei

CIORAPI KORDA CAMO MARIME 44-46

CIORAPI KORDA CAMO MARIME 44-46

a8.kcl242
Stoc epuizat

176,52Lei

Papuci Delphin OCTO verde lime Marime 38 -18%

Papuci Delphin OCTO verde lime Marime 38

101002454
Stoc epuizat

61,00Lei(-18%) 49,90Lei

Jachetă căptușită Fox Collection HD Marime XL

Jachetă căptușită Fox Collection HD Marime XL

ccl172
Stoc epuizat

626,18Lei

PANTALON GURU BLACK MARIME M

PANTALON GURU BLACK MARIME M

a8.gu.gcl124
Stoc epuizat

260,19Lei

Tricou Nash Elasta-Breathe T-Shirt Black Marime XXXL

Tricou Nash Elasta-Breathe T-Shirt Black Marime XXXL

c5735
Stoc epuizat

105,99Lei

Papuci Delphin OCTO verde Marime 40

Papuci Delphin OCTO verde Marime 40

101002559
Stoc epuizat

61,00Lei

PANTALON KORDA SHORT LE JERSEY LIGHT KAMO MARIME XL

PANTALON KORDA SHORT LE JERSEY LIGHT KAMO MARIME XL

a8.kcl391
Stoc epuizat

232,31Lei

Manusi Savage Gear All Weather Marime M

Manusi Savage Gear All Weather Marime M

a8.sg.76456
Stoc epuizat

88,49Lei

Manusi Savage Gear All Weather Marime L

Manusi Savage Gear All Weather Marime L

a8.sg.76457
Stoc epuizat

88,49Lei

Papuci Delphin OCTO verde lime Marime 46 -18%

Papuci Delphin OCTO verde lime Marime 46

101002460
Stoc epuizat

61,00Lei(-18%) 49,90Lei

Tricou Nash Elasta-Breathe T-Shirt Black Sleeves Marime XXL

Tricou Nash Elasta-Breathe T-Shirt Black Sleeves Marime XXL

c5724
Stoc epuizat

105,99Lei

Cizme Fox Camo neopren marime 46 -20%

Cizme Fox Camo neopren marime 46

cfw131
Stoc epuizat

313,07Lei(-20%) 250,46Lei

JACHETA BROWNING XPO COLDKILL 2 VERDE MARIME L

JACHETA BROWNING XPO COLDKILL 2 VERDE MARIME L

bo.30469640.l
Stoc epuizat

636,14Lei

Papuci Delphin OCTO verde lime Marime 39

Papuci Delphin OCTO verde lime Marime 39

101002560
Stoc epuizat

61,00Lei

JACHETA FLEECE VERNEY-CARRON PRESLY MARO MARIME S

JACHETA FLEECE VERNEY-CARRON PRESLY MARO MARIME S

lvc.lvpo049.1.s
Stoc epuizat

354,88Lei

BLUZA DAIWA D-VEC LS BLACK MARIME L

BLUZA DAIWA D-VEC LS BLACK MARIME L

d.18206.230
Stoc epuizat

160,63Lei

Afişare 2701 - 2720 din 4136 (207 pagini)
Queries: 6, Total time: 115.364 ms [By time] [By id] [By file]
1 (0.072)
SELECT data
FROM `oc_session`
WHERE session_id = 'b780e64a4a78e848e469fddabe'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.087)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.088)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (98.318)
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('+marime' 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
5 (16.682)
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 2700, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.117)
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