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


Groundbait Daiwa Advantage Allround 1kg/punga

Groundbait Daiwa Advantage Allround 1kg/punga

a0.13300.002
Livrare imediată!

36,98Lei

Van Den Eynde nada Kastaar 1kg

Van Den Eynde nada Kastaar 1kg

vn00104
Livrare imediată!

18,00Lei

NADA LANTOS MIX CAPSUNA FAINA PESTE 1KG
Exclusiv online!

NADA LANTOS MIX CAPSUNA FAINA PESTE 1KG

a0.l.nad.eper.fish
Livrare 24-48 ore

19,89Lei

Van Den Eynde Carpmaster Expanda Caramel 1kg
Exclusiv online!

Van Den Eynde Carpmaster Expanda Caramel 1kg

vn00359
Livrare 48-72 ore

29,00Lei

Nada Dynamite Baits Big Fish Sweet Tiger Specimen Feeder Groundbait 1.8kg
Exclusiv online!

Nada Dynamite Baits Big Fish Sweet Tiger Specimen Feeder Groundbait 1.8kg

dy1477
Livrare 48-72ore

49,00Lei

Nada Benzar Mix Rapid Bigfish Mix 1.5KG Mango-Butiric
Exclusiv online!

Nada Benzar Mix Rapid Bigfish Mix 1.5KG Mango-Butiric

97012174
Livrare 24-48 ore

17,00Lei

Nada Sensas 3000 Method Carp Pellets 1 Kg

Nada Sensas 3000 Method Carp Pellets 1 Kg

a0.s70721
Livrare imediată!

26,00Lei

Nada Benzar Mix CARP N-BUTYRIC 3KG

Nada Benzar Mix CARP N-BUTYRIC 3KG

94003574
Livrare imediată!

25,00Lei

Van Den Eynde nada Heavy Special 1kg

Van Den Eynde nada Heavy Special 1kg

vn00095
Livrare imediată!

19,00Lei

Nada Browning Groundbait Champion Feeder Mix Quick Skimmer 1kg

Nada Browning Groundbait Champion Feeder Mix Quick Skimmer 1kg

3970025
Livrare imediată!

26,78Lei

GROUNDBAIT DYNAMITE BAITS SILVER X SPECIMEN ORIGINAL
Exclusiv online!

GROUNDBAIT DYNAMITE BAITS SILVER X SPECIMEN ORIGINAL

sx525
Livrare 48-72ore

33,00Lei

Van Den Eynde NADA BIG FISH 1kg
Exclusiv online!

Van Den Eynde NADA BIG FISH 1kg

vn00121
Livrare 48-72 ore

21,00Lei

NADA CUKK CU ADAOS TTX CAPSUNI SQUID 1.5KG

NADA CUKK CU ADAOS TTX CAPSUNI SQUID 1.5KG

a0.c0459
Livrare imediată!

23,45Lei

NADA JAXON METHOD FEEDER READY RED MULBERRY 750gr
Exclusiv online!

NADA JAXON METHOD FEEDER READY RED MULBERRY 750gr

fm-zr15
Livrare 48-72 ore

25,00Lei

Nada Sensas 3000 Method Bream & Big Fish1 Kg

Nada Sensas 3000 Method Bream & Big Fish1 Kg

a0.s70752
Livrare imediată!

26,00Lei

NADA LANTOS MIX ANANAS 1KG
Exclusiv online!

NADA LANTOS MIX ANANAS 1KG

a0.l.nad.ananas
Livrare 24-48 ore

12,04Lei

NADA CUKK CU ADAOS TTX SCOICA 1.5KG
Exclusiv online!

NADA CUKK CU ADAOS TTX SCOICA 1.5KG

a0.c0472
Livrare 24-48 ore

23,45Lei

NADA VAN DEN EYNDE FORMULE M ROACH 1KG

NADA VAN DEN EYNDE FORMULE M ROACH 1KG

vn30025
Livrare imediată!

18,00Lei

Nada Benzar Mix Rapid Bigfish Mix 1.5KG MIERE

Nada Benzar Mix Rapid Bigfish Mix 1.5KG MIERE

97012103
Livrare imediată!

17,00Lei

Nada Browning Groundbait Champion Feeder Mix Big Bream 1kg

Nada Browning Groundbait Champion Feeder Mix Big Bream 1kg

3970026
Livrare imediată!

26,78Lei

Afişare 701 - 720 din 1060 (53 pagini)
Queries: 12, Total time: 611.332 ms [By time] [By id] [By file]
1 (0.147)
SELECT data
FROM `oc_session`
WHERE session_id = 'a0801f5ae5ee34125118b0cfcf'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.088)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (594.385)
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 (pd.tag LIKE "%nada%(groundbait)%") 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 (0.268)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (4.746)
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 700, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.134)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.139)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.961)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1248
9 (0.113)
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:1270
10 (0.254)
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:1035
11 (9.920)
SELECT COUNT(1) 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:949
12 (0.177)
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