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


Naluca - M-Area Maggot- 34Mm/Pink - 16Buc
Exclusiv online!

Naluca - M-Area Maggot- 34Mm/Pink - 16Buc

pmma-34-pi
Livrare 48-72 ore

29,00Lei

Pop Up MAINLINE Ziggers, Pink / Yellow / Black
Exclusiv online!

Pop Up MAINLINE Ziggers, Pink / Yellow / Black

a0.m.m34003
Livrare 24-48 ore

65,63Lei

Pop Up Nash Scopex Squid 2024, Pink, 12mm, 75g

Pop Up Nash Scopex Squid 2024, Pink, 12mm, 75g

b6325
Livrare imediată!

44,05Lei

Porumb Artificial Korda Slow Sinking Maize IB, Pink, 10buc/pac
Exclusiv online!

Porumb Artificial Korda Slow Sinking Maize IB, Pink, 10buc/pac

a.kpb45
Livrare 24-48 ore

19,87Lei

Swimbait RAID Head Swimmer Libero, 010 Pink Trick, 10g, 2buc/pac

Swimbait RAID Head Swimmer Libero, 010 Pink Trick, 10g, 2buc/pac

raid16223
Livrare imediată!

69,00Lei

Swimbait RAID Head Swimmer Libero, 010 Pink Trick, 5g, 2buc/pac

Swimbait RAID Head Swimmer Libero, 010 Pink Trick, 5g, 2buc/pac

raid49798
Livrare imediată!

69,00Lei

Aditiv Nash Scopex Squid Cold Liquid, Pink,100ml
Exclusiv online!

Aditiv Nash Scopex Squid Cold Liquid, Pink,100ml

b6370
Livrare 7-14 zile

58,75Lei

Grub Hide Up Stagger Wide 1.5" Salt, S-08 Glow Pink, 3.8cm, 8buc/pac

Grub Hide Up Stagger Wide 1.5" Salt, S-08 Glow Pink, 3.8cm, 8buc/pac

hide80316
Livrare imediată!

28,00Lei

Pop Up Nash Monster Shrimp New, Pink, 20mm, 75g
Exclusiv online!

Pop Up Nash Monster Shrimp New, Pink, 20mm, 75g

b6527
Livrare 7-14 zile

44,05Lei

Shad Mustad Mezashi Tail Minnow, Shocking Pink, 8.8cm, 6buc/pac -20%
Exclusiv online!

Shad Mustad Mezashi Tail Minnow, Shocking Pink, 8.8cm, 6buc/pac

f1.mktm.sk.3.5
Livrare 24-48 ore

24,26Lei(-20%) 19,42Lei

Shad Reins Rockvibe, Clear Pink, 7.6cm, 12buc/plic

Shad Reins Rockvibe, Clear Pink, 7.6cm, 12buc/plic

reins-rs3b30
Livrare imediată!

26,91Lei

Shad Zeck Dude 6.4cm, 2g, Purple Pink, 1buc/pac

Shad Zeck Dude 6.4cm, 2g, Purple Pink, 1buc/pac

130105220195
Livrare imediată!

4,00Lei

Spinnerbait IMA Adelie 8, 005 Matt Pink Sardine, 1.8cm, 8g

Spinnerbait IMA Adelie 8, 005 Matt Pink Sardine, 1.8cm, 8g

al8-005
Livrare imediată!

72,00Lei

Swimbait RAID Head Swimmer Libero, 010 Pink Trick, 14g, 2buc/pac

Swimbait RAID Head Swimmer Libero, 010 Pink Trick, 14g, 2buc/pac

raid16322
Livrare imediată!

69,00Lei

Taparina Golden Catch Pink Nr.8, 5 Carlige, 1buc/plic

Taparina Golden Catch Pink Nr.8, 5 Carlige, 1buc/plic

gcz-4339035
Livrare imediată!

7,50Lei

Vobler Herakles Waving 48, Pink Parr, 4.8cm, 4.3g
Exclusiv online!

Vobler Herakles Waving 48, Pink Parr, 4.8cm, 4.3g

hkwav4806
Livrare 48-72 ore

66,00Lei

Cicada IMA Schneider 18, 013 Pink Back Orange Belly, 6.8cm, 18.0g

Cicada IMA Schneider 18, 013 Pink Back Orange Belly, 6.8cm, 18.0g

sd18-013
Livrare imediată!

67,00Lei

Naluca Power Bait Power Flail, Pink White, 5cm, 12buc/plic

Naluca Power Bait Power Flail, Pink White, 5cm, 12buc/plic

1609955
Livrare imediată!

35,96Lei

Pop Up Nash Citruz New, Pink, 20mm, 75g
Exclusiv online!

Pop Up Nash Citruz New, Pink, 20mm, 75g

b6427
Livrare 7-14 zile

44,05Lei

Pop Up Nash Scopex Squid 2024, Pink, 20mm, 75g
Exclusiv online!

Pop Up Nash Scopex Squid 2024, Pink, 20mm, 75g

b6327
Livrare 7-14 zile

44,05Lei

Afişare 161 - 180 din 751 (38 pagini)
Queries: 9, Total time: 26.246 ms [By time] [By id] [By file]
1 (0.115)
SELECT data
FROM `oc_session`
WHERE session_id = 'eceefc24078063ad3923076487'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (17.551)
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 = '3' AND (MATCH(pd.tag) AGAINST('+pink' 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 (0.167)
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 (0.795)
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
6 (0.112)
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
7 (0.208)
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
8 (7.011)
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
9 (0.182)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38