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


Set Varnis Pluta Filex Super Soft Rotund Marime L, 5 Compartimente
Exclusiv online!

Set Varnis Pluta Filex Super Soft Rotund Marime L, 5 Compartimente

fil2427
Livrare 48-72 ore

8,50Lei

Teaser Savage Gear Trace Marime M, 1.00mm, 36kg, 60cm, 2buc/pac
Exclusiv online!

Teaser Savage Gear Trace Marime M, 1.00mm, 36kg, 60cm, 2buc/pac

sg.1612334
Livrare 24-48 ore

36,44Lei

Tricou Winchester Guns Springer, Kaki, Marime 2XL
Exclusiv online!

Tricou Winchester Guns Springer, Kaki, Marime 2XL

bo.60115058.2xl
Livrare 24-48 ore

99,40Lei

Tricou Winchester Guns Springer, Kaki, Marime L
Exclusiv online!

Tricou Winchester Guns Springer, Kaki, Marime L

bo.60115058.l
Livrare 24-48 ore

99,40Lei

Vartej Rapid cu Anou Carp Academy, Marime S-M, Nr.9, 10buc/pac
Exclusiv online!

Vartej Rapid cu Anou Carp Academy, Marime S-M, Nr.9, 10buc/pac

5564-009
Livrare 48-72 ore

10,20Lei

Waders din neopren Delphin ORAVA, Marime 45 -29%

Waders din neopren Delphin ORAVA, Marime 45

101002552
Livrare imediată!

634,00Lei(-29%) 450,00Lei

Waders din neopren Delphin ORAVA, Marime 46 -29%

Waders din neopren Delphin ORAVA, Marime 46

101002553
Livrare imediată!

634,00Lei(-29%) 450,00Lei

Baliza MARKER H PRO FL MARIME Small

Baliza MARKER H PRO FL MARIME Small

64-66013
Livrare imediată!

14,90Lei

Bluza Preston Micro Fleece, Marime 3XL
Exclusiv online!

Bluza Preston Micro Fleece, Marime 3XL

p0200499
Livrare 7-14 zile

179,96Lei

Cizme Piept Nash ZT HD Waders Camo, Marime 41
Exclusiv online!

Cizme Piept Nash ZT HD Waders Camo, Marime 41

c6234
Livrare 7-14 zile

489,95Lei

Cizme Piept Nash ZT HD Waders Camo, Marime 45
Exclusiv online!

Cizme Piept Nash ZT HD Waders Camo, Marime 45

c6238
Livrare 7-14 zile

489,95Lei

Colanti Fox WC Leggings, Marime L

Colanti Fox WC Leggings, Marime L

cwc015
Livrare imediată!

157,46Lei

Colanti Fox WC Leggings, Marime S

Colanti Fox WC Leggings, Marime S

cwc013
Livrare imediată!

157,46Lei

Costum de Iarna Daiwa Winter Carp Olive Green, Marime M -23%

Costum de Iarna Daiwa Winter Carp Olive Green, Marime M

d.18865.320
Livrare imediată!

1.020,83Lei(-23%) 785,90Lei

Costum de Iarna Daiwa Winter Carp Olive Green, Marime XL -23%

Costum de Iarna Daiwa Winter Carp Olive Green, Marime XL

d.18865.340
Livrare imediată!

1.020,83Lei(-23%) 785,90Lei

Costum Gamakatsu G-Thermal Base Layer, Marime M

Costum Gamakatsu G-Thermal Base Layer, Marime M

a8.gk.7247.200
Livrare imediată!

184,38Lei

Costum Impermeabil Preston Celcius Suit, Marime XL

Costum Impermeabil Preston Celcius Suit, Marime XL

p0200423
Livrare imediată!

809,96Lei

Costum Impermeabil Preston Celcius Suit, Marime XXL

Costum Impermeabil Preston Celcius Suit, Marime XXL

p0200424
Livrare imediată!

809,96Lei

Costum Termo DAM Xthrem Winther 2 Buc, Marime XL

Costum Termo DAM Xthrem Winther 2 Buc, Marime XL

a8.dam.60123
Livrare imediată!

648,34Lei

Costum Termo DAM Xthrem Winther 2 Buc, Marime XXL

Costum Termo DAM Xthrem Winther 2 Buc, Marime XXL

a8.dam.60124
Livrare imediată!

648,34Lei

Afişare 1881 - 1900 din 4129 (207 pagini)
Queries: 5, Total time: 97.542 ms [By time] [By id] [By file]
1 (0.107)
SELECT data
FROM `oc_session`
WHERE session_id = '866c0eab079614929262976dc3'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.064)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (82.484)
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
4 (14.770)
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 1880, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (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