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 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


Vobler Rapture Hiroshi Minnow 5cm 2.5g CHT
Exclusiv online!

Vobler Rapture Hiroshi Minnow 5cm 2.5g CHT

180-08-018
Livrare 48-72 ore

25,30Lei

Vobler Rapture Hiroshi Minnow 5cm 2.5g Iwashi
Exclusiv online!

Vobler Rapture Hiroshi Minnow 5cm 2.5g Iwashi

180-08-010
Livrare 48-72 ore

25,30Lei

Vobler Rapture Hiroshi Minnow 5cm 2.5g HSP
Exclusiv online!

Vobler Rapture Hiroshi Minnow 5cm 2.5g HSP

180-08-030
Livrare 48-72 ore

25,30Lei

Vobler Rapture Hiroshi Minnow 5cm 2.5g Silver Sardine
Exclusiv online!

Vobler Rapture Hiroshi Minnow 5cm 2.5g Silver Sardine

180-08-012
Livrare 48-72 ore

25,30Lei

Vobler Rapture Hiroshi Minnow 5cm 2.5g Holo Bronze Gill
Exclusiv online!

Vobler Rapture Hiroshi Minnow 5cm 2.5g Holo Bronze Gill

180-08-050
Livrare 48-72 ore

25,30Lei

Vobler Minnow SEIKA Shallow Darter Galleggiante, Culoare.08, 14cm, 18g, 1buc/pac -12%
Exclusiv online!

Vobler Minnow SEIKA Shallow Darter Galleggiante, Culoare.08, 14cm, 18g, 1buc/pac

4566301
Livrare 7-14 zile

59,50Lei(-12%) 52,43Lei

Vobler Minnow SEIKA Shallow Darter Galleggiante, Culoare.08, 14cm, 18g, 1buc/pac -12%
Exclusiv online!

Vobler Minnow SEIKA Shallow Darter Galleggiante, Culoare.08, 14cm, 18g, 1buc/pac

4566308
Livrare 7-14 zile

59,50Lei(-12%) 52,43Lei

Vobler Sakura Chopsy Minnow 50 SP 50mm 4.50gr 048 Ayu
Exclusiv online!

Vobler Sakura Chopsy Minnow 50 SP 50mm 4.50gr 048 Ayu

130234saplh500950-048
Livrare 48-72 ore

53,87Lei

Shad Lucky John Minnow 8.4cm culoare 085 7buc/plicc -34%

Shad Lucky John Minnow 8.4cm culoare 085 7buc/plicc

140143-085
Livrare imediată!

20,00Lei(-34%) 13,10Lei

Vobler IMA Pugachevs Cobra Minnow Floating, Fegis, 208 Pink&Pink, 9cm, 12g, 1buc/pac
Exclusiv online!

Vobler IMA Pugachevs Cobra Minnow Floating, Fegis, 208 Pink&Pink, 9cm, 12g, 1buc/pac

pg90-208
Livrare 48-72 ore

116,92Lei

Vobler IMA Twing Minnow 60S Sinking, 008 Titanium Black Red Berry, 6cm, 6.5g, 1buc/pac
Exclusiv online!

Vobler IMA Twing Minnow 60S Sinking, 008 Titanium Black Red Berry, 6cm, 6.5g, 1buc/pac

tw60-008
Livrare 48-72 ore

100,65Lei

Vobler Owner Rip n Minnow 65mm 6.0gr 18 Red head
Exclusiv online!

Vobler Owner Rip n Minnow 65mm 6.0gr 18 Red head

804020306
Livrare 48-72 ore

49,67Lei

Vobler RAID JAPAN Level Minnow Quick72, 008 Real Kinkuro, 7.2cm, 5.2g

Vobler RAID JAPAN Level Minnow Quick72, 008 Real Kinkuro, 7.2cm, 5.2g

raid14731
Livrare imediată!

97,60Lei

Vobler Smith AR-HD Minnow 4.5cm 5.7g 03 HS
Exclusiv online!

Vobler Smith AR-HD Minnow 4.5cm 5.7g 03 HS

arh45s03
Livrare 24-48 ore

98,51Lei

Vobler Raid Level Minnow Floating, 018 Bait Japan, 14g, 12.5cm, 1buc/pac
Exclusiv online!

Vobler Raid Level Minnow Floating, 018 Bait Japan, 14g, 12.5cm, 1buc/pac

raid49484
Livrare 48-72 ore

114,88Lei

Vobler Raid Level Minnow Floating, 008 Just Bait, 14g, 12.5cm, 1buc/pac
Exclusiv online!

Vobler Raid Level Minnow Floating, 008 Just Bait, 14g, 12.5cm, 1buc/pac

raid34497
Livrare 48-72 ore

114,88Lei

Shad Lucky John Minnow Nagoya Shrimp 5.6cm 10buc/plic
Exclusiv online!

Shad Lucky John Minnow Nagoya Shrimp 5.6cm 10buc/plic

140142-085
Livrare 48-72ore

20,00Lei

Vobler Mikado Sheriff Minnow Floating, Culoare 03, 11cm, 1buc/pac
Exclusiv online!

