Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

Transport Gratuit

Comenzile peste 300 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

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 simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Filtreaza

Produse ce potrivesc criteriilor de căutare

Sortare după:

SUPORT, LANSETA, JAXON, V, Model, 2, aj-sot003, Capete Suporti Fata, Capete Suporti Fata Jaxon, Jaxon

aj-sot003

Livrare imediată!

6,00Lei

Suport Lansete Carp Expert Port Starlet "v"

73040079

Livrare imediată!

5,50Lei

Exclusiv online!

SUPORT, LANSETA, CARP, ZOOM, V, cz7740, Capete Suporti Fata, Capete Suporti Fata Carp Zoom, Carp Zoom

cz7740

Livrare 48-72 ore

12,00Lei

Exclusiv online!

SUPORT MOSTIRO TIP V

ai-1104

Livrare 48-72 ore

4,40Lei

Exclusiv online!

SUPORT, LANSETA, JAXON, SOFT, V, al-vs1, Capete Suporti Fata, Capete Suporti Fata Jaxon, Jaxon

al-vs1

Livrare 48-72 ore

21,00Lei

KAMASAKI, Cap, Suport, Lansete, 17045, 77041445, Capete Suporti Fata, Capete Suporti Fata Kamasaki, Kamasaki

77041445

Livrare imediată!

5,30Lei

SUPORT, LINEAEFFE, V, a6.6313061, Capete Suporti Fata, Capete Suporti Fata Lineaeffe, Lineaeffe

a6.6313061

Livrare imediată!

7,87Lei

Suport Lansete Carp Expert Extra V

73040080

Livrare imediată!

5,50Lei

SUPORT AVERTIZOARE JAXON

aj-syu001

Livrare imediată!

25,00Lei

Suport Mostiro Mega Hard V

ai-1086

Livrare imediată!

5,60Lei

SUPORT LANSETA KAMASAN SWING

ksss001

Livrare imediată!

15,01Lei

KAMASAKI Cap Suport Lansete Reglabil 17043

77041553

Livrare imediată!

9,40Lei

Suport DAM Rod Rest Galben V

40929130502

Livrare imediată!

7,87Lei

Suport Zebco Rod Rest V

1849001

Livrare imediată!

13,28Lei

KAMASAKI Cap Suport Lansete 17046

77041546

Livrare imediată!

5,30Lei

SUPORT GENLOG LANSETA TIP V

gabr-vsp

Livrare imediată!

21,00Lei

Set Extra Carp Capete Suport Lansete Rod Holder "V&U", 2buc/blister

ec3914

Livrare imediată!

11,90Lei

SUPORT LANSETA JAXON V

al-v1

Stoc epuizat

11,50Lei

Afişare 1 - 18 din 18 (1 pagini)

Queries: 10, Total time: 741.694 ms [By time] [By id] [By file]

1 (0.076)

SELECT data
FROM `oc_session`
WHERE session_id = '052300f72df7ba3262bc40b07d'

/var/www/clients/client1/web1/web/system/library/session/db.php:23

2 (0.082)

SELECT *
FROM oc_platforma_promovari LIMIT 1

/var/www/clients/client1/web1/web/index.php:128

3 (0.072)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:422

4 (397.936)

SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '0' AND ((pd.tag LIKE '%capete%' AND pd.tag LIKE '%suporti%' AND pd.tag LIKE '%fata%')) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1555

5 (343.019)

SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '0' AND ((pd.tag LIKE '%capete%' AND pd.tag LIKE '%suporti%' AND pd.tag LIKE '%fata%')) AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 0, 20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184

6 (0.113)

SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
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)
WHERE p2s.store_id = '0' AND ((pd.tag LIKE '%capete%' AND pd.tag LIKE '%suporti%' AND pd.tag LIKE '%fata%')) AND p.status_filtru > 0 AND p.price > 0 HAVING match_filters = 1

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1066

7 (0.131)

SELECT COUNT(*) AS val, filter_group, filter_id
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)
WHERE p2s.store_id = '0' AND ((pd.tag LIKE '%capete%' AND pd.tag LIKE '%suporti%' AND pd.tag LIKE '%fata%')) AND p.status_filtru > 0 AND p.price > 0 AND f.language_id = '2' GROUP BY p.product_id, filter_group, filter_id HAVING match_filters = 1

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:911

8 (0.099)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

9 (0.078)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

10 (0.088)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Căutare

Produse ce potrivesc criteriilor de căutare