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

Produse ce potrivesc criteriilor de căutare


Geanta Impermeabila Guru Fusion Cool
Exclusiv online!

Geanta Impermeabila Guru Fusion Cool

glg023
Livrare 7-14 zile

319,57Lei

CROSETA KORDA BASIX PT. BOILIES VERDE

CROSETA KORDA BASIX PT. BOILIES VERDE

kbx023
Livrare imediată!

18,54Lei

VOBLER SALMO LIL BUG 3CM 4.3G BG3 MBG

VOBLER SALMO LIL BUG 3CM 4.3G BG3 MBG

qbg003
Livrare imediată!

44,96Lei

Cutie Fox Rage Storage Boxes Compartimentata, Medium, 28x18.5x4cm
Exclusiv online!

Cutie Fox Rage Storage Boxes Compartimentata, Medium, 28x18.5x4cm

nbx023
Livrare 7-14 zile

40,46Lei

Cutie Jaxon Fly 2A 11x8x4cm
Exclusiv online!

Cutie Jaxon Fly 2A 11x8x4cm

rj-hb02a
Livrare 48-72 ore

57,00Lei

Cutie Jaxon Fly 2C 11x8x4cm
Exclusiv online!

Cutie Jaxon Fly 2C 11x8x4cm

rj-hb02c
Livrare 48-72 ore

57,00Lei

Shad Relax Kopyto Head, 7.5cm, H023, 4buc/plic
Exclusiv online!

Shad Relax Kopyto Head, 7.5cm, H023, 4buc/plic

bls3-h023-b
Livrare 48-72ore

11,00Lei

Atractant Sticky Baits Hemp Oil, 500ml

Atractant Sticky Baits Hemp Oil, 500ml

ing023
Livrare imediată!

25,00Lei

Vobler SALMO Lil' Bug, Hinomaru, 2cm, 2.8g, 1buc/pac

Vobler SALMO Lil' Bug, Hinomaru, 2cm, 2.8g, 1buc/pac

qbg020
Livrare imediată!

38,21Lei

BUZZ BAR FOX 2 Rod Narrow 95mm/110mm 2BUC PER SET
Exclusiv online!

BUZZ BAR FOX 2 Rod Narrow 95mm/110mm 2BUC PER SET

cbb023
Livrare 7-14 zile

179,96Lei

Vobler SALMO Lil' Bug, Hinomaru, 3cm, 4.3g, 1buc/pac
Exclusiv online!

Vobler SALMO Lil' Bug, Hinomaru, 3cm, 4.3g, 1buc/pac

qbg022
Livrare 7-14 zile

44,96Lei

Vobler SALMO Lil' Bug, Clear Ayu, 3cm, 4.3g, 1buc/pac
Exclusiv online!

Vobler SALMO Lil' Bug, Clear Ayu, 3cm, 4.3g, 1buc/pac

qbg021
Livrare 7-14 zile

44,96Lei

Aroma Lichida Rod Hutchinson Legend Flavour, Mega Tutti Frutti, 50ml

Aroma Lichida Rod Hutchinson Legend Flavour, Mega Tutti Frutti, 50ml

hb0033
Livrare imediată!

55,00Lei

Carlige Jaxon Sumato Chinu Galben nr.2
Exclusiv online!

Carlige Jaxon Sumato Chinu Galben nr.2

hy-hba02
Livrare 48-72 ore

5,50Lei

Carlige Jaxon Sumato Chinu Negru nr.2
Exclusiv online!

Carlige Jaxon Sumato Chinu Negru nr.2

hy-hbb02
Livrare 48-72 ore

5,00Lei

Suport Matrix 3D-R Cross Arm Long pentru Scaun Modular 43cm

Suport Matrix 3D-R Cross Arm Long pentru Scaun Modular 43cm

gba023
Livrare imediată!

107,96Lei

Fir Textil Scufundator Fox Submerge Bright Orange Sinking Braid 600m, 0.20mm, 40lb

Fir Textil Scufundator Fox Submerge Bright Orange Sinking Braid 600m, 0.20mm, 40lb

cbl023
Livrare imediată!

404,96Lei

Carlige Jaxon Sumato Chinu Cu Ochet Negru nr.2

Carlige Jaxon Sumato Chinu Cu Ochet Negru nr.2

hy-hbc02
Livrare imediată!

5,00Lei

Carlige Jaxon Sumato Iseama Negru HY-HGB nr.2
Exclusiv online!

Carlige Jaxon Sumato Iseama Negru HY-HGB nr.2

hy-hgb02
Livrare 48-72 ore

4,50Lei

Sita Interschimbabila Matrix Fine Mesh Riddle Insert, 33cm, 3mm

Sita Interschimbabila Matrix Fine Mesh Riddle Insert, 33cm, 3mm

gbt023
Livrare imediată!

80,96Lei

Afişare 1 - 20 din 21 (2 pagini)
Queries: 12, Total time: 2.039 ms [By time] [By id] [By file]
1 (0.135)
SELECT data
FROM `oc_session`
WHERE session_id = '934ddf6f04c1b0fc82e894cc34'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.082)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.149)
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.166)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("115414", "2", "1000", "160", "1", "268.550000000000", "1"),("127647", "2", "1007", "73", "1", "15.580000000000", "2"),("64784", "2", "1003", "185", "1", "37.780000000000", "3"),("223216", "2", "1000", "455", "1", "34.000000000000", "4"),("79565", "2", "1000", "42", "1", "47.900000000000", "5"),("79568", "2", "1000", "42", "1", "47.900000000000", "6"),("44702", "2", "1000", "48", "1", "9.240000000000", "7"),("222237", "2", "5", "342", "1", "29.363200000000", "8"),("219866", "1", "1005", "455", "1", "32.110000000000", "9"),("111620", "2", "1000", "168", "1", "151.230000000000", "10"),("219868", "1", "1000", "455", "1", "37.780000000000", "11"),("219867", "1", "1000", "455", "1", "37.780000000000", "12"),("179897", "2", "11", "473", "1", "46.220000000000", "13"),("39218", "2", "1000", "42", "1", "4.620000000000", "14"),("39224", "2", "1000", "42", "1", "4.200000000000", "15"),("83215", "2", "1003", "368", "1", "90.720000000000", "16"),("184935", "2", "1", "168", "1", "340.300000000000", "17"),("39230", "2", "1002", "42", "1", "4.200000000000", "18"),("39385", "2", "1000", "42", "1", "3.780000000000", "19"),("164955", "1", "1001", "368", "1", "68.030000000000", "20"),("79567", "2", "0", "42", "1", "37.000000000000", "21")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.133)
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.260)
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.123)
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.267)
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.097)
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.075)
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.418)
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.134)
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