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 - Mincioage

Produse ce potrivesc criteriilor de căutare


Shad Nevis Action 5cm 9305-401

Shad Nevis Action 5cm 9305-401

9305-401
Stoc epuizat

8,00Lei

Shad Nevis Action 7cm 9307-701

Shad Nevis Action 7cm 9307-701

9307-701
Stoc epuizat

9,90Lei

Mulineta Nevis Innova Spin 3500 4+1

Mulineta Nevis Innova Spin 3500 4+1

2259-535
Stoc epuizat

210,00Lei

Shad Nevis Twister 11cm 9511-003

Shad Nevis Twister 11cm 9511-003

9511-003
Stoc epuizat

9,90Lei

Shad Nevis Action 7cm 9307-505

Shad Nevis Action 7cm 9307-505

9307-505
Stoc epuizat

8,00Lei

Shad Nevis Twister 11cm 9511-010

Shad Nevis Twister 11cm 9511-010

9511-010
Stoc epuizat

9,90Lei

Mulineta Nevis Innova Spin 4000 4+1

Mulineta Nevis Innova Spin 4000 4+1

2259-540
Stoc epuizat

215,00Lei

Cort Nevis Mammut 250x250x170cm

Cort Nevis Mammut 250x250x170cm

7516-002
Stoc epuizat

1.630,00Lei

Agrafe Nevis Nr.0, 13kg, 10 buc/plic

Agrafe Nevis Nr.0, 13kg, 10 buc/plic

5521-100
Stoc epuizat

2,68Lei

Set Unelte pentru Larvele de Libelula Artificiale Konger Bloodworm Clustering Tool

Set Unelte pentru Larvele de Libelula Artificiale Konger Bloodworm Clustering Tool

141106199592030
Stoc epuizat

10,07Lei

Cutie Naluci Nevis 145x100x23mm

Cutie Naluci Nevis 145x100x23mm

4520-001
Stoc epuizat

10,40Lei

Opritor Nevis pentru Pestisor 20buc/pac

Opritor Nevis pentru Pestisor 20buc/pac

6430-015
Stoc epuizat

4,30Lei

Tub Silicon Nevis Transparent, 4mm, 100cm

Tub Silicon Nevis Transparent, 4mm, 100cm

6434-001
Stoc epuizat

6,60Lei

Gafa Nevis, 53cm

Gafa Nevis, 53cm

4248-130
Stoc epuizat

30,50Lei

Tub Silicon Nevis Transparent, 4mm, 100cm

Tub Silicon Nevis Transparent, 4mm, 100cm

6434-002
Stoc epuizat

6,60Lei

Spray Navis Predator Booster, Salau, 30ml

Spray Navis Predator Booster, Salau, 30ml

8513-001
Stoc epuizat

25,50Lei

Spray Navis Predator Booster, Somn, 30ml

Spray Navis Predator Booster, Somn, 30ml

8513-002
Stoc epuizat

25,50Lei

Afişare 1021 - 1037 din 1037 (52 pagini)
Queries: 6, Total time: 254.441 ms [By time] [By id] [By file]
1 (0.086)
SELECT data
FROM `oc_session`
WHERE session_id = '1f902c6c8479b624103f5b9d49'
/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 (0.117)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (249.868)
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 "%nevis%") 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 (4.159)
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 1020, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.099)
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