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


SUPORT LANSETA MOSTIRO TIP U MINI ACRILIC RED

SUPORT LANSETA MOSTIRO TIP U MINI ACRILIC RED

ai-rr34-red
Livrare imediată!

7,79Lei

Suport Matrix 3D-R Cross Arm Medium pentru Scaun Modular 28cm
Exclusiv online!

Suport Matrix 3D-R Cross Arm Medium pentru Scaun Modular 28cm

gba022
Livrare 7-14 zile

98,37Lei

Suport Lansete Carp Zoom Save-F Feeder Competition 36x10x3cm

Suport Lansete Carp Zoom Save-F Feeder Competition 36x10x3cm

cz0022
Livrare imediată!

53,00Lei

KAMASAKI Cap Suport Lansete 17041

KAMASAKI Cap Suport Lansete 17041

77041551
Livrare imediată!

9,40Lei

Cap Suport Mivardi Lanseta Adjusta-Lok Rest
Exclusiv online!

Cap Suport Mivardi Lanseta Adjusta-Lok Rest

m-rrad
Livrare 48-72 ore

81,99Lei

Suport Lansete Nevis Eva 42cm

Suport Lansete Nevis Eva 42cm

6218-400
Livrare imediată!

36,00Lei

Suport pentru Avertizor Arrow Point Dinsmores 60cm -20%

Suport pentru Avertizor Arrow Point Dinsmores 60cm

k876
Livrare imediată!

31,00Lei(-20%) 24,89Lei

Suport FOX Black Label Snag Ears Standard -23%

Suport FOX Black Label Snag Ears Standard

cbb005
Livrare imediată!

89,96Lei(-23%) 69,59Lei

Suport Lansete Carp Hunter Cu Slicon Galben

Suport Lansete Carp Hunter Cu Slicon Galben

77041438
Livrare imediată!

6,70Lei

Cap Suport Lanseta Carp Academy Negru S

Cap Suport Lanseta Carp Academy Negru S

6111-003
Livrare imediată!

17,01Lei

SUPORT JAXON INAINTAS EVA 19CM
Exclusiv online!

SUPORT JAXON INAINTAS EVA 19CM

ac-4635
Livrare 48-72 ore

16,01Lei

Cap Extra Carp Suport Fluorescent

Cap Extra Carp Suport Fluorescent

ec9442
Livrare imediată!

7,00Lei

Suport Lansete Nevis Eva 27cm

Suport Lansete Nevis Eva 27cm

6218-200
Livrare imediată!

25,00Lei

SUPORT MOSTIRO GRIP SOFT LUMINO V

SUPORT MOSTIRO GRIP SOFT LUMINO V

ai-rr24-l
Livrare imediată!

7,79Lei

SUPORT LANSETA JAXON CAUCIUC AC-PC061

SUPORT LANSETA JAXON CAUCIUC AC-PC061

ac-pc061
Livrare imediată!

18,00Lei

Cap Suport Lanseta Carp Academy Fluo S

Cap Suport Lanseta Carp Academy Fluo S

6111-004
Livrare imediată!

17,01Lei

Cap Suport Mivardi cu Parghie Sure Lock Rest

Cap Suport Mivardi cu Parghie Sure Lock Rest

m-rrsl
Livrare imediată!

42,00Lei

Suport Maver Feeder Signature QR Rear Rest 25CM
Exclusiv online!

Suport Maver Feeder Signature QR Rear Rest 25CM

l1075
Livrare 48-72 ore

124,00Lei

Suport lanseta Baracuda XC-BJ2120 120cm

Suport lanseta Baracuda XC-BJ2120 120cm

xcbj2120 - suport lansete
Livrare imediată!

10,23Lei

CUTIE JAXON CU SUPORT PRO MATCH B 52X25X11CM
Exclusiv online!

CUTIE JAXON CU SUPORT PRO MATCH B 52X25X11CM

ak-kze040b
Livrare 48-72 ore

216,00Lei

Afişare 581 - 600 din 1212 (61 pagini)
Queries: 9, Total time: 43.825 ms [By time] [By id] [By file]
1 (0.155)
SELECT data
FROM `oc_session`
WHERE session_id = 'c9f48b5b1ae6a711d5fd86827d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (33.061)
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('+suport' 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.306)
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 (1.236)
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
6 (0.129)
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
7 (0.279)
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
8 (8.428)
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
9 (0.130)
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