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


WINDING CHECK FUJI WCS 17-8.5
Exclusiv online!

WINDING CHECK FUJI WCS 17-8.5

mwcs17-8.5
Livrare 48-72 ore

5,80Lei

WINDING CHECK FUJI WCS 17-10
Exclusiv online!

WINDING CHECK FUJI WCS 17-10

mwcs17-10
Livrare 48-72 ore

5,80Lei

OPRITOR CORMORAN STICLA ROSU BILA DIV.MARIMI

OPRITOR CORMORAN STICLA ROSU BILA DIV.MARIMI

a.49.09300
Livrare imediată!

11,52Lei

WINDING CHECK FUJI WCS 17-15
Exclusiv online!

WINDING CHECK FUJI WCS 17-15

mwcs17-15
Livrare 48-72 ore

5,80Lei

Opritoare Mostiro cauciuc negre Marimea S

Opritoare Mostiro cauciuc negre Marimea S

4055
Livrare imediată!

2,00Lei

PALETA NADIT MEDIUM CU MANER 27CM JAXON
Exclusiv online!

PALETA NADIT MEDIUM CU MANER 27CM JAXON

ac-pc047a
Livrare 48-72 ore

80,00Lei

CILINDRU EVA MAJORA 250x24mm gaura interioara 7mm
Exclusiv online!

CILINDRU EVA MAJORA 250x24mm gaura interioara 7mm

m12030369
Livrare 48-72 ore

36,00Lei

ATA MATISAJ FUJI A-ULTRA BRIGHT 100m 50 LIGHT BLUE 021
Exclusiv online!

ATA MATISAJ FUJI A-ULTRA BRIGHT 100m 50 LIGHT BLUE 021

mftupa0021
Livrare 48-72 ore

21,00Lei

VIERMI ARTIFICIALI ENTERPRISE ET MIXED FLUORO IMITATION MAGGOTS

VIERMI ARTIFICIALI ENTERPRISE ET MIXED FLUORO IMITATION MAGGOTS

et18mmf
Livrare imediată!

14,49Lei

PALETA NADIRE CARP ZOOM 47cm
Exclusiv online!

PALETA NADIRE CARP ZOOM 47cm

cz3972
Livrare 48-72 ore

103,99Lei

MULTI PULL TOOL CARP SPIRIT

MULTI PULL TOOL CARP SPIRIT

acs010221
Livrare imediată!

30,00Lei

MARKER FIR COLMICE GALBEN
Exclusiv online!

MARKER FIR COLMICE GALBEN

pen02
Livrare 48-72 ore

59,00Lei

CILINDRU EVA MAJORA 450x32mm gaura interioara 13mm
Exclusiv online!

CILINDRU EVA MAJORA 450x32mm gaura interioara 13mm

m12030314
Livrare 48-72 ore

84,00Lei

EXTENSIE BOILIE CRUSHER HOPER RIDGE MONKEY -41%

EXTENSIE BOILIE CRUSHER HOPER RIDGE MONKEY

rm047
Livrare imediată!

70,00Lei(-41%) 41,59Lei

BLOCAJ MOSTIRO SILICON PELLETE SMALL 6 BUC

BLOCAJ MOSTIRO SILICON PELLETE SMALL 6 BUC

4126
Livrare imediată!

3,90Lei

OPRITOARE LINEAEFFE CAUCIUC PENTRU PLUTA 6BUC/PLIC MAR.L

OPRITOARE LINEAEFFE CAUCIUC PENTRU PLUTA 6BUC/PLIC MAR.L

a.4950020
Livrare imediată!

2,25Lei

CHOD TOOL KORDA

CHOD TOOL KORDA

a.kcit
Livrare imediată!

33,43Lei

DISPOZITIV USCARE MATISAJ FUJI
Exclusiv online!

DISPOZITIV USCARE MATISAJ FUJI

mrodstd
Livrare 48-72 ore

134,01Lei

Opritor Ata EnergoTeam S

Opritor Ata EnergoTeam S

79007202
Livrare imediată!

2,30Lei

Elastic Fixare Momeala XL Carp Academy

Elastic Fixare Momeala XL Carp Academy

8100-168
Livrare imediată!

4,80Lei

Afişare 301 - 320 din 1062 (54 pagini)
Queries: 10, Total time: 33.875 ms [By time] [By id] [By file]
1 (0.110)
SELECT data
FROM `oc_session`
WHERE session_id = '89eb36e942bd37b405571ee39a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.142)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (21.146)
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 = '2' AND (MATCH(pd.tag) AGAINST('+alte' 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.191)
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 (4.327)
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 300, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (1.043)
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
7 (0.119)
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
8 (0.251)
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
9 (6.427)
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
10 (0.119)
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