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


BINOCLU BUSHNELL 10X25 POWERVIEW

BINOCLU BUSHNELL 10X25 POWERVIEW

vb.13.2516
Stoc epuizat

171,40Lei

TELEMETRU SIG SAUER KILO 2200 BDX 7X25 GRAPHITE

TELEMETRU SIG SAUER KILO 2200 BDX 7X25 GRAPHITE

vss.sok22704
Stoc epuizat

3.860,30Lei

Luneta Docter N5 1.2-6x24 IR 4I

Luneta Docter N5 1.2-6x24 IR 4I

vd.56904
Stoc epuizat

2.687,48Lei

CAMERA VIDEO MINOX DTC 395 CAMO HD INVISIBLE IR.LED

CAMERA VIDEO MINOX DTC 395 CAMO HD INVISIBLE IR.LED

vm.60738
Stoc epuizat

679,31Lei

CAMERA VIDEO MINOX DTC 1100

CAMERA VIDEO MINOX DTC 1100

vm.60719
Stoc epuizat

2.597,35Lei

DISPOZITIV OCHIRE HAWKE MICRO RED DOT SIGHT

DISPOZITIV OCHIRE HAWKE MICRO RED DOT SIGHT

vd.y12135
Stoc epuizat

1.055,49Lei

Luneta Minox 2- 10X50 ZX5I 4/ IR / 30mm

Luneta Minox 2- 10X50 ZX5I 4/ IR / 30mm

vm.66647
Stoc epuizat

3.775,89Lei

LUNETA GAMO 6X40WR CU PRINDERE

LUNETA GAMO 6X40WR CU PRINDERE

g.ve6x40wr
Stoc epuizat

382,88Lei

LUNETA GAMO 4X32WR CU PRINDERE

LUNETA GAMO 4X32WR CU PRINDERE

g.ve4x32wr
Stoc epuizat

285,31Lei

Binoclu Bushnell Powerview 12x25

Binoclu Bushnell Powerview 12x25

vb.13.1225
Stoc epuizat

203,25Lei

TELEMETRU BUSHNELL ELITE 1 MILE 7X26

TELEMETRU BUSHNELL ELITE 1 MILE 7X26

vb.20.2540
Stoc epuizat

3.042,83Lei

HAWKE RED DOT SIGHT REFLEX DIGITAL CONTROL WIDE

HAWKE RED DOT SIGHT REFLEX DIGITAL CONTROL WIDE

vd.12144
Stoc epuizat

960,38Lei

HAWKE RED DOT SIGHT REFLEX DIGITAL CONTROL

HAWKE RED DOT SIGHT REFLEX DIGITAL CONTROL

vd.12141
Stoc epuizat

828,84Lei

BINOCLU MINOX BINOCLU BLUE 8X25

BINOCLU MINOX BINOCLU BLUE 8X25

vm.62062
Stoc epuizat

176,68Lei

LUNETA BUSHNELL FORGE 1-8X30 G4/IR ULTRA SFP/34MM

LUNETA BUSHNELL FORGE 1-8X30 G4/IR ULTRA SFP/34MM

vb.rf1830bs9
Stoc epuizat

3.474,21Lei

BINOCLU BUSHNELL 10X42 JUMELLES BLACK

BINOCLU BUSHNELL 10X42 JUMELLES BLACK

vb.21.0142
Stoc epuizat

358,40Lei

LUNETA ZEISS VICTORY V8 4,8-35X60/IR60/ASV

LUNETA ZEISS VICTORY V8 4,8-35X60/IR60/ASV

vz.522147asv.60
Stoc epuizat

17.168,30Lei

CORDON BUSHNELL DEN PT.CURATAT CARABINA CAL.5.6MM

CORDON BUSHNELL DEN PT.CURATAT CARABINA CAL.5.6MM

vb.24011d
Stoc epuizat

84,50Lei

DISPOZITIV GARMIN DE MONITORIZARE PRIN GPSMAP 66I EMEA

DISPOZITIV GARMIN DE MONITORIZARE PRIN GPSMAP 66I EMEA

hg.010.02088.02
Stoc epuizat

2.699,73Lei

SISTEM MONITORIZARE GARMIN GPSMAP 86I WW

SISTEM MONITORIZARE GARMIN GPSMAP 86I WW

hg.010.02236.01
Stoc epuizat

2.994,69Lei

Afişare 121 - 140 din 151 (8 pagini)
Queries: 10, Total time: 188.936 ms [By time] [By id] [By file]
1 (0.168)
SELECT data
FROM `oc_session`
WHERE session_id = 'b92656c8652eeec172719a8e9c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.112)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (186.091)
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 = '3' AND (pd.tag LIKE "%optic%") 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:698
4 (0.165)
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.863)
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 120, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.315)
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:1209
7 (0.115)
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:1231
8 (0.118)
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:996
9 (0.873)
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:910
10 (0.116)
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