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


BLUZA SPRING FIRST-LAYER AERO2 BLACK Mar.2XL

BLUZA SPRING FIRST-LAYER AERO2 BLACK Mar.2XL

vp.109.2xl
Stoc epuizat

295,80Lei

Minciog Korda Spring Bow 42inch

Minciog Korda Spring Bow 42inch

a2.kln001
Stoc epuizat

1.558,06Lei

CARLIGE GAMAKATSU SUPER LINE SPRING BL 7/0 4BUC/PL

CARLIGE GAMAKATSU SUPER LINE SPRING BL 7/0 4BUC/PL

gk.185007.07
Stoc epuizat

21,21Lei

SHAD DELPHIN BOMB FATTY 10CM SPRING

SHAD DELPHIN BOMB FATTY 10CM SPRING

690011005
Stoc epuizat

28,00Lei

Patent Rapala Mag Spring 20cm

Patent Rapala Mag Spring 20cm

rcdmp8
Stoc epuizat

169,00Lei

Shad Fanatik Goby 2 50mm 022 Spring Green UV

Shad Fanatik Goby 2 50mm 022 Spring Green UV

801131322
Stoc epuizat

14,54Lei

SHAD DELPHIN BOMB FATTY 12CM SPRING

SHAD DELPHIN BOMB FATTY 12CM SPRING

690011205
Stoc epuizat

31,00Lei

Naluca Soft Bomb D Shot 5buc 10.5cm Spring

Naluca Soft Bomb D Shot 5buc 10.5cm Spring

101000711
Stoc epuizat

15,01Lei

Naluca Soft Bomb D Shot 5buc 6.5cm Spring

Naluca Soft Bomb D Shot 5buc 6.5cm Spring

101000709
Stoc epuizat

11,00Lei

Naluca Soft Bomb D Shot 5buc 8.5cm Spring

Naluca Soft Bomb D Shot 5buc 8.5cm Spring

101000710
Stoc epuizat

12,00Lei

Jacheta Delphin Spring OutLINE, Marime 3XL

Jacheta Delphin Spring OutLINE, Marime 3XL

101004162
Stoc epuizat

287,00Lei

Jacheta Delphin Spring OutLINE, Marime L

Jacheta Delphin Spring OutLINE, Marime L

101004159
Stoc epuizat

287,00Lei

Momitor Orange Arcuit Inline Multi-Hook Spring cu Plumb 40g

Momitor Orange Arcuit Inline Multi-Hook Spring cu Plumb 40g

4034120fs140w
Stoc epuizat

4,64Lei

Momitor Orange Arcuit Inline Spring cu Plumb 50g

Momitor Orange Arcuit Inline Spring cu Plumb 50g

4034120fs150
Stoc epuizat

5,30Lei

Jacheta Delphin Spring OutLINE, Marime 2XL

Jacheta Delphin Spring OutLINE, Marime 2XL

101004161
Stoc epuizat

287,00Lei

Tricou Winchester Guns Springer, Kaki, Marime S

Tricou Winchester Guns Springer, Kaki, Marime S

bo.60115058.s
Stoc epuizat

99,40Lei

Jacheta Delphin Spring OutLINE, Marime XL

Jacheta Delphin Spring OutLINE, Marime XL

101004160
Stoc epuizat

287,00Lei

Momitor Orange Arcuit Inline Multi-Hook Spring cu Plumb 50g

Momitor Orange Arcuit Inline Multi-Hook Spring cu Plumb 50g

4034120fs150w
Stoc epuizat

5,30Lei

Spirale pentru Naluci Moi STONFO 621 Soft Lure Springs, Dim.3, 6buc/pac

Spirale pentru Naluci Moi STONFO 621 Soft Lure Springs, Dim.3, 6buc/pac

8028651016777
Stoc epuizat

19,50Lei

Jacheta Delphin Spring OutLINE, Marime M

Jacheta Delphin Spring OutLINE, Marime M

101004158
Stoc epuizat

287,00Lei

Afişare 61 - 80 din 88 (5 pagini)
Queries: 15, Total time: 290.395 ms [By time] [By id] [By file]
1 (0.099)
SELECT data
FROM `oc_session`
WHERE session_id = 'dbcfcd1db6934de19c310c6d87'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.089)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.042)
DROP TEMPORARY TABLE IF EXISTS oc_bf_tmp_product
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:692
5 (286.716)
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 = '0' AND (pd.tag LIKE "%spring%") 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:693
6 (0.172)
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:1547
7 (0.659)
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:181
8 (0.159)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.326)
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:1204
10 (0.101)
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:1223
11 (0.107)
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:978
12 (1.560)
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:900
13 (0.091)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
14 (0.099)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
15 (0.085)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38