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 300 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


Twistere Profiblinker Atractor 10 Cm Fluo Green Metalic 4 Buc

Twistere Profiblinker Atractor 10 Cm Fluo Green Metalic 4 Buc

36e59
Livrare imediată!

25,60Lei

FIR TEXTIL PROFIBLINKER GREEN SPINNFADEN 8 BRAID 0.16 MM 150 M -20%
Exclusiv online!

FIR TEXTIL PROFIBLINKER GREEN SPINNFADEN 8 BRAID 0.16 MM 150 M

115g16
Livrare 48-72 ore

123,00Lei(-20%) 98,40Lei

Twisterele Profiblinker Turbotail, Gold Glitter, 3cm,10buc/plic

Twisterele Profiblinker Turbotail, Gold Glitter, 3cm,10buc/plic

30-4
Livrare imediată!

18,00Lei

SAC DE DORMIT NGT PROFILER CU MICROFLEECE 5 SEZOANE -28%

SAC DE DORMIT NGT PROFILER CU MICROFLEECE 5 SEZOANE

ngt-fbc-sbag-profiler
Livrare imediată!

850,01Lei(-28%) 607,90Lei

FIR TEXTIL PROFIBLINKER FLUO SPINNFADEN 8 BRAID 0.16 MM 150 M -20%
Exclusiv online!

FIR TEXTIL PROFIBLINKER FLUO SPINNFADEN 8 BRAID 0.16 MM 150 M

115f16
Livrare 48-72 ore

123,00Lei(-20%) 98,40Lei

PROIECTOR NGT PROFILER 21 LED SOLAR 525 LUMENI 15 x 9.5 x 3.5 CM

PROIECTOR NGT PROFILER 21 LED SOLAR 525 LUMENI 15 x 9.5 x 3.5 CM

ngt-ftl-light-profiler
Livrare imediată!

221,99Lei

Twistere Profiblinker Turbotail 5 Cm Fluo Cu Gliter 10 Buc
Exclusiv online!

Twistere Profiblinker Turbotail 5 Cm Fluo Cu Gliter 10 Buc

30a9
Livrare 48-72 ore

21,90Lei

STRUNE PROFIBLINKER TITAN 30CM 9KG 1 BUC -20%

STRUNE PROFIBLINKER TITAN 30CM 9KG 1 BUC

516b9-bucxxx
Livrare imediată!

15,01Lei(-20%) 12,00Lei

Twistere Profiblinker Riptor 8 Cm Alb Perlat Negru 240 Buc
Exclusiv online!

Twistere Profiblinker Riptor 8 Cm Alb Perlat Negru 240 Buc

37dpe
Livrare 48-72 ore

569,00Lei

TWISTERE PROFIBLINKER TURBOTAIL 3CM RED-GLITTER 10 BUC
Exclusiv online!

TWISTERE PROFIBLINKER TURBOTAIL 3CM RED-GLITTER 10 BUC

30-7
Livrare 48-72 ore

18,00Lei

LINGURITA, OSCILANTA, MISU, GALBENA, PROFI, 11G, f3.osc.g.pr11, Linguri Oscilante, Linguri Oscilante Misu, Misu

LINGURITA, OSCILANTA, MISU, GALBENA, PROFI, 11G, f3.osc.g.pr11, Linguri Oscilante, Linguri Oscilante Misu, Misu

f3.osc.g.pr11
Livrare imediată!

14,54Lei

TWISTERE PROFIBLINKER TURBOTAIL 3CM SMOKE GLITTER 10 BUC
Exclusiv online!

TWISTERE PROFIBLINKER TURBOTAIL 3CM SMOKE GLITTER 10 BUC

30-12
Livrare 48-72 ore

18,00Lei

LINGURITA, OSCILANTA, MISU, ARGINTATA, PROFI, 9G, f3.osc.a.pr09, Linguri Oscilante, Linguri Oscilante Misu, Misu
Exclusiv online!

LINGURITA, OSCILANTA, MISU, ARGINTATA, PROFI, 9G, f3.osc.a.pr09, Linguri Oscilante, Linguri Oscilante Misu, Misu

f3.osc.a.pr09
Livrare 24-48 ore

16,08Lei

LINGURITA, OSCILANTA, MISU, ARGINTATA, PROFI, 13G, f3.osc.a.pr13, Linguri Oscilante, Linguri Oscilante Misu, Misu
Exclusiv online!

LINGURITA, OSCILANTA, MISU, ARGINTATA, PROFI, 13G, f3.osc.a.pr13, Linguri Oscilante, Linguri Oscilante Misu, Misu

f3.osc.a.pr13
Livrare 24-48 ore

16,08Lei

STRUNE PROFIBLINKER WOLFRAM 30CM 12KG 20 BUC

STRUNE PROFIBLINKER WOLFRAM 30CM 12KG 20 BUC

617b12
Livrare imediată!

56,00Lei

LINGURITA, OSCILANTA, MISU, ARGINTATA, PROFI, 11G, f3.osc.a.pr11, Linguri Oscilante, Linguri Oscilante Misu, Misu
Exclusiv online!

LINGURITA, OSCILANTA, MISU, ARGINTATA, PROFI, 11G, f3.osc.a.pr11, Linguri Oscilante, Linguri Oscilante Misu, Misu

f3.osc.a.pr11
Livrare 24-48 ore

16,08Lei

STRUNE PROFI BLINKER WOLFRAM 30CM 15KG 20 BUC
Exclusiv online!

STRUNE PROFI BLINKER WOLFRAM 30CM 15KG 20 BUC

617b15
Livrare 48-72 ore

64,00Lei

LINGURITA OSCILANTA MISU NICHELATA PROFI 11G

LINGURITA OSCILANTA MISU NICHELATA PROFI 11G

f3.osc.n.pr11
Livrare imediată!

14,54Lei

LINGURITA OSCILANTA MISU GALBENA PROFI 13G

LINGURITA OSCILANTA MISU GALBENA PROFI 13G

f3.osc.g.pr13
Livrare imediată!

14,54Lei

LINGURITA, OSCILANTA, MISU, NICHELATA, PROFI, 13G, f3.osc.n.pr13, Linguri Oscilante, Linguri Oscilante Misu, Misu
Exclusiv online!

LINGURITA, OSCILANTA, MISU, NICHELATA, PROFI, 13G, f3.osc.n.pr13, Linguri Oscilante, Linguri Oscilante Misu, Misu

f3.osc.n.pr13
Livrare 24-48 ore

14,54Lei

Afişare 201 - 220 din 287 (15 pagini)
Queries: 5, Total time: 184.132 ms [By time] [By id] [By file]
1 (0.070)
SELECT data
FROM `oc_session`
WHERE session_id = 'af702fb979f2e886aed461a56f'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.107)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (182.502)
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 = '0' AND (pd.tag LIKE "%profi%") 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:698
4 (1.358)
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 200, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.095)
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