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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


SUPORT LANSETA MOSTIRO TIP U MINI ACRILIC YELLOW

SUPORT LANSETA MOSTIRO TIP U MINI ACRILIC YELLOW

ai-rr34-yel
Livrare imediată!

7,79Lei

FOARFECA TIP CLESTE TRAKKO DELUXE

FOARFECA TIP CLESTE TRAKKO DELUXE

tr11800
Livrare imediată!

43,99Lei

OPRITOR TIP CAPSA PENTRU BOILIES KORDA FLOSS CAPS, 20BUC/PLIC TRANSPARENT

OPRITOR TIP CAPSA PENTRU BOILIES KORDA FLOSS CAPS, 20BUC/PLIC TRANSPARENT

a.kflc1
Stoc epuizat

13,90Lei

Cap Falcon Suport Feeder tip V Rod Holder
Exclusiv online!

Cap Falcon Suport Feeder tip V Rod Holder

f3198
Livrare 48-72 ore

12,99Lei

PLUMB ENERGO TEAM TIP TIGARA CU TUB 120G

PLUMB ENERGO TEAM TIP TIGARA CU TUB 120G

52728120
Livrare imediată!

10,00Lei

PLUMB ENERGO TEAM TIP TIGARA CU TUB 100G

PLUMB ENERGO TEAM TIP TIGARA CU TUB 100G

52728100
Livrare imediată!

12,00Lei

SUPORT LANSETA MOSTIRO TIP U MINI ACRILIC Blue

SUPORT LANSETA MOSTIRO TIP U MINI ACRILIC Blue

ai-rr34-blu
Livrare imediată!

7,79Lei

Opritor Tip Umbrela Carp Academy -39%

Opritor Tip Umbrela Carp Academy

8100-138
Livrare imediată!

6,40Lei(-39%) 3,90Lei

SUPORT LANSETA MOSTIRO TIP U MINI ACRILIC Green

SUPORT LANSETA MOSTIRO TIP U MINI ACRILIC Green

ai-rr34-grn
Livrare imediată!

7,79Lei

SUPORT LANSETA MOSTIRO TIP U MINI ACRILIC RED

SUPORT LANSETA MOSTIRO TIP U MINI ACRILIC RED

ai-rr34-red
Livrare imediată!

7,79Lei

Plumb Delphin tip lacrima 90g

Plumb Delphin tip lacrima 90g

830514090
Livrare imediată!

9,00Lei

Varf Browning Carbon Feeder Tip 0.75Oz 60cm -26%

Varf Browning Carbon Feeder Tip 0.75Oz 60cm

12224030
Livrare imediată!

53,78Lei(-26%) 39,90Lei

Plumb Delphin tip lacrima 40g

Plumb Delphin tip lacrima 40g

830514040
Livrare imediată!

6,00Lei

Varf Browning Carbon Feeder Tip 3Oz 60cm -39%

Varf Browning Carbon Feeder Tip 3Oz 60cm

12224034
Livrare imediată!

53,78Lei(-39%) 32,90Lei

Juvelnic Petrovics tip sac PT 80cm

Juvelnic Petrovics tip sac PT 80cm

72010080
Livrare imediată!

15,01Lei

REMOTE SWITCH LED LENSER TIP E PENTRU MT14

REMOTE SWITCH LED LENSER TIP E PENTRU MT14

a8.z501025
Livrare imediată!

118,21Lei

Plumb Delphin tip lacrima cu tub 80g

Plumb Delphin tip lacrima cu tub 80g

830512080
Livrare imediată!

9,00Lei

Plumb Delphin tip lacrima 70g

Plumb Delphin tip lacrima 70g

830514070
Livrare imediată!

8,00Lei

Lanseta Sakura Salt Sniper Spinning SALSS 742 M 2.25m 10-40gr Special Solid Tip EGI Tiprun
Exclusiv online!

Lanseta Sakura Salt Sniper Spinning SALSS 742 M 2.25m 10-40gr Special Solid Tip EGI Tiprun

20434saprj802274-2m-egi
Livrare 48-72 ore

357,98Lei

SUPORT GENLOG LANSETA TIP U

SUPORT GENLOG LANSETA TIP U

gabr-usp
Livrare imediată!

21,00Lei

Afişare 141 - 160 din 420 (21 pagini)
Queries: 5, Total time: 12.415 ms [By time] [By id] [By file]
1 (0.101)
SELECT data
FROM `oc_session`
WHERE session_id = '16a4d458e63c103e162e625231'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.121)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (10.173)
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 = '2' AND (MATCH(pd.tag) AGAINST('+tip' 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 (1.892)
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 140, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.128)
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