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 - Lanterne si Felinare

Produse ce potrivesc criteriilor de căutare


Suport de Perete pentru Lansete Berkley Horizontal BRMH4 Rod Rack 4 Posturi

Suport de Perete pentru Lansete Berkley Horizontal BRMH4 Rod Rack 4 Posturi

1546007
Livrare imediată!

76,46Lei

Suport Lansete Nytro Continental Feeder, 30cm
Exclusiv online!

Suport Lansete Nytro Continental Feeder, 30cm

21900001
Livrare 48-72 ore

64,77Lei

Suport Spate Lanseta Carp Spirit Butt Rest

Suport Spate Lanseta Carp Spirit Butt Rest

acc370024
Livrare imediată!

18,00Lei

Valiza Jackall Tackle Container R fara Suporturi Lanseta, Marime M
Exclusiv online!

Valiza Jackall Tackle Container R fara Suporturi Lanseta, Marime M

ja.807246933
Livrare 24-48 ore

720,59Lei

Cap Suport Mikado Rod Rest Grip 5020, Black/Orange
Exclusiv online!

Cap Suport Mikado Rod Rest Grip 5020, Black/Orange

amp02-5020
Livrare 48-72 ore

10,00Lei

Geanta Spinning cu Suport Lansete Carp Zoom EVA Tackle Bag 50x28x30cm
Exclusiv online!

Geanta Spinning cu Suport Lansete Carp Zoom EVA Tackle Bag 50x28x30cm

cz0113
Livrare 48-72 ore

281,99Lei

Suport Coghlans pentru 12 Oua
Exclusiv online!

Suport Coghlans pentru 12 Oua

c511a
Livrare 24-48 ore

30,00Lei

Suport de Perete pentru Lansete Berkley Twist Lock Utility 4 Rod Rack

Suport de Perete pentru Lansete Berkley Twist Lock Utility 4 Rod Rack

1546010
Livrare imediată!

84,95Lei

Suport, Lanseta, DAM, Sand, Spike, Madcat, 97cm, a6.mad.56746, Picheti, Picheti DAM, Picheti DAM, DAM
Exclusiv online!

Suport, Lanseta, DAM, Sand, Spike, Madcat, 97cm, a6.mad.56746, Picheti, Picheti DAM, Picheti DAM, DAM

a6.mad.56746
Livrare 24-48 ore

256,30Lei

Suport Lansete Rive 12 Posturi, 36mm, 4 Picioare Telescopice 50-90cm
Exclusiv online!

Suport Lansete Rive 12 Posturi, 36mm, 4 Picioare Telescopice 50-90cm

42410320135
Livrare 48-72 ore

411,66Lei

Suport, Lansete, Rulou, Garbolino, 40cm, Strike, 42405gomeg3010400-2r, Suporturi Rubesiene, Suporturi Rubesiene Garbolino, Garbolino
Exclusiv online!

Suport, Lansete, Rulou, Garbolino, 40cm, Strike, 42405gomeg3010400-2r, Suporturi Rubesiene, Suporturi Rubesiene Garbolino, Garbolino

42405gomeg3010400-2r
Livrare 48-72 ore

142,87Lei

Suport, Lansete, Shakespeare, Superteam, Solo, Roost, Size, M,, 73x18x16cm, 1550545, Suporturi Feeder, Suporturi Feeder Shakespeare, Suporturi Shakespeare, Feeder Shakespeare, Shakespeare
Suport Rive D36 Multiple Functiuni, 43cm

Suport Rive D36 Multiple Functiuni, 43cm

90810104030
Livrare imediată!

251,97Lei

Cap Suport Mikado Feeder Grip5011 Back Rest, Black/Blue
Exclusiv online!

Cap Suport Mikado Feeder Grip5011 Back Rest, Black/Blue

amp02-5011
Livrare 48-72 ore

30,00Lei

Cap Suport Mikado Front Rod Rest Grip5009, Black
Exclusiv online!

Cap Suport Mikado Front Rod Rest Grip5009, Black

amp02-5009
Livrare 48-72 ore

12,99Lei

Cap Suport Mikado Rod Rest Grip 5013, Black/Orange
Exclusiv online!

Cap Suport Mikado Rod Rest Grip 5013, Black/Orange

amp02-5013
Livrare 48-72 ore

15,01Lei

Cap, Suport, Mikado, Suport, Feeder5005, Front, Rest, amp02-5005, Capete Suport Feeder, Capete Suport Feeder Mikado, Mikado
Cap Suport Team Feeder By Dome
Exclusiv online!

Cap Suport Team Feeder By Dome

7325-019
Livrare 48-72 ore

24,00Lei

Pichet Telescopic Suport Sonik Stanz Camlock Bankstick, 46cm
Exclusiv online!

Pichet Telescopic Suport Sonik Stanz Camlock Bankstick, 46cm

hc0026
Livrare 48-72 ore

66,76Lei

Scaun Cutie Konger No.2, 365x232x275mm, Suporta Maxim 140kg
Exclusiv online!

Scaun Cutie Konger No.2, 365x232x275mm, Suporta Maxim 140kg

90306850900002
Livrare 48-72 ore

164,03Lei

Afişare 181 - 200 din 1328 (67 pagini)
Queries: 14, Total time: 219.309 ms [By time] [By id] [By file]
1 (0.170)
SELECT data
FROM `oc_session`
WHERE session_id = '14483aa7842fc769e24b6dc280'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.153)
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.064)
DROP TEMPORARY TABLE IF EXISTS oc_bf_tmp_product
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:692
5 (202.336)
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 = '0' AND (pd.tag LIKE "%suport%") 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.248)
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 (5.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 180, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
8 (1.393)
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
9 (0.081)
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
10 (0.254)
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
11 (8.527)
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
12 (0.112)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.101)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
14 (0.121)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38