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


Caciula Winchester Guns Rockdale Orange
Exclusiv online!

Caciula Winchester Guns Rockdale Orange

bo.6082022008
Livrare 24-48 ore

74,29Lei

Magazie Munitie Tikka T3X Medium 22-250 Rem,243 Win/308 Win, 7mm Rem
Exclusiv online!

Magazie Munitie Tikka T3X Medium 22-250 Rem,243 Win/308 Win, 7mm Rem

v.s540210152
Livrare 24-48 ore

221,86Lei

Parazapezi Neverlost
Exclusiv online!

Parazapezi Neverlost

a8.nl.110613
Livrare 24-48 ore

228,21Lei

Prindere Luneta Warne Scope Mounts Rod Dot
Exclusiv online!

Prindere Luneta Warne Scope Mounts Rod Dot

vwm.6108m
Livrare 24-48 ore

392,82Lei

SET RING WARNE SCOPE MOUNTS WEAWER 30MM OBIECTIV 50-56MM
Exclusiv online!

SET RING WARNE SCOPE MOUNTS WEAWER 30MM OBIECTIV 50-56MM

vwm.215lm
Livrare 24-48 ore

827,79Lei

AMORTIZOR BLASER R8/R93 SAFARI SILVER 4 RED 27MM

AMORTIZOR BLASER R8/R93 SAFARI SILVER 4 RED 27MM

v.bl.80203705
Stoc epuizat

768,11Lei

PELETE BALLISTOL LANA PT.CURATAT TEAVA CAL.8X57/8X64/8X68 300BUC/PL

PELETE BALLISTOL LANA PT.CURATAT TEAVA CAL.8X57/8X64/8X68 300BUC/PL

vk.23211
Stoc epuizat

134,07Lei

BILE METALICE NGT ANGLO ARMS PENTRU PRASTIE 9.5MM 50 BUC

BILE METALICE NGT ANGLO ARMS PENTRU PRASTIE 9.5MM 50 BUC

ngt-cb-ammo-9.5mm-pb
Stoc epuizat

13,99Lei

SINA FAIR PICATINNY COMBI/SAFARI

SINA FAIR PICATINNY COMBI/SAFARI

vf.sc660
Stoc epuizat

2.478,59Lei

Baza de Montare Fenix - ALG-00

Baza de Montare Fenix - ALG-00

adv-296
Stoc epuizat

88,00Lei

SINA POLI NICOLETTA PN M98/M12/ZASTAVA70

SINA POLI NICOLETTA PN M98/M12/ZASTAVA70

vpn.06.018
Stoc epuizat

136,81Lei

FLIP ZEISS UP COVER V8/HT 50MM

FLIP ZEISS UP COVER V8/HT 50MM

vz.2105.737
Stoc epuizat

701,68Lei

JACHETA VERNEY-CARRON QUILTED JAGUAR MARO MAR.2XL

JACHETA VERNEY-CARRON QUILTED JAGUAR MARO MAR.2XL

lvc.phve019.1.2xl
Stoc epuizat

344,51Lei

BOCANCI AIGLE LETRAK GTX DARK/BROWN 44

BOCANCI AIGLE LETRAK GTX DARK/BROWN 44

ai.t2851.44
Stoc epuizat

900,03Lei

BOCANCI AIGLE LETRAK GTX DARK/BROWN 45

BOCANCI AIGLE LETRAK GTX DARK/BROWN 45

ai.t2851.45
Stoc epuizat

900,03Lei

Jacheta Browning Fleece Sanpshot Sherpa, Green, Marime M

Jacheta Browning Fleece Sanpshot Sherpa, Green, Marime M

bo.30184164.m
Stoc epuizat

368,29Lei

Luneta Minox Riflescope Allrounder 1-5x24/IR/30mm

Luneta Minox Riflescope Allrounder 1-5x24/IR/30mm

vm.80107662
Stoc epuizat

4.817,52Lei

Vesta Browning Shooting Classic Plasa, Anthracite, Marime L

Vesta Browning Shooting Classic Plasa, Anthracite, Marime L

bo.30518791.l
Stoc epuizat

351,55Lei

Camasa Blaser Louie, Brown & Orange, Marime 3XL -30%

Camasa Blaser Louie, Brown & Orange, Marime 3XL

bl.122051.087.3xl
Stoc epuizat

372,41Lei(-30%) 260,69Lei

Camasa Blaser Louie, Brown & Orange, Marime M -30%

Camasa Blaser Louie, Brown & Orange, Marime M

bl.122051.087.m
Stoc epuizat

372,41Lei(-30%) 260,69Lei

Afişare 321 - 340 din 525 (27 pagini)
Queries: 10, Total time: 28.669 ms [By time] [By id] [By file]
1 (0.074)
SELECT data
FROM `oc_session`
WHERE session_id = 'b089caa88b9fccd2018bfbfab0'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (18.953)
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('+vanatoare' 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.206)
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 (3.698)
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 320, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (1.063)
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.113)
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.235)
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 (4.077)
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.148)
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