Sportex


TUB Sportex RIGID LANSETE VIII 165CM Grey

TUB Sportex RIGID LANSETE VIII 165CM Grey

s308168
Livrare 48-72 ore

429,99Lei

Lanseta Sportex NEPTOON JIGGING 210 30lbs

Lanseta Sportex NEPTOON JIGGING 210 30lbs

jo2111
Livrare 48-72 ore

812,00Lei

Geanta Sportex EVA Pliabila, XL

Geanta Sportex EVA Pliabila, XL

s321011
Livrare 48-72 ore

260,00Lei

LANSETA, SPORTEX, HYDRA, SPIRIT, 2.40M, 80G, 2SEG, hy2404, Lansete Rapitori, Lansete Rapitori Sportex, Sportex
Lanseta Sportex Advancer Cs-2 Carp 13ft 3.96m 3.75lbs

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

ad151376
Livrare imediată!

650,00Lei

Lanseta, Sportex, Rapid, Spin, 270, 20g, rp2701, Lansete Rapitori, Lansete Rapitori Sportex, Sportex

Lanseta, Sportex, Rapid, Spin, 270, 20g, rp2701, Lansete Rapitori, Lansete Rapitori Sportex, Sportex

rp2701
Livrare imediată!

650,00Lei

HUSA RIGIDA SPORTEX LANSETE II 2 COMPARTIMENTE 150CM GREY

HUSA RIGIDA SPORTEX LANSETE II 2 COMPARTIMENTE 150CM GREY

s302158
Livrare imediată!

499,00Lei

Lanseta Sportex COMPETITION CRAP CS-4 LONG RANGE 13FT 3.96M 3-5oz -20%

Lanseta Sportex COMPETITION CRAP CS-4 LONG RANGE 13FT 3.96M 3-5oz

cc144560
Livrare imediată!

920,00Lei(-20%) 736,00Lei

Lanseta Sportex CATFIRE SPIN 270 70-190gr

Lanseta Sportex CATFIRE SPIN 270 70-190gr

cf2714
Livrare 48-72 ore

830,00Lei

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.799,00Lei

LANSETA SPORTEX NOVA DROPSHOT RS-2 2.50M 15G 2seg

LANSETA SPORTEX NOVA DROPSHOT RS-2 2.50M 15G 2seg

pt2512
Livrare 48-72 ore

730,01Lei

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

760,01Lei

Lanseta Sportex Jig-Xpert Zander Baitcast 210, 8-29g

Lanseta Sportex Jig-Xpert Zander Baitcast 210, 8-29g

jx2101
Livrare 48-72 ore

630,00Lei

Varf, Feeder, Sportex, Rapid, Method, Feeder, 3.60m/3.0oz, mf3622a2, Varfuri Feeder, Varfuri Feeder Sportex, Sportex -32%

Varf, Feeder, Sportex, Rapid, Method, Feeder, 3.60m/3.0oz, mf3622a2, Varfuri Feeder, Varfuri Feeder Sportex, Sportex

mf3622a2
Livrare imediată!

69,00Lei(-32%) 47,01Lei

Lanseta Sportex MAGNIFIC FINESSE L 205 1.6-8gr

Lanseta Sportex MAGNIFIC FINESSE L 205 1.6-8gr

mg2001
Livrare 48-72 ore

1.420,00Lei

Lanseta Sportex GRAPHENON BAITCAST 210 40gr Fuji Sic K

Lanseta Sportex GRAPHENON BAITCAST 210 40gr Fuji Sic K

gs2122
Livrare 48-72 ore

2.460,00Lei

Lanseta Sportex XCLUSIVE FEEDER NT HEAVY 360 150-220gr

Lanseta Sportex XCLUSIVE FEEDER NT HEAVY 360 150-220gr

hf3629
Livrare imediată!

1.440,00Lei

LANSETA SPORTEX TOP CAT SPIN 275 60-120gr

LANSETA SPORTEX TOP CAT SPIN 275 60-120gr

tw2706
Livrare 48-72 ore

1.270,00Lei

LANSETA SPORTEX XCITE SPIN 2.70M 60G 2SEG

LANSETA SPORTEX XCITE SPIN 2.70M 60G 2SEG

pm2713
Livrare 48-72 ore

730,01Lei

LANSETA, SPORTEX, CAPTOR, RS-2, SPIN, 2.40M, 60G, 2SEG, cp2413, Lansete Rapitori, Lansete Rapitori Sportex, Sportex
Afişare 121 - 140 din 357 (18 pagini)
Queries: 7, Total time: 63.169 ms [By time] [By id] [By file]
1 (0.140)
SELECT data
FROM `oc_session`
WHERE session_id = '9b9674d22d77969650a4670df6'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.112)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.138)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Sportex'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.133)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (28.865)
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 = '3' AND p.manufacturer_id = '192'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (33.681)
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, (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, p.viewed, p.price
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 = '3' AND p.manufacturer_id = '192' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 120,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.099)
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