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


Pop Up Nash Scopex Squid 2024, Pink, 12mm, 75g

Pop Up Nash Scopex Squid 2024, Pink, 12mm, 75g

b6325
Livrare imediată!

44,05Lei

Pop Up Nash Scopex Squid 2024, Yellow, 12mm, 75g

Pop Up Nash Scopex Squid 2024, Yellow, 12mm, 75g

b6330
Livrare imediată!

44,05Lei

Boilies Claumar Birdfood De Carlig Dipuit Scopex & Squid 70gr

Boilies Claumar Birdfood De Carlig Dipuit Scopex & Squid 70gr

clm217554
Livrare imediată!

9,90Lei

Aroma Lichida THE ONE The Stim, Scopex Squid, 50ml
Exclusiv online!

Aroma Lichida THE ONE The Stim, Scopex Squid, 50ml

98252060
Livrare 24-48 ore

18,00Lei

Aroma Lichida THE ONE Secret Juice, Scopex & Squid, 150ml
Exclusiv online!

Aroma Lichida THE ONE Secret Juice, Scopex & Squid, 150ml

98252110
Livrare 24-48 ore

40,99Lei

Boilies Claumar Birdfood Semisolubil Squid And Scopex 20mm 5kg PUNGA

Boilies Claumar Birdfood Semisolubil Squid And Scopex 20mm 5kg PUNGA

clm241900
Livrare imediată!

109,00Lei

Boilies Claumar Birdfood Tare Squid And Scopex 24mm 5kg PUNGA

Boilies Claumar Birdfood Tare Squid And Scopex 24mm 5kg PUNGA

clm241856
Livrare imediată!

109,00Lei

Lichid Nutritiv BUCOVINA Amino, Squid Scopex, 250ml

Lichid Nutritiv BUCOVINA Amino, Squid Scopex, 250ml

0709939122318
Livrare imediată!

25,00Lei

Wafters THE ONE Critical Balanced, Alb / Portocaliu, Scopex / Squid, 10mm, 50g
Exclusiv online!

Wafters THE ONE Critical Balanced, Alb / Portocaliu, Scopex / Squid, 10mm, 50g

98029606
Livrare 24-48 ore

35,17Lei

Boilies Fierte THE ONE Cooked Big One, 20mm, Scopex & Squid, 1kg

Boilies Fierte THE ONE Cooked Big One, 20mm, Scopex & Squid, 1kg

98037921
Livrare imediată!

74,00Lei

Boilies Fierte THE ONE Cooked Big One, 24mm, Scopex & Squid, 1kg
Exclusiv online!

Boilies Fierte THE ONE Cooked Big One, 24mm, Scopex & Squid, 1kg

98037922
Livrare 24-48 ore

74,00Lei

DIP Bucovina Baits Competition Gold Amino, Squid & Scopex, 160g

DIP Bucovina Baits Competition Gold Amino, Squid & Scopex, 160g

5940000005023b
Livrare imediată!

22,00Lei

Wafters ADDICTED CARP BAITS Clepsidra Premium, Squid Scopex, 6mm, 40ml

Wafters ADDICTED CARP BAITS Clepsidra Premium, Squid Scopex, 6mm, 40ml

acb243
Livrare imediată!

32,00Lei

Wafters ADDICTED CARP BAITS Clepsidra Premium, Squid Scopex, 3.5mm, 40ml

Wafters ADDICTED CARP BAITS Clepsidra Premium, Squid Scopex, 3.5mm, 40ml

acb261
Livrare imediată!

33,01Lei

Wafters ADDICTED CARP BAITS Clepsidra Premium, Squid Scopex, 8mm, 40ml

Wafters ADDICTED CARP BAITS Clepsidra Premium, Squid Scopex, 8mm, 40ml

acb252
Livrare imediată!

32,00Lei

Porumb Flotant Silicon C&B, Scopex-Squid, 10 buc/cutie + 2 Fluo

Porumb Flotant Silicon C&B, Scopex-Squid, 10 buc/cutie + 2 Fluo

6427416146186
Livrare imediată!

12,99Lei

Aditiv Avid Liquid Food, Creamy Scopex, 250ml
Exclusiv online!

Aditiv Avid Liquid Food, Creamy Scopex, 250ml

a0650005
Livrare 7-14 zile

40,46Lei

Boilies Tare Da-i Cu Apa Gabriel Fisherman, Squid & Scopex, 20mm, 1kg

Boilies Tare Da-i Cu Apa Gabriel Fisherman, Squid & Scopex, 20mm, 1kg

5138248470493
Livrare imediată!

50,00Lei

Aditiv Nash Scopex Squid Cold Liquid, Yellow,100ml

