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


Carlige Fudo Chinu with Ring (CHNR-BN) nr.3/0 BN - Black Nickel 5 buc/plic -20%

Carlige Fudo Chinu with Ring (CHNR-BN) nr.3/0 BN - Black Nickel 5 buc/plic

1101-3/0
Livrare imediată!

10,00Lei(-20%) 8,00Lei

CARLIGE COLMIC NUCLEAR NK800 NICKEL NR 6
Exclusiv online!

CARLIGE COLMIC NUCLEAR NK800 NICKEL NR 6

amo06
Livrare 48-72 ore

18,50Lei

CARLIGE JAXON LEGATE SUMATO CHINU NR 12 0,16 MM

CARLIGE JAXON LEGATE SUMATO CHINU NR 12 0,16 MM

hy-sbb12
Livrare imediată!

8,00Lei

Carlig Owner 50120 Nr.10 Kappa Style 3 15buc/plic -23%

Carlig Owner 50120 Nr.10 Kappa Style 3 15buc/plic

5012010
Livrare imediată!

10,25Lei(-23%) 7,90Lei

Carlig Owner 50120 Nr.8 Kappa Style 3 15buc/plic -29%

Carlig Owner 50120 Nr.8 Kappa Style 3 15buc/plic

5012008
Livrare imediată!

9,40Lei(-29%) 6,68Lei

CARLIGE MAVER KATANA SERIA CRAP 0.1B NR 14 BARBLESS
Exclusiv online!

CARLIGE MAVER KATANA SERIA CRAP 0.1B NR 14 BARBLESS

01bkca14
Livrare 48-72 ore

13,49Lei

CARLIGE CARP ZOOM FEEDER COMPETITION 501 nr.6 10/plic

CARLIGE CARP ZOOM FEEDER COMPETITION 501 nr.6 10/plic

cz2744
Livrare imediată!

8,50Lei

CARLIGE CARP ZOOM FEEDER COMPETITION 538 nr.8 10/plic -19%

CARLIGE CARP ZOOM FEEDER COMPETITION 538 nr.8 10/plic

cz2843
Livrare imediată!

8,50Lei(-19%) 6,90Lei

CARLIGE GAMAKATSU LS-2030S NR 10 BLUE 25BUC/PL

CARLIGE GAMAKATSU LS-2030S NR 10 BLUE 25BUC/PL

gk.146557.10
Livrare imediată!

18,21Lei

CARLIGE MAVER SERIA INVINCIBLE CS26 PELLET NR 18

CARLIGE MAVER SERIA INVINCIBLE CS26 PELLET NR 18

g1113
Livrare imediată!

6,50Lei

CARLIGE MAVER SERIA INVINCIBLE CS26 PELLET NR 20
Exclusiv online!

CARLIGE MAVER SERIA INVINCIBLE CS26 PELLET NR 20

g1114
Livrare 48-72 ore

6,50Lei

CARLIGE COLMIC NUCLEAR WN501 F/BARB NR 14
Exclusiv online!

CARLIGE COLMIC NUCLEAR WN501 F/BARB NR 14

amhw24
Livrare 48-72 ore

13,99Lei

CIRLIGE GURU QM1NR.14 10BUC/PLIC

CIRLIGE GURU QM1NR.14 10BUC/PLIC

gu.gq14
Livrare imediată!

18,94Lei

CARLIGE GAMAKATSU FORJATE LS-3340N NR 8 NI 25BUC/PL

CARLIGE GAMAKATSU FORJATE LS-3340N NR 8 NI 25BUC/PL

gk.146581.8
Livrare imediată!

17,01Lei

CARLIGE GAMAKATSU FORJATE LS-3510F NR 6 BL 25BUC/PL

CARLIGE GAMAKATSU FORJATE LS-3510F NR 6 BL 25BUC/PL

gk.146585.6
Livrare imediată!

18,81Lei

CARLIGE CARP ZOOM FEEDER COMPETITION 517 nr.8 10/plic

CARLIGE CARP ZOOM FEEDER COMPETITION 517 nr.8 10/plic

cz2799
Livrare imediată!

8,50Lei

CIRLIGE GURU MWG NR.16 10BUC/PLIC
Exclusiv online!

CIRLIGE GURU MWG NR.16 10BUC/PLIC

gu.gmw16
Livrare 24-48 ore

11,57Lei

Carlige Fudo Keiryuu with Ring (KRYR-BN) nr.12 BN - Black Nickel 14 buc/plic -41%

Carlige Fudo Keiryuu with Ring (KRYR-BN) nr.12 BN - Black Nickel 14 buc/plic

6201-12
Livrare imediată!

10,00Lei(-41%) 5,90Lei

CIRLIGE GURU MWG NR.12 10BUC/PLIC

CIRLIGE GURU MWG NR.12 10BUC/PLIC

gu.gmw12
Livrare imediată!

11,57Lei

CARLIGE GAMAKATSU FORJATE LS-3340N NR 12 NI 25BUC/PL

CARLIGE GAMAKATSU FORJATE LS-3340N NR 12 NI 25BUC/PL

gk.146581.12
Livrare imediată!

18,34Lei

Afişare 1021 - 1040 din 3568 (179 pagini)
Queries: 10, Total time: 146.305 ms [By time] [By id] [By file]
1 (0.094)
SELECT data
FROM `oc_session`
WHERE session_id = '532c4033e34b0b80ceb3864ee3'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (90.206)
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('+carlige +stationar' 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 (0.358)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (13.362)
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 1020, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (3.603)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1248
7 (0.113)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1270
8 (1.179)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1035
9 (37.169)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:949
10 (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