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

Produse ce potrivesc criteriilor de căutare


STRUNA SUMATO JAXON MICROFIBRA 1X19 25CM 8KG

STRUNA SUMATO JAXON MICROFIBRA 1X19 25CM 8KG

aj-pab0825
Stoc epuizat

5,00Lei

Struna Otel Tanami JAXON 25cm 10Kg

Struna Otel Tanami JAXON 25cm 10Kg

aj-prc1025
Stoc epuizat

9,00Lei

STRUNA OTEL JAXON TANAMI 40CM 10KG

STRUNA OTEL JAXON TANAMI 40CM 10KG

aj-prc1040
Stoc epuizat

12,00Lei

STRUNA OTEL JAXON TANAMI 40CM 15KG

STRUNA OTEL JAXON TANAMI 40CM 15KG

aj-prc1540
Stoc epuizat

11,50Lei

STRUNA OTEL JAXON TANAMI 50CM 15KG

STRUNA OTEL JAXON TANAMI 50CM 15KG

aj-prc1550
Stoc epuizat

12,00Lei

Struna Otel Tanami JAXON 30cm 15Kg

Struna Otel Tanami JAXON 30cm 15Kg

aj-prc1530
Stoc epuizat

9,50Lei

STRUNA OTEL JAXON TANAMI BIG GAME 50CM 20KG

STRUNA OTEL JAXON TANAMI BIG GAME 50CM 20KG

aj-prc2050
Stoc epuizat

12,99Lei

MONTURA STRUNA JAXON SUMATO SPIRALA X1 12CM 15KG CU ANCORA NR 1/0

MONTURA STRUNA JAXON SUMATO SPIRALA X1 12CM 15KG CU ANCORA NR 1/0

aj-pah12
Stoc epuizat

8,50Lei

STRUNA SUMATO JAXON MICROFIBRA 7X7 30CM 8KG

STRUNA SUMATO JAXON MICROFIBRA 7X7 30CM 8KG

aj-pac0830
Stoc epuizat

5,50Lei

Struna Otel Tanami JAXON 25cm 6Kg

Struna Otel Tanami JAXON 25cm 6Kg

aj-prc0625
Stoc epuizat

9,00Lei

STRUNA OTEL JAXON TANAMI 30CM 6KG

STRUNA OTEL JAXON TANAMI 30CM 6KG

aj-prc0630
Stoc epuizat

9,50Lei

STRUNA Climax ULTRA PREDATOR HARDMONO 60cm 18.1kg

STRUNA Climax ULTRA PREDATOR HARDMONO 60cm 18.1kg

8610-20007-018
Stoc epuizat

11,00Lei

MONTURA JAXON STRUNA SUMATO 1X7 6CM ANCORA

MONTURA JAXON STRUNA SUMATO 1X7 6CM ANCORA

aj-paf06
Stoc epuizat

6,00Lei

STRUNA Climax ULTRA PREDATOR FLEXSTEEL 1x19 60cm 20kg

STRUNA Climax ULTRA PREDATOR FLEXSTEEL 1x19 60cm 20kg

8610-20004-020
Stoc epuizat

12,00Lei

STRUNA SAVAGE TITANIUM7 TRACE 30CM 040MM/13KG 2BUC/PL

STRUNA SAVAGE TITANIUM7 TRACE 30CM 040MM/13KG 2BUC/PL

a7.sg.61770
Stoc epuizat

47,45Lei

MONTURA JAXON STRUNA SUMATO 1X7 10CM ANCORA

MONTURA JAXON STRUNA SUMATO 1X7 10CM ANCORA

aj-paf10
Stoc epuizat

6,00Lei

MONTURA JAXON STRUNA SUMATO 1X7 30CM ANCORA DUBLA NUMARUL 1/0

MONTURA JAXON STRUNA SUMATO 1X7 30CM ANCORA DUBLA NUMARUL 1/0

aj-pae10301/0
Stoc epuizat

6,50Lei

STRUNA TITAN CARP ZOOM PREDATOR Z 20CM 11KG 2/PLIC

STRUNA TITAN CARP ZOOM PREDATOR Z 20CM 11KG 2/PLIC

cz5579
Stoc epuizat

16,01Lei

STRUNA Climax ULTRA PREDATOR FLEXSTEEL 7x7 60cm 5kg

STRUNA Climax ULTRA PREDATOR FLEXSTEEL 7x7 60cm 5kg

8610-20003-005
Stoc epuizat

13,99Lei

MONTURA JAXON STRUNA SUMATO 1X7 12CM ANCORA

MONTURA JAXON STRUNA SUMATO 1X7 12CM ANCORA

aj-paf12
Stoc epuizat

6,00Lei

Afişare 361 - 380 din 463 (24 pagini)
Queries: 5, Total time: 18.930 ms [By time] [By id] [By file]
1 (0.123)
SELECT data
FROM `oc_session`
WHERE session_id = 'cb228a436a2a0e4a00464f8940'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.085)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (15.412)
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 = '2' AND (MATCH(pd.tag) AGAINST('+struna' 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 (3.167)
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 360, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.143)
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