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 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Oferte speciale


Cort Jrc The Stealth Bloxx Cpt 2g Bivvies, 270x195x135cm -27%

Cort Jrc The Stealth Bloxx Cpt 2g Bivvies, 270x195x135cm

1485819
Livrare imediată!

1.914,87Lei(-27%) 1.399,11Lei

Cort Sloar Quick Up Shelter Green Mkii With Heavy Duty Ground Sheet, 2.50x2.05x1.70cm -19%

Cort Sloar Quick Up Shelter Green Mkii With Heavy Duty Ground Sheet, 2.50x2.05x1.70cm

bv01mk2
Livrare imediată!

2.129,99Lei(-19%) 1.729,56Lei

Cort Solar Sp 6-hub Cube Shelter, 300x350x217cm -32%

Cort Solar Sp 6-hub Cube Shelter, 300x350x217cm

bv20
Livrare imediată!

2.999,95Lei(-32%) 2.033,60Lei

Cort Solar Sp Cube Shelter, 2.40x2.40x2.40cm -8%

Cort Solar Sp Cube Shelter, 2.40x2.40x2.40cm

bv14mk2
Livrare imediată!

2.555,50Lei(-8%) 2.339,60Lei

Costum Iarna Norfin Arctic 2, Olive / Back, Marime S -25%
Exclusiv online!

Costum Iarna Norfin Arctic 2, Olive / Back, Marime S

421101-s
Livrare 24-48 ore

1.135,00Lei(-25%) 850,03Lei

Costum Savage Gear Sg2 Thermal Bluenights/black L -39%

Costum Savage Gear Sg2 Thermal Bluenights/black L

a8.sg.76592
Livrare imediată!

970,46Lei(-39%) 593,07Lei

Costum Savage Gear Sg2 Thermal Bluenights/black Xl -49%
Exclusiv online!

Costum Savage Gear Sg2 Thermal Bluenights/black Xl

a8.sg.76593
Livrare 24-48 ore

970,46Lei(-49%) 494,39Lei

Costum Savage Gear Sg2 Thermal Bluenights/black Xxl -39%
Exclusiv online!

Costum Savage Gear Sg2 Thermal Bluenights/black Xxl

a8.sg.76594
Livrare 24-48 ore

970,46Lei(-39%) 593,07Lei

Costum Savage Gear Sg2 Thermal Bluenights/black Xxxl -39%
Exclusiv online!

Costum Savage Gear Sg2 Thermal Bluenights/black Xxxl

a8.sg.76595
Livrare 24-48 ore

970,46Lei(-39%) 593,07Lei

Costum Trakker Cr 2 Piece Winter Suit, Large, Camo -13%

Costum Trakker Cr 2 Piece Winter Suit, Large, Camo

206372
Livrare imediată!

599,95Lei(-13%) 519,53Lei

Costum Trakker Cr 2 Piece Winter Suit, Medium, Camo -13%

Costum Trakker Cr 2 Piece Winter Suit, Medium, Camo

206371
Livrare imediată!

599,95Lei(-13%) 519,53Lei

Costum Trakker Cr 2 Piece Winter Suit, Small, Camo -13%

Costum Trakker Cr 2 Piece Winter Suit, Small, Camo

206370
Livrare imediată!

599,95Lei(-13%) 519,53Lei

Costum Trakker Cr 2 Piece Winter Suit, Xl, Camo -13%

Costum Trakker Cr 2 Piece Winter Suit, Xl, Camo

206373
Livrare imediată!

599,95Lei(-13%) 519,53Lei

Costum Trakker Cr 2 Piece Winter Suit, Xxl, Camo -13%

Costum Trakker Cr 2 Piece Winter Suit, Xxl, Camo

206374
Livrare imediată!

599,95Lei(-13%) 519,53Lei

Costum Trakker Cr 2 Piece Winter Suit, Xxxl, Camo -13%

Costum Trakker Cr 2 Piece Winter Suit, Xxxl, Camo

206375
Livrare imediată!

599,95Lei(-13%) 519,53Lei

Costum Trakker Cr 3 Piece Winter Suit, Camo, Marime L -13%

Costum Trakker Cr 3 Piece Winter Suit, Camo, Marime L

206380
Livrare imediată!

899,95Lei(-13%) 778,82Lei

Costum Trakker Cr 3 Piece Winter Suit, Camo, Marime S -13%

Costum Trakker Cr 3 Piece Winter Suit, Camo, Marime S

206378
Livrare imediată!

899,95Lei(-13%) 778,82Lei

Costum Trakker Cr 3 Piece Winter Suit, Camo, Marime Xl -13%

Costum Trakker Cr 3 Piece Winter Suit, Camo, Marime Xl

206381
Livrare imediată!

899,95Lei(-13%) 778,82Lei

Costum Trakker Cr2 2-piece Winter Fishing Suit, Marime Large -13%

Costum Trakker Cr2 2-piece Winter Fishing Suit, Marime Large

206317
Livrare imediată!

599,95Lei(-13%) 519,53Lei

Costum Trakker Cr2 2-piece Winter Fishing Suit, Marime Medium -13%

Costum Trakker Cr2 2-piece Winter Fishing Suit, Marime Medium

206316
Livrare imediată!

599,95Lei(-13%) 519,53Lei

Afişare 681 - 700 din 9247 (463 pagini)
Queries: 5, Total time: 602.449 ms [By time] [By id] [By file]
1 (0.116)
SELECT data
FROM `oc_session`
WHERE session_id = 'f007ec98b66448dc06b743f41d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.115)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (287.999)
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 p2s.store_id = '3' 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:1714
4 (314.014)
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 p2s.store_id = '3' 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 680,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.205)
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