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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Greutati Suplimentare Solar Titanium Drag Weight 15g 2buc/set -10%

Greutati Suplimentare Solar Titanium Drag Weight 15g 2buc/set

dwi
Livrare imediată!

36,10Lei(-10%) 32,49Lei

LAMPA ENERGOTEAM OUTDOOR SOLAR CAMPING

LAMPA ENERGOTEAM OUTDOOR SOLAR CAMPING

74991015
Livrare imediată!

54,00Lei

Solar Line Biter -10%

Solar Line Biter

lb1
Livrare imediată!

55,50Lei(-10%) 49,94Lei

BUZZ BAR EXTENSIBIL SOLAR P1 2 ROD FRONT 2 POSTURI

BUZZ BAR EXTENSIBIL SOLAR P1 2 ROD FRONT 2 POSTURI

p1bb2f
Livrare imediată!

297,00Lei

CARLIGE SOLAR 101 NR 6 -10%

CARLIGE SOLAR 101 NR 6

s1016
Livrare imediată!

41,65Lei(-10%) 37,49Lei

Foarfeca Pentru Fir Textil Solar Serrated Braid Scissors -10%

Foarfeca Pentru Fir Textil Solar Serrated Braid Scissors

sss
Livrare imediată!

49,94Lei(-10%) 44,96Lei

CARLIGE SOLAR 101 NR 2 -10%

CARLIGE SOLAR 101 NR 2

s1012
Livrare imediată!

41,65Lei(-10%) 37,49Lei

Croseta Solar Splicing Needles Small -10%

Croseta Solar Splicing Needles Small

sns
Livrare imediată!

30,55Lei(-10%) 27,50Lei

PROIECTOR NGT PROFILER 21 LED SOLAR 525 LUMENI 15 x 9.5 x 3.5 CM

PROIECTOR NGT PROFILER 21 LED SOLAR 525 LUMENI 15 x 9.5 x 3.5 CM

ngt-ftl-light-profiler
Livrare imediată!

221,99Lei

Rezerva Plasa Minciog Solar 42Inch -10%

Rezerva Plasa Minciog Solar 42Inch

mesh42
Livrare imediată!

183,30Lei(-10%) 164,90Lei

CARLIGE SOLAR 101 NR 4 -10%

CARLIGE SOLAR 101 NR 4

s1014
Livrare imediată!

41,65Lei(-10%) 37,49Lei

Baterie Externa Rebelcell Solar Power Rebel 26800 mAh Incarcare Solara
Exclusiv online!

Baterie Externa Rebelcell Solar Power Rebel 26800 mAh Incarcare Solara

pwrrebel26k
Livrare 48-72ore

495,00Lei

Cap swinger Solar Carbon Indicator Head culoare Rosu -63%

Cap swinger Solar Carbon Indicator Head culoare Rosu

th27
Livrare imediată!

79,90Lei(-63%) 29,90Lei

Fir Textil Solar SP Spod And Marker Braid, 20lbs, 0.19mm, 250m -10%

Fir Textil Solar SP Spod And Marker Braid, 20lbs, 0.19mm, 250m

ldsb01
Livrare imediată!

230,00Lei(-10%) 207,00Lei

Carlige Solar Stronghold Long Shank Hook, Nr.10, 10buc/plic -34%

Carlige Solar Stronghold Long Shank Hook, Nr.10, 10buc/plic

lsc10
Livrare imediată!

37,49Lei(-34%) 24,89Lei

Carlige Solar Stronghold Long Shank Hook, Nr.1, 10buc/plic -10%

Carlige Solar Stronghold Long Shank Hook, Nr.1, 10buc/plic

lsc1
Livrare imediată!

41,65Lei(-10%) 37,49Lei

Opritoare Solar Boilie Stops Natural, Transparent -10%

Opritoare Solar Boilie Stops Natural, Transparent

bsn
Livrare imediată!

13,90Lei(-10%) 12,51Lei

Carlige Solar Stronghold Long Shank Hook, Nr.6, 10buc/plic -34%

Carlige Solar Stronghold Long Shank Hook, Nr.6, 10buc/plic

lsc6
Livrare imediată!

37,49Lei(-34%) 24,89Lei

Conector Solar P1 Mag-Loc Kit Off Adaptor -34%

Conector Solar P1 Mag-Loc Kit Off Adaptor

p1mko
Livrare imediată!

79,92Lei(-34%) 52,90Lei

Carlige Solar Stronghold Long Shank Hook, Nr.8, 10buc/plic -34%

Carlige Solar Stronghold Long Shank Hook, Nr.8, 10buc/plic

lsc8
Livrare imediată!

37,49Lei(-34%) 24,89Lei

Afişare 21 - 40 din 79 (4 pagini)
Queries: 6, Total time: 4.912 ms [By time] [By id] [By file]
1 (0.106)
SELECT data
FROM `oc_session`
WHERE session_id = '44c6027532bb43479b9ca7b377'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.097)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (3.738)
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('+solar' 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.755)
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 20, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.138)
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
6 (0.078)
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