FL.


HUSA FL 2COMPARTIMENTE 600D 1.60MT

HUSA FL 2COMPARTIMENTE 600D 1.60MT

3241022670568
Livrare 48-72 ore

109,00Lei

Undita Chinezeasca FL High Carbon Putere 5kg, 5.4m -21%

Undita Chinezeasca FL High Carbon Putere 5kg, 5.4m

2642306232600
Livrare imediată!

280,00Lei(-21%) 219,90Lei

AVERTIZOR INDIVIDUAL FL JY-70 CULOARE Rosu -10%

AVERTIZOR INDIVIDUAL FL JY-70 CULOARE Rosu

fl-jy-70-rosu
Livrare imediată!

47,90Lei(-10%) 42,90Lei

BAIT BANDS FL 4-5-6-7-8MM

BAIT BANDS FL 4-5-6-7-8MM

64-16292
Livrare imediată!

7,50Lei

Cosulet Feeder FL Patrat cu Pini 30g

Cosulet Feeder FL Patrat cu Pini 30g

65-03346
Livrare imediată!

5,90Lei

SET 5 MANERE MULINETA FL ARGINTII RABATABILI MARI MODEL 23

SET 5 MANERE MULINETA FL ARGINTII RABATABILI MARI MODEL 23

7195238610503
Livrare 48-72 ore

46,90Lei

LANSETA FEEDER FL STRATEGIST LAKE FEEDER 3.90M, 80G, 3+3SEG

LANSETA FEEDER FL STRATEGIST LAKE FEEDER 3.90M, 80G, 3+3SEG

64-4026
Livrare imediată!

249,90Lei

LANSETA PRO FL TELE EXCLUSIVE TROUT 4.00M 10-40G

LANSETA PRO FL TELE EXCLUSIVE TROUT 4.00M 10-40G

64-4011
Livrare imediată!

189,90Lei

HANGER FL ILUMINAT CULOARE ALBASTRU -9%

HANGER FL ILUMINAT CULOARE ALBASTRU

fl-sw-11-blue
Livrare 48-72 ore

21,90Lei(-9%) 19,90Lei

SUPORT FEEDER PRO FL REAPER Mini

SUPORT FEEDER PRO FL REAPER Mini

64-26819
Livrare imediată!

39,90Lei

SET PRO FL 8 CARLIGE LEGATE TEXTIL 10CM CU SPIN CARLIG Power Carp Feeder NR 8

SET PRO FL 8 CARLIGE LEGATE TEXTIL 10CM CU SPIN CARLIG Power Carp Feeder NR 8

64-26581
Livrare imediată!

18,90Lei

Y Minciog FL Metal Universal

Y Minciog FL Metal Universal

1255190354726
Livrare 48-72 ore

15,20Lei

MULINETA PRO FL STRATEGIST FEEDER PRO BLUE 8000

MULINETA PRO FL STRATEGIST FEEDER PRO BLUE 8000

3183242656093
Livrare imediată!

289,90Lei

Pichet Telescopic FL Gros Negru Fara Bughiu

Pichet Telescopic FL Gros Negru Fara Bughiu

8231204781682
Livrare imediată!

27,91Lei

Lanseta FL Eternity Tele Carp 3.60m

Lanseta FL Eternity Tele Carp 3.60m

3153171525289
Livrare 48-72 ore

139,90Lei

LINGURITA PRO FL PASTRAV SPIRAL SPOON 2.5G CULOARE 05

LINGURITA PRO FL PASTRAV SPIRAL SPOON 2.5G CULOARE 05

64-80453
Livrare imediată!

11,90Lei

Maner Minciog Carbon FL Toreador Telescopic 3M

Maner Minciog Carbon FL Toreador Telescopic 3M

5153210430756
Livrare 48-72 ore

98,40Lei

MINCIOG PRO FL RABATABIL COADA TELESCOPICA 60CM DESCHIDERE 50CM CU FLOATOARE

MINCIOG PRO FL RABATABIL COADA TELESCOPICA 60CM DESCHIDERE 50CM CU FLOATOARE

6427559061032
Livrare imediată!

76,90Lei

Vobler FL FL504 Floating 40mm 5.5g Depth 1.5m Colour 96

Vobler FL FL504 Floating 40mm 5.5g Depth 1.5m Colour 96

fl504-floating-1.5m-40mm-5.5g-96
Livrare imediată!

17,10Lei

Vobler FL FL601 Sinking 70mm 16.0g Depth Deepwater Colour 356

Vobler FL FL601 Sinking 70mm 16.0g Depth Deepwater Colour 356

fl601-sinking-deepwater-70mm-16.0g-356
Livrare imediată!

17,10Lei

Afişare 221 - 240 din 2006 (101 pagini)
Queries: 7, Total time: 106.082 ms [By time] [By id] [By file]
1 (0.085)
SELECT data
FROM `oc_session`
WHERE session_id = '25247c204f0d7be857d5c0347d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.076)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.102)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fl..html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.098)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '13' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (44.219)
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 = '13'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (61.388)
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 = '3' AND p.manufacturer_id = '13' 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 (0.114)
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