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 300 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


Cicada Siliconica Percamax Grim Classic YO, 5.5cm, 13g

Cicada Siliconica Percamax Grim Classic YO, 5.5cm, 13g

dream-m13-yo
Stoc epuizat

28,00Lei

Cicada Siliconica Percamax Grim Classic YW, 6.5cm, 20gr, 1buc/pac

Cicada Siliconica Percamax Grim Classic YW, 6.5cm, 20gr, 1buc/pac

dream-m20-yw
Stoc epuizat

28,00Lei

Cleste Abu Garcia Long Nose, 15cm

Cleste Abu Garcia Long Nose, 15cm

1196003
Stoc epuizat

71,28Lei

Creatura Delphin MANYA UVs YELLA, 10.5cm , 5buc/pac

Creatura Delphin MANYA UVs YELLA, 10.5cm , 5buc/pac

101003856
Stoc epuizat

19,00Lei

Creatura DuoPACK BOX Nymfa Delphin MANYA UVs BRICK, 10.5cm, 30buc/pac

Creatura DuoPACK BOX Nymfa Delphin MANYA UVs BRICK, 10.5cm, 30buc/pac

101003389
Stoc epuizat

114,00Lei

Creatura DuoPACK BOX Nymfa Delphin MANYA UVs MIX, 10.5cm, 30buc/pac

Creatura DuoPACK BOX Nymfa Delphin MANYA UVs MIX, 10.5cm, 30buc/pac

101003392
Stoc epuizat

114,00Lei

Cutie Mikado Pentru Accesorii H339 10.5x7x2.5cm

Cutie Mikado Pentru Accesorii H339 10.5x7x2.5cm

uach-h339
Stoc epuizat

5,50Lei

Cutie Naluci Reiva 33.1x22x5cm

Cutie Naluci Reiva 33.1x22x5cm

4541-003
Stoc epuizat

63,00Lei

Geanta Minciog Matrix Aquos PVC Net Bag, 60x15x55cm

Geanta Minciog Matrix Aquos PVC Net Bag, 60x15x55cm

glu177
Stoc epuizat

188,96Lei

Hamac Ticket to the Moon Compact Burgundy, 320x155cm

Hamac Ticket to the Moon Compact Burgundy, 320x155cm

tmc34
Stoc epuizat

225,01Lei

Hamac Ticket to the Moon Compact Royal Blue, 320x155cm

Hamac Ticket to the Moon Compact Royal Blue, 320x155cm

tmc39
Stoc epuizat

225,01Lei

Husa Hamac Coyote Brown DD Hammocks 2.8mx15cm

Husa Hamac Coyote Brown DD Hammocks 2.8mx15cm

610370637142
Stoc epuizat

75,01Lei

Husa Hamac XL Camuflaj DD Hammocks 2.8mx15cm

Husa Hamac XL Camuflaj DD Hammocks 2.8mx15cm

705422505484
Stoc epuizat

90,00Lei

Lant Hanger Radical Free Climber Chain 15cm

Lant Hanger Radical Free Climber Chain 15cm

6705103
Stoc epuizat

17,78Lei

Minciog DAM Fly 40X28X25cm

Minciog DAM Fly 40X28X25cm

a2.dam.8231001
Stoc epuizat

101,50Lei

Montura Nash Cling On Unleaded Leader, 45lbs, 75cm, 3buc/plic

Montura Nash Cling On Unleaded Leader, 45lbs, 75cm, 3buc/plic

t8189
Stoc epuizat

29,35Lei

Montura Nash Ready Tied Unleaded Helicopter Leader, 45lbs, 75cm, 3buc/plic
Pelerina cu Gluga Helikon Tex Poncho U.S Olive Green, 210x145cm

Pelerina cu Gluga Helikon Tex Poncho U.S Olive Green, 210x145cm

po-mus-po-02
Stoc epuizat

160,00Lei

Pelerina cu Gluga Helikon Tex Poncho Woodland US, 210x145cm

Pelerina cu Gluga Helikon Tex Poncho Woodland US, 210x145cm

po-mus-po-03
Stoc epuizat

160,00Lei

Pilker Abu Garcia Hard Bait Sillen, Holo White Blue, 250g, 15cm

Pilker Abu Garcia Hard Bait Sillen, Holo White Blue, 250g, 15cm

1096781
Stoc epuizat

48,71Lei

Afişare 8061 - 8080 din 8241 (413 pagini)
Queries: 16, Total time: 428.038 ms [By time] [By id] [By file]
1 (0.145)
SELECT data
FROM `oc_session`
WHERE session_id = 'd42e081175b1fc98f9f09fc500'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.148)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.061)
DROP TEMPORARY TABLE IF EXISTS oc_bf_tmp_product
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:692
5 (308.235)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (pd.tag LIKE "%5cm%") 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:693
6 (0.636)
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:1547
7 (35.647)
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 8060, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
8 (0.165)
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
9 (0.109)
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
10 (5.304)
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:1204
11 (0.128)
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:1223
12 (1.316)
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:978
13 (75.692)
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:900
14 (0.117)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
15 (0.113)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
16 (0.120)
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