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


Ulei de Somon Mainline Salmon Oil, 250ml
Exclusiv online!

Ulei de Somon Mainline Salmon Oil, 250ml

a0.m.m20004
Livrare 24-48 ore

56,32Lei

Aditiv Lichid MG Special Carp Feeder Secret Liquid 500ml

Aditiv Lichid MG Special Carp Feeder Secret Liquid 500ml

mg1731
Livrare imediată!

65,00Lei

Aroma Spray Senzor Ananas, 30ml

Aroma Spray Senzor Ananas, 30ml

snz99970
Livrare imediată!

15,00Lei

Atractant Spray Sensas Bombix Carp Tasty Honey, 75ml
Exclusiv online!

Atractant Spray Sensas Bombix Carp Tasty Honey, 75ml

a0.s81033
Livrare 24-48 ore

38,88Lei

Aditiv Lichid Bait-Tech Deluxe Liquid Special G Red, 250ml
Exclusiv online!

Aditiv Lichid Bait-Tech Deluxe Liquid Special G Red, 250ml

5035305709452
Livrare 48-72 ore

39,00Lei

Aditiv lichid Select Baits Hot Chilli Pepper Extract 500ml

Aditiv lichid Select Baits Hot Chilli Pepper Extract 500ml

sl2550
Livrare imediată!

42,00Lei

Atractant Spray Sensas Bombix Carp Tasty Garlic, 75ml
Exclusiv online!

Atractant Spray Sensas Bombix Carp Tasty Garlic, 75ml

a0.s81034
Livrare 24-48 ore

38,88Lei

Lichid Atractant Dynamite Baits Swim Stim Pellet Soak Betaine Green 500ml

Lichid Atractant Dynamite Baits Swim Stim Pellet Soak Betaine Green 500ml

dy1420
Livrare imediată!

39,00Lei

Aditiv Lichid Select Baits PVA Boost'Em! Liquid Classic Sweetcorn 115ml

Aditiv Lichid Select Baits PVA Boost'Em! Liquid Classic Sweetcorn 115ml

sl2109
Livrare imediată!

26,00Lei

Atractant Spray Sensas Bombix Carp Tasty Orange, 75ml
Exclusiv online!

Atractant Spray Sensas Bombix Carp Tasty Orange, 75ml

a0.s81035
Livrare 24-48 ore

38,88Lei

Lichid Atractant Dynamite Baits Swim Stim Pellet Soak Amino Original 500ml

Lichid Atractant Dynamite Baits Swim Stim Pellet Soak Amino Original 500ml

dy1421
Livrare imediată!

39,00Lei

Sirop de Porumb CPK 250ml

Sirop de Porumb CPK 250ml

1000808
Livrare imediată!

10,00Lei

Aditiv lichid CPK Bagman PVA Special Fruits 250ml

Aditiv lichid CPK Bagman PVA Special Fruits 250ml

1000186
Livrare imediată!

29,00Lei

Aditiv Lichid MG Special Carp Method Feeder Glue Ananas 100ml

Aditiv Lichid MG Special Carp Method Feeder Glue Ananas 100ml

mg0964
Livrare imediată!

20,00Lei

Aroma Lichida Bait Tech Super Sprays Savoury, 10ml

Aroma Lichida Bait Tech Super Sprays Savoury, 10ml

bt-supe02
Livrare imediată!

15,00Lei

Aroma Lichida Carp Zoom Favourite Pellet Plus, Porumb Dulce, 200ml

Aroma Lichida Carp Zoom Favourite Pellet Plus, Porumb Dulce, 200ml

cz0717
Livrare imediată!

19,00Lei

Atractant Lichid CPK APA RECE 3D Punch ( Mix Fructe ), 70ml

Atractant Lichid CPK APA RECE 3D Punch ( Mix Fructe ), 70ml

1000859
Livrare imediată!

19,00Lei

Atractant Spray Sensas Bombix Carp Tasty Krill, 75ml
Exclusiv online!

Atractant Spray Sensas Bombix Carp Tasty Krill, 75ml

a0.s81030
Livrare 24-48 ore

38,88Lei

Lichid Nutritiv CPK Marine Amino Liquid 18 500ml

Lichid Nutritiv CPK Marine Amino Liquid 18 500ml

1000754
Livrare imediată!

35,00Lei

Aditiv Lichid CSL C&B Apa Rece 500ml

Aditiv Lichid CSL C&B Apa Rece 500ml

5947226337082
Livrare imediată!

15,00Lei

Afişare 701 - 720 din 1108 (56 pagini)
Queries: 4, Total time: 41.016 ms [By time] [By id] [By file]
1 (0.100)
SELECT data
FROM `oc_session`
WHERE session_id = '50a90ba5b8a5ec2c76e14418a7'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (40.655)
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('+dip' 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 (0.159)
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