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


Vobler Kenart Hunter Floating 3cm 2.5gr TR Trout Real 1 buc/pac

Vobler Kenart Hunter Floating 3cm 2.5gr TR Trout Real 1 buc/pac

hu3f-tr
Livrare imediată!

21,50Lei

Vobler Kenart Diver Floating 4cm 3gr TR Trout Real 1 buc/pac
Exclusiv online!

Vobler Kenart Diver Floating 4cm 3gr TR Trout Real 1 buc/pac

div4f-tr
Livrare 48-72ore

21,50Lei

Fir ASSO Trout Area Nylon Hard Grey 0.128mm 100m -28%

Fir ASSO Trout Area Nylon Hard Grey 0.128mm 100m

111108106
Livrare imediată!

45,45Lei(-28%) 32,90Lei

Fir Monofilment Rapture Spin Trout 0.25mm 8.46kg 150m
Exclusiv online!

Fir Monofilment Rapture Spin Trout 0.25mm 8.46kg 150m

051-96-250
Livrare 48-72 ore

36,00Lei

FIR MONOFILAMENT DAIWA SAMURAI TROUT 020MM 3.1KG 500M -30%
Exclusiv online!

FIR MONOFILAMENT DAIWA SAMURAI TROUT 020MM 3.1KG 500M

d.12812.020
Livrare 24-48 ore

24,80Lei(-30%) 17,36Lei

Vobler Gunki Gamera 63HW Gold Trout 6,3 cm 6.4g

Vobler Gunki Gamera 63HW Gold Trout 6,3 cm 6.4g

spm.37122
Livrare imediată!

38,65Lei

Vobler Kenart Hunter Floating 3cm 2.5gr RTR Rainbow Trout 1 buc/pac

Vobler Kenart Hunter Floating 3cm 2.5gr RTR Rainbow Trout 1 buc/pac

hu3f-rtr
Livrare imediată!

21,50Lei

Vobler Salmo Minnow M5S Trout 5cm 5g
Exclusiv online!

Vobler Salmo Minnow M5S Trout 5cm 5g

84425524
Livrare 24-48 ore

37,00Lei

Vobler Rapture Pro Trout Fry Silver 4.8cm 4g
Exclusiv online!

Vobler Rapture Pro Trout Fry Silver 4.8cm 4g

180-16-901
Livrare 48-72 ore

26,00Lei

Oscilanta DAM Effzett Pro Trout Black Blue No.6 33.5mm 3.3g
Exclusiv online!

Oscilanta DAM Effzett Pro Trout Black Blue No.6 33.5mm 3.3g

13042960195
Livrare 48-72 ore

10,56Lei

Oscilanta DAM Effzett Pro Trout Golden Lime UV No.1 22.5mm 1.2g
Exclusiv online!

Oscilanta DAM Effzett Pro Trout Golden Lime UV No.1 22.5mm 1.2g

13042960179
Livrare 48-72 ore

10,56Lei

Grub Quantum Magic Trout T-Worm Paddler 5.5cm culoare Neon Green Black -38%

Grub Quantum Magic Trout T-Worm Paddler 5.5cm culoare Neon Green Black

3279401
Livrare imediată!

22,28Lei(-38%) 13,90Lei

Vobler Rapture Pro Trout Fry Silver 3.6cm 2g
Exclusiv online!

Vobler Rapture Pro Trout Fry Silver 3.6cm 2g

180-16-701
Livrare 48-72 ore

26,00Lei

Shad Quantum Magic Trout T-Worm Paddler 5.5cm culoare Neon Green Orange -56%

Shad Quantum Magic Trout T-Worm Paddler 5.5cm culoare Neon Green Orange

3279402
Livrare imediată!

22,28Lei(-56%) 9,90Lei

VOBLER FIISH PW TAIL 30 3.8GR FAST TROUT PWT547
Exclusiv online!

VOBLER FIISH PW TAIL 30 3.8GR FAST TROUT PWT547

3700696805473
Livrare 48-72 ore

50,00Lei

Vobler Sakura Phoxy Minnow 40 S 40mm 2.6 g T08 Black Fury Trout
Exclusiv online!

Vobler Sakura Phoxy Minnow 40 S 40mm 2.6 g T08 Black Fury Trout

80434saplc505540-t08
Livrare 48-72 ore

48,18Lei

Grub Quantum Magic Trout T-Worm Paddler 5.5cm culoare Neon Pink -56%

Grub Quantum Magic Trout T-Worm Paddler 5.5cm culoare Neon Pink

3279405
Livrare imediată!

22,28Lei(-56%) 9,90Lei

Vobler Daiwa Prorex Mini Popper Live Brown Trout 5.5cm 5.7g
Exclusiv online!

Vobler Daiwa Prorex Mini Popper Live Brown Trout 5.5cm 5.7g

f3.d15208.009
Livrare 24-48 ore

44,84Lei

Shad Quantum Magic Trout T-Worm Paddler 5.5cm culoare Neon Yellow Black -56%

Shad Quantum Magic Trout T-Worm Paddler 5.5cm culoare Neon Yellow Black

3279403
Livrare imediată!

22,28Lei(-56%) 9,90Lei

Shad Quantum Magic Trout T-Worm Paddler 5.5cm culoare Neon Orange -56%

Shad Quantum Magic Trout T-Worm Paddler 5.5cm culoare Neon Orange

3279404
Livrare imediată!

22,28Lei(-56%) 9,90Lei

Afişare 421 - 440 din 864 (44 pagini)
Queries: 11, Total time: 36.574 ms [By time] [By id] [By file]
1 (0.123)
SELECT data
FROM `oc_session`
WHERE session_id = 'a0e5dd6e9e9c318a448c44e9ec'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.075)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (23.398)
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('+trout' 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.187)
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 (3.660)
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 420, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (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
7 (0.764)
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
8 (0.079)
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
9 (0.187)
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
10 (7.809)
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
11 (0.169)
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