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


Cutie Quantum Tackle Keeper FC48Q Shallow 35x22x5cm 48compartimente

Cutie Quantum Tackle Keeper FC48Q Shallow 35x22x5cm 48compartimente

8095003
Stoc epuizat

107,80Lei

Cutie Quantum Tackle Keeper HC12Q Deep 35x22x10cm 12compartimente

Cutie Quantum Tackle Keeper HC12Q Deep 35x22x10cm 12compartimente

8095005
Stoc epuizat

107,78Lei

Vobler Quantum Minnow Gipsy DD SU 5 g 62 mm Tuna

Vobler Quantum Minnow Gipsy DD SU 5 g 62 mm Tuna

8163257103
Stoc epuizat

18,16Lei

Carlige Legate Quantum Crypton Bream Nr.16 80cm Fir 0.10mm Rosu

Carlige Legate Quantum Crypton Bream Nr.16 80cm Fir 0.10mm Rosu

4740016
Stoc epuizat

13,28Lei

Cutie Quantum Tackle Keeper FC36Q Shallow 28x17x4cm 38compartimente

Cutie Quantum Tackle Keeper FC36Q Shallow 28x17x4cm 38compartimente

8095001
Stoc epuizat

53,78Lei

Cutie Quantum Tackle Keeper HC30Q Deep 28x17x10cm 30compartimente

Cutie Quantum Tackle Keeper HC30Q Deep 28x17x10cm 30compartimente

8095002
Stoc epuizat

85,28Lei

Shad Quantum Salty Shat r 10g 12cm Herring

Shad Quantum Salty Shat r 10g 12cm Herring

3223228
Stoc epuizat

36,88Lei

Shad Quantum Smelt Shad 15g 13cm Dusk To Dawn

Shad Quantum Smelt Shad 15g 13cm Dusk To Dawn

801160023
Stoc epuizat

33,08Lei

Twister Quantum Magic Trout B-Fish 2.5cm 0.25gr Orange Yellow Cheese

Twister Quantum Magic Trout B-Fish 2.5cm 0.25gr Orange Yellow Cheese

3495002
Stoc epuizat

22,28Lei

Lingura Oscilanta 40mm 4.5gr Quantum Magic Trout Gambler Silver Gold

Lingura Oscilanta 40mm 4.5gr Quantum Magic Trout Gambler Silver Gold

802163305102
Stoc epuizat

15,26Lei

Shad Quantum Smelt Shad 15g 13cm Sunbleak

Shad Quantum Smelt Shad 15g 13cm Sunbleak

801160022
Stoc epuizat

33,08Lei

Twister Quantum Magic Trout B-Fish 39mm 0.40gr Black Red Cheese

Twister Quantum Magic Trout B-Fish 39mm 0.40gr Black Red Cheese

1301433495001
Stoc epuizat

18,20Lei

Cutie Quantum Tackle Keeper FC24Q Shallow 35x22x5cm 24compartimente

Cutie Quantum Tackle Keeper FC24Q Shallow 35x22x5cm 24compartimente

8095004
Stoc epuizat

76,28Lei

Cap Jig Quantum Screw Jig Head 15gr

Cap Jig Quantum Screw Jig Head 15gr

3148015
Stoc epuizat

31,29Lei

Chatterbait Quantum 4Street 5g Brown Craw

Chatterbait Quantum 4Street 5g Brown Craw

1311163139004
Stoc epuizat

18,42Lei

Cap Jig Quantum Screw Jig Head 25gr

Cap Jig Quantum Screw Jig Head 25gr

3148025
Stoc epuizat

31,29Lei

Cap Jig Quantum Screw Jig Head 35gr

Cap Jig Quantum Screw Jig Head 35gr

3148035
Stoc epuizat

31,29Lei

Mulineta Quantum G-Force GF 40 -30%

Mulineta Quantum G-Force GF 40

0401040
Stoc epuizat

314,78Lei(-30%) 219,90Lei

Carlige Legate Quantum Crypton Carp Nr.2 70cm Fir 0.35mm Black

Carlige Legate Quantum Crypton Carp Nr.2 70cm Fir 0.35mm Black

4744002
Stoc epuizat

13,28Lei

Twister Quantum Magic Trout B-Fish 2.5cm 0.25gr Brown Red Tail Cheese

Twister Quantum Magic Trout B-Fish 2.5cm 0.25gr Brown Red Tail Cheese

3495003
Stoc epuizat

22,28Lei

Afişare 181 - 200 din 266 (14 pagini)
Queries: 9, Total time: 259.423 ms [By time] [By id] [By file]
1 (0.119)
SELECT data
FROM `oc_session`
WHERE session_id = '291a92b3242a8ed4b34bfb7e85'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.115)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.076)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (257.202)
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 "%quantum%") 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 (1.468)
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 180, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.128)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.137)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.093)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.085)
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