Sportex


LANSETA SPORTEX CAPTOR RS-2 SPIN 2.70M 60G 2SEG

LANSETA SPORTEX CAPTOR RS-2 SPIN 2.70M 60G 2SEG

cp2713
Livrare 48-72 ore

1.149,89Lei

Lanseta Sportex Jig-Xpert Pike Baitcast 245, 34-97g

Lanseta Sportex Jig-Xpert Pike Baitcast 245, 34-97g

jx2405
Livrare 48-72 ore

886,54Lei

LANSETA SPORTEX HYPERION XT 2.40M 26-48G -29%

LANSETA SPORTEX HYPERION XT 2.40M 26-48G

hp2412
Livrare imediată!

1.868,00Lei(-29%) 1.330,98Lei

Lanseta Sportex MAGNIFIC FINESSE ML 195 2-10gr -24%

Lanseta Sportex MAGNIFIC FINESSE ML 195 2-10gr

mg1900
Livrare 48-72 ore

1.469,00Lei(-24%) 1.122,44Lei

Lanseta Sportex XCLUSIVE FEEDER NT MEDIUM HEAVY 390 100-190gr -24%

Lanseta Sportex XCLUSIVE FEEDER NT MEDIUM HEAVY 390 100-190gr

mh3918
Livrare 48-72 ore

1.420,00Lei(-24%) 1.084,81Lei

HUSA SPORTEX PROTECTIE LANSETE NEOPRENE Small

HUSA SPORTEX PROTECTIE LANSETE NEOPRENE Small

s300719
Livrare 48-72 ore

164,60Lei

LANSETA SPORTEX CURVE SPIN RS-2 2.70M 20G 2SEG

LANSETA SPORTEX CURVE SPIN RS-2 2.70M 20G 2SEG

ps2711
Livrare 48-72 ore

967,88Lei

Lanseta Sportex Jig-Xpert Perch 192 1-11g

Lanseta Sportex Jig-Xpert Perch 192 1-11g

jx1900
Livrare imediată!

701,58Lei

Lanseta Sportex Rapid Travel Spin 260 60g 4seg

Lanseta Sportex Rapid Travel Spin 260 60g 4seg

rp2603
Livrare 48-72 ore

814,34Lei

Lanseta Sportex NOVA VERTICAL 195 50gr -28%

Lanseta Sportex NOVA VERTICAL 195 50gr

pt1903
Livrare 48-72 ore

641,00Lei(-28%) 458,46Lei

Lanseta Sportex NEPTOON BOAT 215 20lbs -28%

Lanseta Sportex NEPTOON BOAT 215 20lbs

jo2134
Livrare 48-72 ore

725,00Lei(-28%) 518,45Lei

Geanta Sportex EVA Pliabila, XL

Geanta Sportex EVA Pliabila, XL

s321011
Livrare 48-72 ore

276,45Lei

LANSETA SPORTEX HYDRA SPIRIT 2.40M 60G 2SEG

LANSETA SPORTEX HYDRA SPIRIT 2.40M 60G 2SEG

hy2403
Livrare imediată!

1.007,64Lei

Lanseta Sportex Advancer Cs-2 Carp Spod 13ft 3.96m 5.50lbs

Lanseta Sportex Advancer Cs-2 Carp Spod 13ft 3.96m 5.50lbs

ad151551
Livrare imediată!

712,67Lei

Lanseta Sportex Rapid Spin 240 40g

Lanseta Sportex Rapid Spin 240 40g

rp2402
Livrare imediată!

682,26Lei

Varf Feeder Sportex Rapid Method Feeder 3.60m/2.0oz -29%

Varf Feeder Sportex Rapid Method Feeder 3.60m/2.0oz

mf3622a1
Livrare imediată!

68,99Lei(-29%) 48,79Lei

BLUZA SPORTEX BLACK XXL -17%

BLUZA SPORTEX BLACK XXL

s503204
Livrare 48-72 ore

99,00Lei(-17%) 82,24Lei

Lanseta Sportex FBC CS-3 CARP 12FT 3.96M 3.75lbs

Lanseta Sportex FBC CS-3 CARP 12FT 3.96M 3.75lbs

fb141375
Livrare 48-72 ore

2.807,28Lei

LANSETA SPORTEX HYDRA SPIRIT 2.10M 20G 2SEG

LANSETA SPORTEX HYDRA SPIRIT 2.10M 20G 2SEG

hy2101
Livrare 48-72 ore

886,54Lei

Lanseta SPORTEX Rapid Feeder Light XS, 3.00m, 35-85g, 2+3seg

Lanseta SPORTEX Rapid Feeder Light XS, 3.00m, 35-85g, 2+3seg

lf3034
Livrare 48-72 ore

810,28Lei

Afişare 221 - 240 din 397 (20 pagini)
Queries: 7, Total time: 596.884 ms [By time] [By id] [By file]
1 (0.143)
SELECT data
FROM `oc_session`
WHERE session_id = 'db41a4b70b5a0c50d6c927abf4'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.149)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.147)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Sportex'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.160)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '192' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (303.932)
SELECT COUNT(1) AS total
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)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '0' AND p.manufacturer_id = '192'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (282.938)
SELECT p.product_id, (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 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, ps.price AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN (SELECT pss.price, pss.product_id
FROM oc_product_special pss GROUP BY pss.product_id) ps 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 pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '0' AND p.manufacturer_id = '192' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 220,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (9.415)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37