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

Fir textil RTB Crossfire X8 Braid Lime Green 150m 20 LB 0.174 MM

rtb8101

Livrare imediată!

69,00Lei

Vartej Cu Tub Culisant Trabucco Cross Line Crane Swivels Nr.1/0, 60kg, 8buc/pac

100-75-009

Livrare imediată!

22,00Lei

Exclusiv online!

Vartej Cu Tub Culisant Trabucco Cross Line Crane Swivels Nr.2, 47kg, 10buc/pac

100-75-020

Livrare 48-72 ore

20,00Lei

Vartej cu Margea Culisanta Sunset ST-S-1026 Crossline Beads S

40311stsab1043s

Livrare imediată!

9,09Lei

Exclusiv online!

Fir textil DAM Crosspower 4 Braid 0.13mm 150m

11020966576

Livrare 48-72 ore

46,68Lei

Fir textil DAM Crosspower 4 Braid 0.15mm 150m

11020966577

Livrare imediată!

43,80Lei

Exclusiv online!

Fir textil DAM Crosspower 4 Braid 0.22mm 150m

11020966580

Livrare 48-72 ore

43,80Lei

Exclusiv online!

Fir textil DAM Crosspower 4 Braid 0.10mm 150m

11020966575

Livrare 48-72 ore

46,68Lei

Exclusiv online!

Fir textil DAM Crosspower 4 Braid 0.17mm 150m

11020966578

Livrare 48-72 ore

43,80Lei

Exclusiv online!

LANSETA DAIWA CROSSCAST XT CARP 3.90M 3.5LBS 2SEG

d.11562.395

Livrare 24-48 ore

727,16Lei

Fir textil DAM Crosspower 4 Braid 0.20mm 150m

11020966579

Livrare imediată!

43,80Lei

Brat Suport Scaun Modular Preston Offbox 36 Cross Arm Short, 18cm

p0110029

Livrare imediată!

89,96Lei

Exclusiv online!

LANSETA DAIWA CROSSCAST XT CARP 3.00M 3.5LBS 2SEG

d.11562.305

Livrare 24-48 ore

484,08Lei

VARTEJ TRIPLU LUCKY JOHN CROSSLINE SWIVEL Nr.6 21kg 7buc/plic

ljp5108-006

Livrare imediată!

10,00Lei

VARTEJ TRIPLU LUCKY JOHN CROSSLINE SWIVEL Nr.10 15kg 10buc/plic

ljp5108-010

Livrare imediată!

10,00Lei

LANSETA DAIWA CROSSCAST XT CARP 3.60M 3.5LBS 2SEG

d.11562.365

Livrare imediată!

721,93Lei

MOMITOR ATTACK INLINE X-CROSS METHOD FEEDER LARGE 60GR 1buc/plic

ai-fd84-l-60

Livrare imediată!

9,90Lei

Exclusiv online!

Agrafe Yarie Jespa 552 Crosslock Snap 50lbs 9buc/plic

y552050

Livrare 48-72 ore

13,99Lei

Exclusiv online!

Agrafe Yarie Jespa 552 Crosslock Snap 35lbs 9buc/plic

y552035

Livrare 48-72 ore

13,99Lei

Exclusiv online!

Agrafe Yarie Jespa 552 Crosslock Snap 70lbs 9buc/plic

y552070

Livrare 48-72 ore

13,99Lei

Afişare 21 - 40 din 222 (12 pagini)

Queries: 12, Total time: 2,475.878 ms [By time] [By id] [By file]

1 (0.123)

SELECT data
FROM `oc_session`
WHERE session_id = '79efcfa7116fbf90ee15f89662'

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

2 (0.118)

SELECT *
FROM oc_platforma_promovari LIMIT 1

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

3 (0.129)

SELECT `trigger`, `action`
FROM oc_event

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

4 (1,407.117)

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 = '2' AND (pd.tag LIKE "%cross%") 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 (759.339)

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 "%cross%") 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 20, 20

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

6 (0.181)

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

7 (303.943)

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 "%cross%") 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

8 (0.262)

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

9 (4.315)

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

10 (0.126)

SELECT *
FROM oc_platforma_promovari

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

11 (0.095)

SELECT *
FROM oc_platforma_promovari

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

12 (0.130)

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