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


Sapca Varivas Breathable Mash Cap Sandy Brown
Exclusiv online!

Sapca Varivas Breathable Mash Cap Sandy Brown

vac71sb
Livrare 48-72 ore

179,00Lei

Sapca Zeck Flexfit Cap Summer 23, Marime S/M (54-57cm)
Exclusiv online!

Sapca Zeck Flexfit Cap Summer 23, Marime S/M (54-57cm)

81305281575
Livrare 48-72 ore

155,97Lei

Sapca Fox Collection Baseball Cap Black & Orange
Exclusiv online!

Sapca Fox Collection Baseball Cap Black & Orange

chh015
Livrare 7-14 zile

76,46Lei

Sapca Hardy C&F 3D Classic Hat, Pumpkin

Sapca Hardy C&F 3D Classic Hat, Pumpkin

1371691
Livrare imediată!

148,71Lei

Sapca Leech Mesh
Exclusiv online!

Sapca Leech Mesh

3011
Livrare 48-72ore

90,00Lei

Sapca Owner Be Strong, Alba
Exclusiv online!

Sapca Owner Be Strong, Alba

813028979-010
Livrare 48-72 ore

81,72Lei

Sapca Owner Be Strong, Negru
Exclusiv online!

Sapca Owner Be Strong, Negru

813028979-020
Livrare 48-72 ore

81,72Lei

Sapca Preston Waterproof Cap Gri
Exclusiv online!

Sapca Preston Waterproof Cap Gri

p0200449
Livrare 7-14 zile

76,46Lei

Sapca Relax Lures Basecap, Camo Grey, Marime Univ.
Exclusiv online!

Sapca Relax Lures Basecap, Camo Grey, Marime Univ.

rsp-cg
Livrare 48-72ore

48,00Lei

Sapca Sonik Multicam Snapback, Camo
Exclusiv online!

Sapca Sonik Multicam Snapback, Camo

nc0016
Livrare 48-72 ore

99,86Lei

Bandana Kershaw Neck Gaiter
Exclusiv online!

Bandana Kershaw Neck Gaiter

ksgaiterker
Livrare 24-48 ore

50,00Lei

Bandana Tub Herakles Dark
Exclusiv online!

Bandana Tub Herakles Dark

clc78
Livrare 48-72 ore

19,50Lei

Sapca Fox Collection Trucker Cap Black & Orange
Exclusiv online!

Sapca Fox Collection Trucker Cap Black & Orange

chh017
Livrare 7-14 zile

76,46Lei

Sapca Fox Collection Trucker Cap Green & Black
Exclusiv online!

Sapca Fox Collection Trucker Cap Green & Black

chh018
Livrare 7-14 zile

76,46Lei

Sapca Kershaw Mesh
Exclusiv online!

Sapca Kershaw Mesh

capker1
Livrare 24-48 ore

89,00Lei

Sapca Nash Scope Trapper Cap, Marime L -33%
Exclusiv online!

Sapca Nash Scope Trapper Cap, Marime L

c0562
Livrare 7-14 zile

109,99Lei(-33%) 73,99Lei

Sapca Rive Negru & Bleu
Exclusiv online!

Sapca Rive Negru & Bleu

81310660107
Livrare 48-72 ore

56,22Lei

Sapca Sensas Gunki Team
Exclusiv online!

Sapca Sensas Gunki Team

a8.spm.38709
Livrare 24-48 ore

111,24Lei

Sapca Abu Garcia BLACK BASEBALL CAP
Exclusiv online!

Sapca Abu Garcia BLACK BASEBALL CAP

1152199
Livrare 7-14 zile

72,21Lei

Sapca Garbolino Baseball Wave, Blue
Exclusiv online!

Sapca Garbolino Baseball Wave, Blue

81330govcj2014
Livrare 48-72 ore

77,72Lei

Afişare 61 - 80 din 339 (17 pagini)
Queries: 7, Total time: 10.878 ms [By time] [By id] [By file]
1 (0.092)
SELECT data
FROM `oc_session`
WHERE session_id = 'f115d593df9ac9b05881355f54'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.117)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (8.719)
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('+sepci' 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 (1.593)
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 60, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.167)
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.095)
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
7 (0.095)
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