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 - Swingere Si Hangere

Produse ce potrivesc criteriilor de căutare


Boilies NASH Scopex Squid Stabilised 20mm 1kg

Boilies NASH Scopex Squid Stabilised 20mm 1kg

b6802
Stoc epuizat

69,99Lei

Boilies NASH Scopex Squid Stabilised 12mm 5Kg

Boilies NASH Scopex Squid Stabilised 12mm 5Kg

b6805
Stoc epuizat

269,99Lei

Boilies NASH Scopex Squid Stabilised 12mm 1kg

Boilies NASH Scopex Squid Stabilised 12mm 1kg

b6800
Stoc epuizat

75,99Lei

Boilies NASH Scopex Squid Stabilised 24mm 5Kg -20%

Boilies NASH Scopex Squid Stabilised 24mm 5Kg

b6808
Stoc epuizat

246,00Lei(-20%) 196,80Lei

Boilies NASH Scopex Squid Stabilised 24mm 1kg -20%

Boilies NASH Scopex Squid Stabilised 24mm 1kg

b6803
Stoc epuizat

70,00Lei(-20%) 56,00Lei

PelletBoilies solubil scopex 24mm 5kg

PelletBoilies solubil scopex 24mm 5kg

sbc22098
Stoc epuizat

85,00Lei

PelletBoilies tare scopex 24mm 5kg

PelletBoilies tare scopex 24mm 5kg

sbc22099
Stoc epuizat

85,00Lei

PelletBoilies solubil scopex 20mm 5kg

PelletBoilies solubil scopex 20mm 5kg

sbc22096
Stoc epuizat

95,00Lei

PelletBoilies tare scopex 20mm 1kg

PelletBoilies tare scopex 20mm 1kg

sbc22093
Stoc epuizat

18,00Lei

PelletBoilies tare scopex 20mm 5kg

PelletBoilies tare scopex 20mm 5kg

sbc22097
Stoc epuizat

95,00Lei

PelletBoilies tare scopex 24mm 1kg

PelletBoilies tare scopex 24mm 1kg

sbc22095
Stoc epuizat

18,00Lei

PelletBoilies solubil scopex 20mm 1kg

PelletBoilies solubil scopex 20mm 1kg

sbc22092
Stoc epuizat

20,00Lei

PelletBoilies solubil scopex 24mm 1kg

PelletBoilies solubil scopex 24mm 1kg

sbc22094
Stoc epuizat

20,00Lei

Boilies Select Baits Nutty Scopex - 15mm - 5kg

Boilies Select Baits Nutty Scopex - 15mm - 5kg

sb1665
Stoc epuizat

249,00Lei

Boilies Select Baits Nutty Scopex - 20mm - 5kg

Boilies Select Baits Nutty Scopex - 20mm - 5kg

sb1625
Stoc epuizat

249,00Lei

Aditiv Nash Scopex Squid Hookbait Spray, 50ml

Aditiv Nash Scopex Squid Hookbait Spray, 50ml

b6374
Stoc epuizat

34,25Lei

Fluo Smoke Dip Delphin D Snax Liquix, Scopex & Vanilie, 100ml

Fluo Smoke Dip Delphin D Snax Liquix, Scopex & Vanilie, 100ml

101003539
Stoc epuizat

34,00Lei

Pop UP Wlc Scopex Portocaliu Fluo 14mm

Pop UP Wlc Scopex Portocaliu Fluo 14mm

w13906
Stoc epuizat

17,00Lei

Atractant Feeder Bait Spray Atomizer, Scopex, 50ml

Atractant Feeder Bait Spray Atomizer, Scopex, 50ml

fb4-15
Stoc epuizat

14,00Lei

Pop Up Delphin D Snax, Scopex & Vanilie, 10mm, 20g

Pop Up Delphin D Snax, Scopex & Vanilie, 10mm, 20g

101003527
Stoc epuizat

21,00Lei

Afişare 141 - 160 din 206 (11 pagini)
Queries: 17, Total time: 205.173 ms [By time] [By id] [By file]
1 (0.151)
SELECT data
FROM `oc_session`
WHERE session_id = 'a7f3cf8c1bf10e336a53eb76b7'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.116)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.117)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (202.695)
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 "%scopex%") 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.147)
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.105)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"FICOVA COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.081)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"FICOVA COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.077)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"FICOVA COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.075)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"FICOVA COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.075)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"FICOVA COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
11 (0.074)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"FICOVA COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
12 (0.074)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"FICOVA COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
13 (0.100)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"FICOVA COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
14 (0.077)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"WILD LIFE CONCEPT SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
15 (0.071)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
16 (0.062)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
17 (0.076)
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