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


Boilies Solubil de Carlig MAINLINE Shelf Life, Cell, 20mm, 1kg
Exclusiv online!

Boilies Solubil de Carlig MAINLINE Shelf Life, Cell, 20mm, 1kg

a0.m.m41003
Livrare 24-48 ore

74,98Lei

Boilies Solubil de Carlig MAINLINE Shelf Life, Essential Cell, 20mm, 1kg
Exclusiv online!

Boilies Solubil de Carlig MAINLINE Shelf Life, Essential Cell, 20mm, 1kg

a0.m.m41004
Livrare 24-48 ore

74,98Lei

Rebel-cell Incarcator Waterproof Baterie Li-ion 12.6V20A -4%
Exclusiv online!

Rebel-cell Incarcator Waterproof Baterie Li-ion 12.6V20A

ri12.6v20awp
Livrare 48-72ore

1.447,50Lei(-4%) 1.382,99Lei

Rebel-cell Incarcator Waterproof Baterie Li-ion 29.4V20A -4%
Exclusiv online!

Rebel-cell Incarcator Waterproof Baterie Li-ion 29.4V20A

ri29.4v20awp
Livrare 48-72ore

1.447,50Lei(-4%) 1.382,99Lei

Pop Up Mainline Critic Echilibrat Cork Dust Wafters The Cell 14mm
Exclusiv online!

Pop Up Mainline Critic Echilibrat Cork Dust Wafters The Cell 14mm

a0.m.m21057
Livrare 24-48 ore

51,74Lei

Rebel-cell Incarcator Baterie Li-ion 29.4V12A
Exclusiv online!

Rebel-cell Incarcator Baterie Li-ion 29.4V12A

ri29.4v12a
Livrare 48-72ore

905,99Lei

Pelete Mainline Match Carp Cell 1Kg 4mm
Exclusiv online!

Pelete Mainline Match Carp Cell 1Kg 4mm

a0.m.mm3206
Livrare 24-48 ore

32,85Lei

Pelete Mainline Match Carp Cell 1Kg 6mm
Exclusiv online!

Pelete Mainline Match Carp Cell 1Kg 6mm

a0.m.mm3207
Livrare 24-48 ore

32,85Lei

WAFTERS MAINLINE MATCH DUMBELL WHITE CELL.TM 6MM
Exclusiv online!

WAFTERS MAINLINE MATCH DUMBELL WHITE CELL.TM 6MM

a0.m.mm3110
Livrare 24-48 ore

30,57Lei

Pop Up Mainline Critic Echilibrat Match Wafters White Cell 8mm
Exclusiv online!

Pop Up Mainline Critic Echilibrat Match Wafters White Cell 8mm

a0.m.mm3102
Livrare 24-48 ore

28,03Lei

POP UP MAINLINE WAFTERS MATCH DUMBELL WHITE CELL.TM 8MM

POP UP MAINLINE WAFTERS MATCH DUMBELL WHITE CELL.TM 8MM

a0.m.mm3106
Livrare imediată!

30,57Lei

Baterie Navomodel Terra Cell 16.8 V 16 Ah 4s

Baterie Navomodel Terra Cell 16.8 V 16 Ah 4s

4195236575838
Livrare imediată!

567,59Lei

Baterie Terra Cell 12V 11.2Ah

Baterie Terra Cell 12V 11.2Ah

ter1
Livrare imediată!

305,00Lei

Baterie Navomodel Terra Cell 16.8 V, 12.5 Ah, 4s

Baterie Navomodel Terra Cell 16.8 V, 12.5 Ah, 4s

terr12.5ah
Livrare imediată!

614,00Lei

Baterie Navomodel Terra Cell 16.8 V 19.2 Ah 4s

Baterie Navomodel Terra Cell 16.8 V 19.2 Ah 4s

5195237863209
Livrare imediată!

660,45Lei

Baterie Navomodel Terra Cell 16.8V 12.8 Ah

Baterie Navomodel Terra Cell 16.8V 12.8 Ah

8195234890380
Livrare imediată!

531,00Lei

Baterie Terra Cell 12V 14Ah

Baterie Terra Cell 12V 14Ah

ter2
Livrare imediată!

357,00Lei

Baterie Terra Cell 12V 16.8Ah

Baterie Terra Cell 12V 16.8Ah

ter3
Livrare imediată!

410,00Lei

Baterie Navomodel Terra Cell 16.8 V, 15.0 Ah, 4s

Baterie Navomodel Terra Cell 16.8 V, 15.0 Ah, 4s

terr15ah
Livrare imediată!

651,50Lei

Baterie Navomodel Terra Cell 16.8 V, 10.0 Ah, 4s

Baterie Navomodel Terra Cell 16.8 V, 10.0 Ah, 4s

terr10ah
Livrare imediată!

457,00Lei

Afişare 1 - 20 din 62 (4 pagini)
Queries: 13, Total time: 4.025 ms [By time] [By id] [By file]
1 (0.067)
SELECT data
FROM `oc_session`
WHERE session_id = 'd67d62dc46ee9d7334dc0b72ab'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.110)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (1.639)
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('+cell' 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.079)
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 (0.486)
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:184
6 (0.089)
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.076)
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.074)
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.235)
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
10 (0.090)
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
11 (0.089)
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
12 (0.894)
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
13 (0.097)
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