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


Spinnerbait Sakura Cajun 10.5g Kicker Pink
Exclusiv online!

Spinnerbait Sakura Cajun 10.5g Kicker Pink

130334saplf50043/8-jc10
Livrare 48-72 ore

35,89Lei

Fir, Sakura, Sensibraid, 8X, 0.08mm, 150m, Chartreuse, 110634saple40030.08-cha, Fire Monofilament Rapitori, Fire Monofilament Rapitori Sakura, Sakura
Exclusiv online!

Fir, Sakura, Sensibraid, 8X, 0.08mm, 150m, Chartreuse, 110634saple40030.08-cha, Fire Monofilament Rapitori, Fire Monofilament Rapitori Sakura, Sakura

110634saple40030.08-cha
Livrare 48-72 ore

105,62Lei

Shad Sakura Jackax 140mm Espana Special 1Buc/Plic -27%

Shad Sakura Jackax 140mm Espana Special 1Buc/Plic

130134saplf5005140-es
Livrare imediată!

23,15Lei(-27%) 16,90Lei

Cicada, Sakura, Micro, Soukouss, Blade, 35mm, 7g, Mat, Tiger, 130634saplg501435-m06, Cicade, Cicade Sakura, Sakura

Cicada, Sakura, Micro, Soukouss, Blade, 35mm, 7g, Mat, Tiger, 130634saplg501435-m06, Cicade, Cicade Sakura, Sakura

130634saplg501435-m06
Livrare imediată!

31,34Lei

Crank Sakura SCB 100 F 53mm 10.70gr SSP Alburno Spain Special
Exclusiv online!

Crank Sakura SCB 100 F 53mm 10.70gr SSP Alburno Spain Special

131234saple500353-ssp
Livrare 48-72 ore

49,83Lei

Fir, Sakura, Sensibraid, 8X, 0.10mm, 150m, Chartreuse, 110634saple40030.10-cha, Fire Monofilament Rapitori, Fire Monofilament Rapitori Sakura, Sakura
Exclusiv online!

Fir, Sakura, Sensibraid, 8X, 0.10mm, 150m, Chartreuse, 110634saple40030.10-cha, Fire Monofilament Rapitori, Fire Monofilament Rapitori Sakura, Sakura

110634saple40030.10-cha
Livrare 48-72 ore

105,62Lei

Shad Sakura Jackax 140mm Fire Tiger 1Buc/Plic -49%

Shad Sakura Jackax 140mm Fire Tiger 1Buc/Plic

130134saplf5005140-ft
Livrare imediată!

22,72Lei(-49%) 11,60Lei

Crank, Sakura, SCB, 100, F, 53mm, 10.70gr, M06, Mat, Tiger, 131234saple500353-m06, Voblere Suspending, Voblere Suspending Sakura, Sakura
Exclusiv online!

Crank, Sakura, SCB, 100, F, 53mm, 10.70gr, M06, Mat, Tiger, 131234saple500353-m06, Voblere Suspending, Voblere Suspending Sakura, Sakura

131234saple500353-m06
Livrare 48-72 ore

49,83Lei

Spinnerbait Sakura Cajun 14g Kicker White
Exclusiv online!

Spinnerbait Sakura Cajun 14g Kicker White

130334saplf50041/2-jc11
Livrare 48-72 ore

37,34Lei

Lanseta Sakura Salt Sniper Spinning SALSS 702 MH 2.13m 10-35gr Softbaits Special
Exclusiv online!

Lanseta Sakura Salt Sniper Spinning SALSS 702 MH 2.13m 10-35gr Softbaits Special

20434saprj802270-2mh
Livrare 48-72 ore

321,91Lei

Fir, Sakura, Sensibraid, 8X, 0.12mm, 150m, Chartreuse, 110634saple40030.12-cha, Fire Monofilament Rapitori, Fire Monofilament Rapitori Sakura, Sakura
Exclusiv online!

Fir, Sakura, Sensibraid, 8X, 0.12mm, 150m, Chartreuse, 110634saple40030.12-cha, Fire Monofilament Rapitori, Fire Monofilament Rapitori Sakura, Sakura

110634saple40030.12-cha
Livrare 48-72 ore

105,62Lei

Vobler, Sakura, Notobug, 22F, 22mm, 1.4gr, 09, 80234saplb50392209, Voblere Floating, Voblere Floating Sakura, Sakura

Vobler, Sakura, Notobug, 22F, 22mm, 1.4gr, 09, 80234saplb50392209, Voblere Floating, Voblere Floating Sakura, Sakura

80234saplb50392209
Livrare imediată!

47,95Lei

Vobler Sakura Phoxy Minnow 40 S 40mm 2.6gr RL07 Real Life Vairon
Exclusiv online!

Vobler Sakura Phoxy Minnow 40 S 40mm 2.6gr RL07 Real Life Vairon

80434saplc505540-rl07
Livrare 48-72 ore

48,18Lei

Crank Sakura SCB Micro 39mm 4.10gr SSP Spain Special
Exclusiv online!

Crank Sakura SCB Micro 39mm 4.10gr SSP Spain Special

131234saplg501539-ssp
Livrare 48-72 ore

46,52Lei

Lanseta Sakura Shukan Spin SHUS 762 M 2.29m 10-45gr Topwater Special
Exclusiv online!

Lanseta Sakura Shukan Spin SHUS 762 M 2.29m 10-45gr Topwater Special

20434saprj803276-2m
Livrare 48-72 ore

723,73Lei

Lanseta Sakura Ionizer Spin INSA 702M 2.13m 5-21gr Allround
Exclusiv online!

Lanseta Sakura Ionizer Spin INSA 702M 2.13m 5-21gr Allround

20434saprh800870-2m
Livrare 48-72 ore

773,65Lei

Spinnerbait Sakura Cajun 10.5g Kicker White
Exclusiv online!

Spinnerbait Sakura Cajun 10.5g Kicker White

130334saplf50043/8-jc11
Livrare 48-72 ore

35,89Lei

Agrafa Sakura Nice Snap, Nr.000, 4kg, 10buc/plic
Exclusiv online!

Agrafa Sakura Nice Snap, Nr.000, 4kg, 10buc/plic

410340021
Livrare 48-72 ore

9,09Lei

Spinnerbait Sakura Cajun 14g Gill
Exclusiv online!

Spinnerbait Sakura Cajun 14g Gill

130334saplf50041/2-jc9
Livrare 48-72 ore

37,34Lei

Spinnerbait Sakura Cajun 14g Rainbow Shad
Exclusiv online!

Spinnerbait Sakura Cajun 14g Rainbow Shad

130334saplf50041/2-jc1
Livrare 48-72 ore

37,34Lei

Afişare 141 - 160 din 341 (18 pagini)
Queries: 14, Total time: 210.083 ms [By time] [By id] [By file]
1 (0.107)
SELECT data
FROM `oc_session`
WHERE session_id = 'c51c0ecca5f50ec03cf6afbd11'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.080)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (205.978)
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 = '3' AND (pd.tag LIKE "%sakura%") 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:698
5 (1.670)
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:184
6 (0.757)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '103606' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
7 (0.259)
SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '103606' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1289
8 (0.260)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '103606' AND a.attribute_group_id = '23' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1294
9 (0.223)
SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '103606' AND a.attribute_group_id = '59' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1294
10 (0.153)
SELECT *
FROM oc_product_image
WHERE product_id = '103606'
ORDER BY sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1390
11 (0.132)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=103606'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
12 (0.120)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.116)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
14 (0.124)
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