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

Oferte speciale


Geanta Jrc Defender Compact Carryall L

1445867
Livrare imediată!

247,50Lei(-33%) 165,01Lei

Geanta Jrc Defender Compact Carryall M

1445866
Livrare imediată!

225,01Lei(-30%) 157,00Lei

Geanta Jrc Pentru Plumbi/accesorii Large

1445881
Livrare imediată!

90,00Lei(-38%) 56,00Lei

Geanta Jrc Pentru Plumbi/accesorii Medium

1445880
Livrare imediată!

67,50Lei(-33%) 45,01Lei

Geanta Juvelnic Tf By Dome Rotunda 60cm

5286-060
Livrare imediată!

203,00Lei(-45%) 110,90Lei

Geanta K-karp Boilies Pioneer Pro Air Dry

193-30-360
Livrare imediată!

62,90Lei(-25%) 46,90Lei

Geanta Matrix Ethos Pro Net Accessory Bag

glu074
Livrare imediată!

415,94Lei(-20%) 332,75Lei

Geanta Mivardi Spinn Bag Executive Pro

m-sbexps
Livrare imediată!

349,00Lei(-28%) 249,90Lei

Geanta Nash Security Pouch

t3581
Livrare imediată!

115,99Lei(-29%) 82,48Lei

104,32Lei(-33%) 69,48Lei

125,99Lei(-34%) 82,72Lei

Exclusiv online!

Geanta Plano Guide Series Tackle Bag 3600

plabg360
Livrare 7-14 zile

540,00Lei(-25%) 405,00Lei

Exclusiv online!

Geanta Plano Guide Series Tackle Bag 3700

plabg370
Livrare 7-14 zile

630,00Lei(-25%) 472,00Lei

Exclusiv online!

Geanta Plumbi Prologic Avanger L 20x10x12cm

a8.pro.65071
Livrare 24-48 ore

71,50Lei(-20%) 57,19Lei

Geanta Prologic Avenger Carryall M 56x38x36cm

a8.pro.65062
Livrare imediată!

305,46Lei(-23%) 234,99Lei

Geanta Prologic Storm Safe 20x34x6.5cm

a8.pro.72729
Livrare imediată!

94,00Lei(-22%) 72,90Lei

Geanta Prologic Storm Safe Deep 10x17x13cm

a8.pro.72728
Livrare imediată!

77,50Lei(-20%) 62,00Lei

Geanta Quantum 4street Pusher Bag 19x23x5cm

8810001
Livrare imediată!

71,78Lei(-44%) 39,90Lei

Exclusiv online!

Geanta Rapala Countdown Hip Bag

rbcdhp
Livrare 48-72ore

209,00Lei(-19%) 169,00Lei

Exclusiv online!

359,00Lei(-17%) 299,00Lei

Afişare 5021 - 5040 din 9629 (482 pagini)
Queries: 24, Total time: 284.139 ms [By time] [By id] [By file]
1 (0.073)
SELECT data
FROM `oc_session`
WHERE session_id = '948b13c0aa6997ea6af1adddd3'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.089)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.090)
SELECT *
FROM `oc_language`
WHERE status = '1'
/var/www/clients/client1/web1/web/index.php:313
4 (0.065)
SELECT *
FROM oc_currency
/var/www/clients/client1/web1/web/system/library/currency.php:17
5 (0.233)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/tax.php:32
6 (0.269)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/tax.php:60
7 (0.148)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
/var/www/clients/client1/web1/web/system/library/weight.php:12
8 (0.104)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
/var/www/clients/client1/web1/web/system/library/length.php:12
9 (0.069)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:414
10 (150.104)
SELECT COUNT(1) AS total
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '2' 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())) AND p.quantity > '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1665
11 (131.346)
SELECT DISTINCT ps.product_id
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
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)
WHERE p.status = '1' AND p.quantity > '0' AND p.date_available <= NOW() AND p2s.store_id = '2' 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())) GROUP BY ps.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 5020,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:580
12 (0.137)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
13 (0.126)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
14 (0.128)
SELECT layout_id
FROM oc_layout_route
WHERE 'product/special' LIKE route AND store_id = '2'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
15 (0.122)
SELECT *
FROM oc_layout_module
WHERE layout_id = '16' AND position = 'column_left'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
16 (0.125)
SELECT layout_id
FROM oc_layout_route
WHERE 'product/special' LIKE route AND store_id = '2'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
17 (0.123)
SELECT *
FROM oc_layout_module
WHERE layout_id = '16' AND position = 'column_right'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
18 (0.121)
SELECT layout_id
FROM oc_layout_route
WHERE 'product/special' LIKE route AND store_id = '2'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
19 (0.085)
SELECT *
FROM oc_layout_module
WHERE layout_id = '16' AND position = 'content_top'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
20 (0.110)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
21 (0.124)
SELECT layout_id
FROM oc_layout_route
WHERE 'product/special' LIKE route AND store_id = '2'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
22 (0.119)
SELECT *
FROM oc_layout_module
WHERE layout_id = '16' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
23 (0.109)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
24 (0.120)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:32