Aditiv Nash Scopex Squid Cold Liquid, Yellow,100ml

b6371
Stoc epuizat

58,75Lei

Aditiv Nash Scopex Squid Cold Liquid, White,100ml

Aditiv Nash Scopex Squid Cold Liquid, White,100ml

b6372
Stoc epuizat

58,75Lei

Afişare 1 - 20 din 55 (3 pagini)
Queries: 11, Total time: 2.091 ms [By time] [By id] [By file]
1 (0.087)
SELECT data
FROM `oc_session`
WHERE session_id = '12472ce9ae8b927f4fa577ec61'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.123)
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.266)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("202877", "1", "8", "59", "1", "37.020000000000", "1"),("202865", "1", "6", "59", "1", "37.020000000000", "2"),("242159", "-100", "15", "26", "1", "11.622400000000", "3"),("237720", "1", "1000", "292", "1", "21.132800000000", "4"),("237722", "1", "1000", "292", "1", "48.140800000000", "5"),("94165", "-100", "21", "26", "1", "128.000000000000", "6"),("94166", "-100", "8", "26", "1", "128.000000000000", "7"),("238027", "2", "4", "436", "1", "29.363200000000", "8"),("241416", "1", "1000", "292", "1", "41.305600000000", "9"),("237701", "2", "1002", "292", "1", "86.899200000000", "10"),("237702", "2", "1000", "292", "1", "86.899200000000", "11"),("146049", "2", "6", "436", "1", "25.830400000000", "12"),("234980", "1", "4", "659", "1", "37.580800000000", "13"),("234979", "1", "3", "659", "1", "38.758400000000", "14"),("234981", "1", "3", "659", "1", "37.580800000000", "15"),("169779", "2", "2", "625", "1", "10.920000000000", "16"),("230371", "1", "1000", "353", "1", "34.000000000000", "17"),("240072", "2", "9", "772", "1", "58.713600000000", "18"),("203717", "1", "0", "59", "1", "68.992000000000", "19"),("203721", "1", "0", "59", "1", "68.992000000000", "20"),("203723", "1", "0", "59", "1", "68.992000000000", "21"),("225943", "2", "0", "59", "1", "345.190400000000", "22"),("225944", "2", "0", "59", "1", "92.006400000000", "23"),("203693", "2", "0", "59", "1", "51.724800000000", "24"),("203697", "2", "0", "59", "1", "51.724800000000", "25"),("230323", "2", "0", "59", "1", "51.724800000000", "26"),("235228", "1", "0", "59", "1", "92.006400000000", "27"),("235229", "1", "0", "59", "1", "92.006400000000", "28"),("202845", "2", "0", "59", "1", "247.020000000000", "29"),("202847", "2", "0", "59", "1", "247.020000000000", "30"),("202861", "1", "0", "59", "1", "37.020000000000", "31"),("202863", "1", "0", "59", "1", "37.020000000000", "32"),("202867", "1", "0", "59", "1", "37.020000000000", "33"),("202869", "1", "0", "59", "1", "37.020000000000", "34"),("202871", "1", "0", "59", "1", "37.020000000000", "35"),("202873", "1", "0", "59", "1", "37.020000000000", "36"),("202875", "1", "0", "59", "1", "37.020000000000", "37"),("202879", "1", "0", "59", "1", "37.020000000000", "38"),("202881", "1", "0", "59", "1", "37.020000000000", "39"),("202883", "1", "0", "59", "1", "37.020000000000", "40"),("203755", "1", "0", "59", "1", "172.569600000000", "41"),("225932", "1", "0", "59", "1", "51.724800000000", "42"),("225933", "1", "0", "59", "1", "51.724800000000", "43"),("225934", "1", "0", "59", "1", "51.724800000000", "44"),("235156", "2", "0", "59", "1", "92.006400000000", "45"),("235157", "2", "0", "59", "1", "92.006400000000", "46"),("235158", "2", "0", "59", "1", "92.006400000000", "47"),("235159", "1", "0", "59", "1", "68.992000000000", "48"),("235227", "1", "0", "59", "1", "37.770000000000", "49"),("203765", "2", "0", "59", "1", "45.977600000000", "50"),("93288", "2", "0", "59", "1", "46.963200000000", "51"),("101316", "-100", "0", "26", "1", "5.120000000000", "52"),("203761", "2", "0", "59", "1", "68.992000000000", "53"),("52067", "2", "0", "291", "1", "15.800000000000", "54"),("10511", "2", "0", "178", "1", "26.880000000000", "55")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.107)
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.251)
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.206)
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.087)
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.072)
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.657)
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.131)
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