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


Baza Suporti Allroundmarin Railblaza StarPort Blac
Exclusiv online!

Baza Suporti Allroundmarin Railblaza StarPort Blac

rb.915010
Livrare 24-48 ore

88,74Lei

Codite Oscilante Stiuca Bertilure Red, Size XL, 15buc/pac

Codite Oscilante Stiuca Bertilure Red, Size XL, 15buc/pac

a-06-201
Livrare imediată!

7,10Lei

DOPURI VERGI JAXON 33.0MM
Exclusiv online!

DOPURI VERGI JAXON 33.0MM

ak-kor07
Livrare 48-72 ore

12,50Lei

SET ANTENA COLMIC BREAM 4.0-4.8-6.5mm cu chila carbon

SET ANTENA COLMIC BREAM 4.0-4.8-6.5mm cu chila carbon

ant5003
Livrare imediată!

39,00Lei

EXTRACTOR CON BUNG MAVER
Exclusiv online!

EXTRACTOR CON BUNG MAVER

j407
Livrare 48-72 ore

18,00Lei

Rig Aligner Radical Sit Up Beg Rig Aligner 29mm
Exclusiv online!

Rig Aligner Radical Sit Up Beg Rig Aligner 29mm

407190052
Livrare 48-72 ore

18,56Lei

SCARITA LINII JAXON CU CLIPS 25.5CM 2/SET
Exclusiv online!

SCARITA LINII JAXON CU CLIPS 25.5CM 2/SET

ak-kl007m
Livrare 48-72 ore

5,50Lei

Cutie varnis Jaxon plute mix AC 3601

Cutie varnis Jaxon plute mix AC 3601

ac-3601
Livrare imediată!

11,00Lei

Pagaie Sevylor K-Compact 230
Exclusiv online!

Pagaie Sevylor K-Compact 230

2000009563
Livrare 24-48 ore

240,00Lei

Aparat pentru Legat Carlige EnergoTeam Kamasaki Deluxe Standard

Aparat pentru Legat Carlige EnergoTeam Kamasaki Deluxe Standard

49650985
Livrare imediată!

9,50Lei

CON Carp Zoom EXTENDED BUFFER BEADS
Exclusiv online!

CON Carp Zoom EXTENDED BUFFER BEADS

cz2804
Livrare 48-72 ore

11,00Lei

KICKER KORDA RIG ALIGNER VERDE 10BUC/PL MARIMEA S

KICKER KORDA RIG ALIGNER VERDE 10BUC/PL MARIMEA S

a.kick01
Livrare imediată!

26,91Lei

Borseta Korda Semi-Rigida pentru Accesorii Compac 140 Kamo 26x14x8cm
Exclusiv online!

Borseta Korda Semi-Rigida pentru Accesorii Compac 140 Kamo 26x14x8cm

a4.klug20
Livrare 24-48 ore

111,48Lei

DEGORJOR JAXON INOX 17CM
Exclusiv online!

DEGORJOR JAXON INOX 17CM

ac-3203
Livrare 48-72 ore

10,00Lei

DEGORJOR CU CROSETA CARP ZOOM
Exclusiv online!

DEGORJOR CU CROSETA CARP ZOOM

cz4214
Livrare 48-72 ore

22,00Lei

Stoper Zebco Silicone Bung L

Stoper Zebco Silicone Bung L

3163004
Livrare imediată!

8,78Lei

SLOT EASY FLOW PTFE MAVER
Exclusiv online!

SLOT EASY FLOW PTFE MAVER

j865
Livrare 48-72 ore

30,00Lei

Tuburi Carp Zoom Rig Aligner F-Shape 10buc/plic Marimea S

Tuburi Carp Zoom Rig Aligner F-Shape 10buc/plic Marimea S

cz9576
Livrare imediată!

19,00Lei

CONECTOR MAVER ELASTIC SUPER CARP
Exclusiv online!

CONECTOR MAVER ELASTIC SUPER CARP

j645
Livrare 48-72 ore

15,01Lei

Extensie Garmin Antena Atemos
Exclusiv online!

Extensie Garmin Antena Atemos

hg.010.10856.30
Livrare 24-48 ore

149,48Lei

Afişare 1321 - 1340 din 3316 (166 pagini)
Queries: 6, Total time: 84.079 ms [By time] [By id] [By file]
1 (0.079)
SELECT data
FROM `oc_session`
WHERE session_id = '83d2e647c46abaf84713dacc12'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.116)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.101)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (69.478)
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('+accesorii' 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
5 (14.195)
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 1320, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.110)
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