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

Produse ce potrivesc criteriilor de căutare


PANTALON GAMO THORN VERDE MARIMEA 48

PANTALON GAMO THORN VERDE MARIMEA 48

g.457905837.42
Stoc epuizat

271,90Lei

PISTON GAS GAMO 1100

PISTON GAS GAMO 1100

g.36040
Stoc epuizat

156,97Lei

LUNETA GAMO 4X32WR CU PRINDERE

LUNETA GAMO 4X32WR CU PRINDERE

g.ve4x32wr
Stoc epuizat

285,31Lei

Vesta Gamo Focha Verde Masura XL

Vesta Gamo Focha Verde Masura XL

g.455001437.l
Stoc epuizat

250,10Lei

Pantaloni Gamo Lechal Forest Green Marimea:54

Pantaloni Gamo Lechal Forest Green Marimea:54

g.457905339.50
Stoc epuizat

219,92Lei

ARC GAMO ARMA DELTA,TROOPER,SPECTRA 30 SPIRE

ARC GAMO ARMA DELTA,TROOPER,SPECTRA 30 SPIRE

g.15110
Stoc epuizat

17,78Lei

CUTIE METAL GAMO PRO MAGNUM 5,5MM 250BUC

CUTIE METAL GAMO PRO MAGNUM 5,5MM 250BUC

g.6321725
Stoc epuizat

23,90Lei

Set Gamo pentru Curatat ARme + Suport

Set Gamo pentru Curatat ARme + Suport

g.6212409cp
Stoc epuizat

86,77Lei

CUTIE METAL GAMO PBA PLATINUM 4,5MM 125BUC

CUTIE METAL GAMO PBA PLATINUM 4,5MM 125BUC

g.63226541.d
Stoc epuizat

21,40Lei

SET GAMO PENTRU INTRETINERE ARME

SET GAMO PENTRU INTRETINERE ARME

g.6212460cp
Stoc epuizat

133,98Lei

PRINDERE LUNETA GAMO COMPACTA-MEDIE

PRINDERE LUNETA GAMO COMPACTA-MEDIE

g.6213184
Stoc epuizat

133,98Lei

CUTIE METAL GAMO PBA ARMOUR 5,5MM 75BUC

CUTIE METAL GAMO PBA ARMOUR 5,5MM 75BUC

g.63226351
Stoc epuizat

44,22Lei

CUTIE METAL GAMO RED FIRE 4,5MM 125BUC

CUTIE METAL GAMO RED FIRE 4,5MM 125BUC

g.6322711.d
Stoc epuizat

19,90Lei

CUREA GAMO ARMA NEOPRENE BLACK

CUREA GAMO ARMA NEOPRENE BLACK

g.456000559u
Stoc epuizat

127,60Lei

Vesta Gamo Focha Verde Masura XL

Vesta Gamo Focha Verde Masura XL

g.455001437.xl
Stoc epuizat

250,10Lei

CUTIE METAL GAMO EXPANDER 5,5MM 250BUC

CUTIE METAL GAMO EXPANDER 5,5MM 250BUC

g.6322525
Stoc epuizat

27,70Lei

HUSA GAMO ARMA+LUNETA 125CM NEAGRA

HUSA GAMO ARMA+LUNETA 125CM NEAGRA

g.6212374
Stoc epuizat

268,79Lei

Afişare 41 - 57 din 57 (3 pagini)
Queries: 13, Total time: 167.343 ms [By time] [By id] [By file]
1 (0.104)
SELECT data
FROM `oc_session`
WHERE session_id = '49864ed13b8c42dcfd65c913e7'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.104)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.160)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (165.198)
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 = '2' AND (pd.tag LIKE "%gamo%") 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
5 (0.159)
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:1555
6 (0.456)
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 40, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.187)
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
8 (0.107)
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
9 (0.096)
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
10 (0.474)
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
11 (0.096)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
12 (0.095)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.107)
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