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


Struna DAM Effzett Coated 1x7 Black, 30cm, 7kg. 2buc/pac
Exclusiv online!

Struna DAM Effzett Coated 1x7 Black, 30cm, 7kg. 2buc/pac

a7.dam.56413
Livrare 24-48 ore

8,57Lei

Tricou BKK Casual Legacy, Black, Marime L
Exclusiv online!

Tricou BKK Casual Legacy, Black, Marime L

6941780925708
Livrare 48-72 ore

155,00Lei

Tricou Fox Collection T Black & Orange, Marime S

Tricou Fox Collection T Black & Orange, Marime S

ccl178
Livrare imediată!

94,46Lei

Tricou Fox Collection T Green & Black, Marime S

Tricou Fox Collection T Green & Black, Marime S

ccl184
Livrare imediată!

94,46Lei

Tricou Fox Collection T Green & Black, Marime XL

Tricou Fox Collection T Green & Black, Marime XL

ccl187
Livrare imediată!

94,46Lei

Tricou Korda Le Tackle Black, Marime XL

Tricou Korda Le Tackle Black, Marime XL

a8.kcl710
Livrare imediată!

137,97Lei

Tricou Korda Outline Tee Black, Marime L

Tricou Korda Outline Tee Black, Marime L

a8.kcl745
Livrare imediată!

138,88Lei

Tricou Korda Outline Tee Black, Marime M

Tricou Korda Outline Tee Black, Marime M

a8.kcl744
Livrare imediată!

138,88Lei

Tricou Kumu The Last Cast Black, Marime 2XL

Tricou Kumu The Last Cast Black, Marime 2XL

tstlc105
Livrare imediată!

130,00Lei

Tricou Kumu The Last Cast Black, Marime L

Tricou Kumu The Last Cast Black, Marime L

tstlc103
Livrare imediată!

131,99Lei

Tricou Preston T-Shirt, Black, Marime S -43%

Tricou Preston T-Shirt, Black, Marime S

p0200344
Livrare imediată!

106,23Lei(-43%) 61,00Lei

Vobler Live Target Frog Propper, Brown / Black, 7.5cm, 14g -20%
Exclusiv online!

Vobler Live Target Frog Propper, Brown / Black, 7.5cm, 14g

lt.fgp75t503
Livrare 24-48 ore

40,23Lei(-20%) 32,18Lei

Vobler Live Target Golden Shiner Rattlebait, Glow / Black, 5.0cm, 7.0g -20%

Vobler Live Target Golden Shiner Rattlebait, Glow / Black, 5.0cm, 7.0g

lt.gs50sk211
Livrare imediată!

38,51Lei(-20%) 30,81Lei

Briceag Victorinox Hunter M Black, 23cm

Briceag Victorinox Hunter M Black, 23cm

0.9411.m3
Livrare imediată!

534,79Lei

Carlige BKK Chinu Diamond Black Nickel Nr.8 12buc/plic -23%

Carlige BKK Chinu Diamond Black Nickel Nr.8 12buc/plic

6939067097569
Livrare imediată!

9,00Lei(-23%) 6,90Lei

Cicada Live Target Sonic Shad Blade Bait, 5cm, 10g, Glow / Black
Exclusiv online!

Cicada Live Target Sonic Shad Blade Bait, 5cm, 10g, Glow / Black

lt.sns50sk211
Livrare 24-48 ore

48,99Lei

Geanta Aqua Products Front Barrow Bag Black Series, 65x36x35cm
Exclusiv online!

Geanta Aqua Products Front Barrow Bag Black Series, 65x36x35cm

404926
Livrare 7-14 zile

624,95Lei

Hanorac Avid Carp Minimal Hoodie Black, Marime L

Hanorac Avid Carp Minimal Hoodie Black, Marime L

a0620249 l
Livrare imediată!

188,96Lei

Hanorac Fox Collection LW Hoody Green & Black, Marime 3XL

Hanorac Fox Collection LW Hoody Green & Black, Marime 3XL

ccl201
Livrare imediată!

157,46Lei

Hanorac Fox Collection LW Hoody Green & Black, Marime S

Hanorac Fox Collection LW Hoody Green & Black, Marime S

ccl196
Livrare imediată!

157,46Lei

Afişare 761 - 780 din 4758 (238 pagini)
Queries: 6, Total time: 139.277 ms [By time] [By id] [By file]
1 (0.120)
SELECT data
FROM `oc_session`
WHERE session_id = '0b6c9e787a328450466664a427'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.139)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (120.586)
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('+black' 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 (18.144)
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 760, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.144)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=184759'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
6 (0.144)
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