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


Ventilator Portabil + Baterie Externa Wolf Voltair Portable Fan & Powerbank, Black

Ventilator Portabil + Baterie Externa Wolf Voltair Portable Fan & Powerbank, Black

wfpt018-blk
Livrare imediată!

458,99Lei

Toaleta Portabila Wolf Compact Porta Loo

Toaleta Portabila Wolf Compact Porta Loo

wfod001
Livrare imediată!

299,95Lei

ARAGAZ PORTABIL NGT DYNAMIC VALIGETA TRANSPORT

ARAGAZ PORTABIL NGT DYNAMIC VALIGETA TRANSPORT

ngt-od-stove-dynamic
Livrare imediată!

349,99Lei

Convertor Rebelcell portabil Range Extender 12.6V/13A
Exclusiv online!

Convertor Rebelcell portabil Range Extender 12.6V/13A

dc12v13arepk
Livrare 48-72ore

1.945,00Lei

Husa Lansete cu Mulineta Delphin CLASSA Porta CASE 155cm

Husa Lansete cu Mulineta Delphin CLASSA Porta CASE 155cm

101003678
Livrare imediată!

154,00Lei

Lanseta Konger Streeto Twitch Portable 1904ML, 7-21g, 2.00m, 4seg
Exclusiv online!

Lanseta Konger Streeto Twitch Portable 1904ML, 7-21g, 2.00m, 4seg

20406161005200
Livrare 48-72 ore

529,04Lei

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

Lanseta Konger Streeto Twitch Portable 1904ML, 7-21g, 1.90m, 4seg
Exclusiv online!

Lanseta Konger Streeto Twitch Portable 1904ML, 7-21g, 1.90m, 4seg

20406161005190
Livrare 48-72 ore

509,13Lei

Valigeta Scaun Konger No.1, 365x232x365mm, Suporta Maxim 140kg

Valigeta Scaun Konger No.1, 365x232x365mm, Suporta Maxim 140kg

90306850900001
Livrare imediată!

170,02Lei

Nebo Rambler PS100 Hand-held, Portable Power Station 26AH, 22.4x13x4.1cm

Nebo Rambler PS100 Hand-held, Portable Power Station 26AH, 22.4x13x4.1cm

neb-pst-0004-g
Livrare imediată!

1.204,80Lei

Incalzitor Mr. Heater Portable Buddy - MH8BXDF

Incalzitor Mr. Heater Portable Buddy - MH8BXDF

mh8bxdf
Livrare imediată!

999,01Lei

ARAGAZ PORTABIL NGT

ARAGAZ PORTABIL NGT

ngt-od-stove-05
Livrare imediată!

175,00Lei

Husa 2 compartimente Delphin PORTA Pocket 390-3/buzunare adanci 150cm -24%

Husa 2 compartimente Delphin PORTA Pocket 390-3/buzunare adanci 150cm

430406146
Livrare imediată!

211,00Lei(-24%) 160,00Lei

Dus Portabil 20L Carp Spirit -29%

Dus Portabil 20L Carp Spirit

126300360
Livrare imediată!

69,00Lei(-29%) 49,00Lei

Toaleta portabila Campingaz 20l -24%
Exclusiv online!

Toaleta portabila Campingaz 20l

2000030582
Livrare 24-48 ore

790,01Lei(-24%) 599,00Lei

Husa, 2, Compartimente, Delphin, PORTA, 360, 430406131, Huse Lansete cu Mulinete, Huse Lansete cu Mulinete Delphin, Delphin -50%

Husa, 2, Compartimente, Delphin, PORTA, 360, 430406131, Huse Lansete cu Mulinete, Huse Lansete cu Mulinete Delphin, Delphin

430406131
Livrare imediată!

198,00Lei(-50%) 99,00Lei

Husa 2 compartimente Delphin PORTA Pocket 390-2/buzunare adanci 215cm -50%

Husa 2 compartimente Delphin PORTA Pocket 390-2/buzunare adanci 215cm

430406147
Livrare imediată!

264,00Lei(-50%) 131,99Lei

Husa, 2, Compartimente, Delphin, PORTA, Pocket, 360, 2, buzunare, adanci, 200cm, 430406196, Huse Lansete cu Mulinete, Huse Lansete cu Mulinete Delphin, Delphin -35%
Husa, 2, Compartimente, Delphin, PORTA, 300, 430406170, Huse Lansete cu Mulinete, Huse Lansete cu Mulinete Delphin, Delphin -24%

Husa, 2, Compartimente, Delphin, PORTA, 300, 430406170, Huse Lansete cu Mulinete, Huse Lansete cu Mulinete Delphin, Delphin

430406170
Livrare imediată!

195,01Lei(-24%) 148,60Lei

Cantar Digital Delphin SPORTA pana la 50kg -30%

Cantar Digital Delphin SPORTA pana la 50kg

921000020
Livrare imediată!

56,00Lei(-30%) 39,00Lei

Afişare 1 - 20 din 58 (3 pagini)
Queries: 14, Total time: 193.761 ms [By time] [By id] [By file]
1 (0.121)
SELECT data
FROM `oc_session`
WHERE session_id = 'eaec8c0b743910f79291db6b59'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.071)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (191.269)
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 "%porta%") 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:697
5 (0.140)
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
6 (0.676)
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 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
7 (0.126)
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.216)
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.070)
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.063)
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:982
11 (0.583)
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:904
12 (0.106)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.106)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
14 (0.111)
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