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 300 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


Boilies Solubil de Carlig MAINLINE Shelf Life, Cell, 20mm, 5kg

Boilies Solubil de Carlig MAINLINE Shelf Life, Cell, 20mm, 5kg

a0.m.m41016
Stoc epuizat

304,99Lei

Boilies Solubil de Carlig MAINLINE Shelf Life, Link, 20mm, 5kg

Boilies Solubil de Carlig MAINLINE Shelf Life, Link, 20mm, 5kg

a0.m.m41024
Stoc epuizat

304,99Lei

Pop Up Mainline Critic Echilibrat High Impact Balanced Wafters Banoffe 15mm 60buc/borcan
Fir Asso Mainline Abrasion Multicolor 0.40mm 1000m

Fir Asso Mainline Abrasion Multicolor 0.40mm 1000m

110108fnasdi276bm1000a60400
Stoc epuizat

83,05Lei

Fir Asso Mainline Abrasion Multicolor 0.28mm 1000m

Fir Asso Mainline Abrasion Multicolor 0.28mm 1000m

110108fnasdi276bm1000a60280
Stoc epuizat

65,60Lei

Pop Up Mainline Critic Echilibrat Cork Dust Wafters The Link 14mm

Pop Up Mainline Critic Echilibrat Cork Dust Wafters The Link 14mm

a0.m.m21059
Stoc epuizat

51,74Lei

Pelete Mainline Expander Activated 4mm 300g/punga

Pelete Mainline Expander Activated 4mm 300g/punga

a0.m.mm3903
Stoc epuizat

21,16Lei

Pop Up Mainline The Link Mini Alb/Roz 8mm

Pop Up Mainline The Link Mini Alb/Roz 8mm

a0.m.m21055
Stoc epuizat

52,11Lei

Pelete Mainline Expander Cell 4mm 300g/punga

Pelete Mainline Expander Cell 4mm 300g/punga

a0.m.mm3901
Stoc epuizat

21,20Lei

Fir Asso Mainline Abrasion Multicolor 0.35mm 1000m

Fir Asso Mainline Abrasion Multicolor 0.35mm 1000m

110108fnasdi276bm1000a60350
Stoc epuizat

69,63Lei

Pop Up Mainline The Link Mini 12mm

Pop Up Mainline The Link Mini 12mm

a0.m.m21053
Stoc epuizat

52,11Lei

Pop Up Mainline Match Wafters Orange Chocolate 8mm

Pop Up Mainline Match Wafters Orange Chocolate 8mm

a0.m.mm3105
Stoc epuizat

30,57Lei

Pelete Mainline Match Carp Cell 1Kg 2mm

Pelete Mainline Match Carp Cell 1Kg 2mm

a0.m.mm3205
Stoc epuizat

28,18Lei

BOILIES MAINLINE HIGH IMPACT FRUITY TUNA 15MM 3KG

BOILIES MAINLINE HIGH IMPACT FRUITY TUNA 15MM 3KG

a0.m.m23121
Stoc epuizat

202,20Lei

NADA MAINLINE PRO ACTIVE PVA STICK CELL 1KG

NADA MAINLINE PRO ACTIVE PVA STICK CELL 1KG

a0.m.m06012
Stoc epuizat

51,19Lei

PELETE MAINLINE MATCH CARP CELL.TM 8MM 1KG

PELETE MAINLINE MATCH CARP CELL.TM 8MM 1KG

a0.m.mm3208
Stoc epuizat

32,86Lei

NADA MAINLINE PRO ACTIVE PVA STICK ESSENTIAL CELL 1KG

NADA MAINLINE PRO ACTIVE PVA STICK ESSENTIAL CELL 1KG

a0.m.m06015
Stoc epuizat

51,19Lei

Pelete Mainline Match Activated Hallibut, 2mm, 1kg/punga

Pelete Mainline Match Activated Hallibut, 2mm, 1kg/punga

a0.m.mm3214
Stoc epuizat

35,13Lei

Atractant Lichid Mainline Syrup Big River Barbel 500ml

Atractant Lichid Mainline Syrup Big River Barbel 500ml

a0.m.mm2713
Stoc epuizat

60,96Lei

Wafters Mainline Clones Barrel Artar, 13mm

Wafters Mainline Clones Barrel Artar, 13mm

a0.m.m43002
Stoc epuizat

46,86Lei

Afişare 141 - 160 din 196 (10 pagini)
Queries: 14, Total time: 171.780 ms [By time] [By id] [By file]
1 (0.137)
SELECT data
FROM `oc_session`
WHERE session_id = '5e45574e0a1b2ea059bbf5e7cc'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.158)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.061)
DROP TEMPORARY TABLE IF EXISTS oc_bf_tmp_product
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:692
5 (167.557)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%mainline%") 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:693
6 (0.157)
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:1547
7 (0.979)
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 140, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
8 (0.271)
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:1204
9 (0.118)
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:1223
10 (0.122)
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:978
11 (1.868)
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:900
12 (0.097)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.074)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
14 (0.075)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38