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ă:

CARLIGE FL CATFISH 10BUC/PLIC MARIME 7/0

6211022205838

Stoc epuizat

8,00Lei

Lanseta Daiwa Powermesh Catfish 3.00m, 500g, 2seg

d.11731.305

Stoc epuizat

603,93Lei

Lanseta Filfishing Monster Catfish, 2.85m, 150-400g, 2seg

fil4742

Stoc epuizat

259,00Lei

Lanseta Daiwa Exceler Catfish 3.30m, 200-600g, 2seg

d.11818.336

Stoc epuizat

494,08Lei

Combo Spinning Mitchell Catch Pro Catfish Orange, 100-300g, 2.70m, 2seg

1544466

Stoc epuizat

237,45Lei

Fir Textil Filfishing Inaintas Catfish Leader, 158kg, 1.10mm, 10m

fil2764

Stoc epuizat

17,99Lei

Fir Textil Filfishing Inaintas Catfish Leader, 95kg, 0.80mm, 10m

fil2733

Stoc epuizat

14,49Lei

Fir Textil Carp Zoom Catfish 8X, Fluo Green, 49.8kg, 0.50mm, 300m

cz2162

Stoc epuizat

81,99Lei

Fir Textil Filfishing Inaintas Catfish Leader, 120kg, 0.90mm, 10m

fil2740

Stoc epuizat

15,99Lei

Lanseta Filfishing Monster Catfish, 2.55m, 150-400g, 2seg

fil4735

Stoc epuizat

245,00Lei

Fir Textil Filfishing Inaintas Catfish Leader, 145kg, 1.00mm, 10m

fil2757

Stoc epuizat

16,99Lei

Hanorac Zeck Catfish Hoodie, Marime M

80505281030

Stoc epuizat

371,64Lei

Tricou Zeck Catfish M

80805281021

Stoc epuizat

142,23Lei

Lanseta Somn Mikado Intro Catfish, 500g, 3.00m, 2seg

WAA879-300

Stoc epuizat

306,00Lei

Pantaloni Impermeabili Zeck Rain Trousers Catfish, Marime XL

80405170335

Stoc epuizat

166,28Lei

Sapca Zeck Flexfit Catfish, L-XL, Black

81305281579

Stoc epuizat

164,18Lei

Tricou Zeck Catfish XL

80805281023

Stoc epuizat

142,23Lei

CARP ZOOM CATFISH MEGA PELLET 30mm 340gr Fish - Meat

cz5059

Stoc epuizat

29,00Lei

Fir Monofilament EnergoTeam Specialist Catfish 0.70mm/150m/40.25kg

33230070

Stoc epuizat

25,00Lei

Fir Monofilament EnergoTeam Specialist Catfish 0.60mm/150m/34.50kg

33230060

Stoc epuizat

21,00Lei

Afişare 321 - 340 din 374 (19 pagini)

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

1 (0.120)

SELECT data
FROM `oc_session`
WHERE session_id = '9d49d292d2fa70a9636fa8bdf4'

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

2 (0.116)

SELECT *
FROM oc_platforma_promovari LIMIT 1

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

3 (0.085)

SELECT `trigger`, `action`
FROM oc_event

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

4 (380.957)

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 = '2' AND (pd.tag LIKE "%catfish%") 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 320, 20

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

5 (205.033)

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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%catfish%") 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:697

6 (0.232)

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:1066

7 (3.663)

SELECT COUNT(*) 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:911

8 (0.124)

SELECT *
FROM oc_platforma_promovari

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

9 (0.119)

SELECT *
FROM oc_platforma_promovari

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

10 (0.125)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' 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