Vobler Mikado Sheriff Minnow Floating, Culoare 03, 11cm, 1buc/pac

pwf-sf-11f-s03
Livrare 48-72 ore

37,50Lei

Vobler Minnow SEIKA Shallow Darter Galleggiante, Culoare.02, 14cm, 18g, 1buc/pac -12%
Exclusiv online!

Vobler Minnow SEIKA Shallow Darter Galleggiante, Culoare.02, 14cm, 18g, 1buc/pac

4566302
Livrare 7-14 zile

59,50Lei(-12%) 52,43Lei

Vobler Minnow SEIKA Shallow Darter Galleggiante, Culoare.07, 14cm, 18g, 1buc/pac -12%
Exclusiv online!

Vobler Minnow SEIKA Shallow Darter Galleggiante, Culoare.07, 14cm, 18g, 1buc/pac

4566307
Livrare 7-14 zile

59,50Lei(-12%) 52,43Lei

Afişare 1 - 20 din 47 (3 pagini)
Queries: 12, Total time: 2.187 ms [By time] [By id] [By file]
1 (0.083)
SELECT data
FROM `oc_session`
WHERE session_id = '95d0578f7394570ce127250031'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.156)
CREATE TEMPORARY TABLE oc_bf_tmp_product ( product_id int PRIMARY KEY, sort_order int, quantity int, manufacturer_id int, match_filters int, actual_price DECIMAL(10, 4), sort int, INDEX my_index (match_filters, sort_order, manufacturer_id) ) ENGINE=MEMORY
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:837
4 (0.292)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("118250", "2", "1000", "105", "1", "20.910000000000", "1"),("118244", "2", "1000", "105", "1", "20.910000000000", "2"),("118252", "2", "1000", "105", "1", "20.910000000000", "3"),("118249", "2", "1000", "105", "1", "20.910000000000", "4"),("118251", "2", "1000", "105", "1", "20.910000000000", "5"),("248669", "1", "1000", "811", "1", "43.330000000000", "6"),("248677", "1", "1000", "811", "1", "43.330000000000", "7"),("116082", "2", "1000", "123", "1", "44.520000000000", "8"),("131915", "2", "1", "193", "1", "10.830000000000", "9"),("230713", "1", "1000", "693", "1", "96.630000000000", "10"),("230955", "1", "1000", "693", "1", "83.180000000000", "11"),("59191", "2", "1000", "15", "1", "41.050000000000", "12"),("215337", "1", "1002", "729", "1", "80.660000000000", "13"),("102248", "1", "1000", "546", "1", "81.410000000000", "14"),("224837", "1", "1000", "729", "1", "94.940000000000", "15"),("224842", "1", "1000", "729", "1", "94.940000000000", "16"),("135439", "2", "1000", "193", "1", "16.810000000000", "17"),("225217", "1", "1000", "224", "1", "30.990000000000", "18"),("248674", "1", "1000", "811", "1", "43.330000000000", "19"),("248679", "1", "1000", "811", "1", "43.330000000000", "20"),("248680", "1", "1000", "811", "1", "43.330000000000", "21"),("248681", "1", "1000", "811", "1", "43.330000000000", "22"),("248682", "1", "1000", "811", "1", "43.330000000000", "23"),("248683", "1", "1000", "811", "1", "43.330000000000", "24"),("231879", "1", "0", "528", "1", "12.000000000000", "25"),("231880", "1", "0", "528", "1", "12.000000000000", "26"),("231881", "1", "0", "528", "1", "12.000000000000", "27"),("231882", "1", "0", "528", "1", "12.000000000000", "28"),("231883", "1", "0", "528", "1", "12.000000000000", "29"),("231884", "1", "0", "528", "1", "12.000000000000", "30"),("165326", "2", "0", "68", "1", "15.710000000000", "31"),("231958", "1", "0", "528", "1", "13.210000000000", "32"),("231959", "1", "0", "528", "1", "13.210000000000", "33"),("231960", "1", "0", "528", "1", "13.210000000000", "34"),("231961", "1", "0", "528", "1", "13.210000000000", "35"),("231962", "1", "0", "528", "1", "13.210000000000", "36"),("231974", "1", "0", "528", "1", "12.610000000000", "37"),("231975", "1", "0", "528", "1", "12.610000000000", "38"),("231976", "1", "0", "528", "1", "12.610000000000", "39"),("231977", "1", "0", "528", "1", "12.610000000000", "40"),("231978", "1", "0", "528", "1", "12.610000000000", "41"),("231979", "1", "0", "528", "1", "13.810000000000", "42"),("231980", "1", "0", "528", "1", "13.810000000000", "43"),("231981", "1", "0", "528", "1", "13.810000000000", "44"),("231983", "1", "0", "528", "1", "13.810000000000", "45"),("231984", "1", "0", "528", "1", "13.810000000000", "46"),("59199", "2", "0", "15", "1", "28.160000000000", "47")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.084)
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:1593
6 (0.192)
SELECT p.*
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2' LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.099)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.177)
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:1393
9 (0.075)
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:1415
10 (0.065)
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:1180
11 (0.696)
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:1094
12 (0.178)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37