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 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


CSL Dynamite Baits 1L

CSL Dynamite Baits 1L

dy336
Livrare imediată!

73,30Lei

Aditiv Lichid DYNAMITE BAITS Zig Oil Fishy, 1ltr
Exclusiv online!

Aditiv Lichid DYNAMITE BAITS Zig Oil Fishy, 1ltr

dy1552
Livrare 48-72 ore

74,11Lei

Aditiv Lichid DYNAMITE BAITS Zig Oil Nutty, 1ltr
Exclusiv online!

Aditiv Lichid DYNAMITE BAITS Zig Oil Nutty, 1ltr

dy1553
Livrare 48-72 ore

74,11Lei

ADITIV LICHID DYNAMITE BAITS BIG FISH RIVER BAIT SOAK Cheese And Garlic 500ML
Exclusiv online!

ADITIV LICHID DYNAMITE BAITS BIG FISH RIVER BAIT SOAK Cheese And Garlic 500ML

dy1379
Livrare 48-72 ore

41,63Lei

ADITIV LICHID DYNAMITE BAITS BIG FISH RIVER BAIT SOAK Shrimp And Krill 500ML
Exclusiv online!

ADITIV LICHID DYNAMITE BAITS BIG FISH RIVER BAIT SOAK Shrimp And Krill 500ML

dy1378
Livrare 48-72 ore

41,63Lei

Lichid Dynamite Baits Krill 1L

Lichid Dynamite Baits Krill 1L

dy337
Livrare imediată!

79,41Lei

Dynamite xl liquid Pineapple

Dynamite xl liquid Pineapple

xl857
Livrare imediată!

31,45Lei

Dynamite xl liquid worm
Exclusiv online!

Dynamite xl liquid worm

xl851
Livrare 48-72 ore

31,45Lei

Dynamite xl liquid brassem
Exclusiv online!

Dynamite xl liquid brassem

xl854
Livrare 48-72 ore

31,40Lei

Dynamite xl liquid scopex
Exclusiv online!

Dynamite xl liquid scopex

xl856
Livrare 48-72 ore

29,90Lei

Aditiv Lichid Dynamite Baits Sweet Banoffi 250ml
Exclusiv online!

Aditiv Lichid Dynamite Baits Sweet Banoffi 250ml

dy1633
Livrare 48-72 ore

31,40Lei

Dynamite Baits Premium Squid Liquid Carp Food 1L
Exclusiv online!

Dynamite Baits Premium Squid Liquid Carp Food 1L

dy338
Livrare 48-72 ore

78,29Lei

Aditiv Dynamite Baits Swim Stim Sticky Pellet Syrup F1 300ml
Exclusiv online!

Aditiv Dynamite Baits Swim Stim Sticky Pellet Syrup F1 300ml

dy1495
Livrare 48-72 ore

47,74Lei

Aditiv Dynamite Baits Swim Stim Sticky Pellet Syrup Red Krill 300ml

Aditiv Dynamite Baits Swim Stim Sticky Pellet Syrup Red Krill 300ml

dy1497
Livrare imediată!

44,79Lei

Aditiv Dynamite Baits Swim Stim Sticky Pellet Syrup Betaine Green 300ml
Exclusiv online!

Aditiv Dynamite Baits Swim Stim Sticky Pellet Syrup Betaine Green 300ml

dy1496
Livrare 48-72 ore

45,71Lei

Galeata Dynamite Baits 17L -20%

Galeata Dynamite Baits 17L

dy500
Stoc epuizat

54,79Lei(-20%) 43,56Lei

Afişare 1 - 16 din 16 (1 pagini)
Queries: 11, Total time: 1.601 ms [By time] [By id] [By file]
1 (0.074)
SELECT data
FROM `oc_session`
WHERE session_id = '5dd3b12f4b38b435b158471ad7'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.084)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.124)
CREATE TEMPORARY TABLE oc_bf_tmp_product ( product_id int PRIMARY KEY, sort_order int, quantity int, manufacturer_id int, match_filters int, actual_price DECIMAL(10, 4), sort int, INDEX my_index (match_filters, sort_order, manufacturer_id) ) ENGINE=MEMORY
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:837
4 (0.117)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("12427", "2", "1002", "178", "1", "66.040000000000", "1"),("247088", "1", "1000", "178", "1", "61.250000000000", "2"),("247090", "1", "1000", "178", "1", "61.250000000000", "3"),("88160", "2", "1000", "178", "1", "37.500000000000", "4"),("88159", "2", "1000", "178", "1", "37.500000000000", "5"),("26971", "2", "1001", "178", "1", "71.540000000000", "6"),("10512", "2", "1002", "178", "1", "28.330000000000", "7"),("10508", "2", "1000", "178", "1", "28.330000000000", "8"),("10509", "2", "1000", "178", "1", "25.950000000000", "9"),("10511", "2", "1000", "178", "1", "26.940000000000", "10"),("175480", "1", "1000", "178", "1", "25.950000000000", "11"),("12439", "2", "1000", "178", "1", "70.530000000000", "12"),("112094", "1", "1000", "178", "1", "43.010000000000", "13"),("112093", "1", "1005", "178", "1", "40.350000000000", "14"),("167265", "1", "1000", "178", "1", "41.180000000000", "15"),("11894", "2", "0", "178", "1", "36.000000000000", "16")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.111)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1593
6 (0.171)
SELECT p.*
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2' LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.221)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1393
8 (0.105)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1415
9 (0.079)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1180
10 (0.342)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1094
11 (0.173)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37