Owner


Carlig Owner Seigo, BH 51440, Nr. 4, 9buc/plic -12%

Carlig Owner Seigo, BH 51440, Nr. 4, 9buc/plic

5144006
Livrare imediată!

10,24Lei(-12%) 9,03Lei

Carlig Owner Aji-B 50015 Nr 8

Carlig Owner Aji-B 50015 Nr 8

5001504
Livrare imediată!

11,17Lei

Carlig Owner Sode 50257 Nr 10

Carlig Owner Sode 50257 Nr 10

5025703
Livrare 48-72 ore

11,41Lei

Carlig Owner Chika 50354 Nr 8

Carlig Owner Chika 50354 Nr 8

5035401
Livrare 48-72 ore

11,58Lei

Carlig Owner Izu Mezina 50673 Nr 12

Carlig Owner Izu Mezina 50673 Nr 12

5067312
Livrare 48-72 ore

13,76Lei

Carlig Owner Chika 53938 Nr 16 -12%

Carlig Owner Chika 53938 Nr 16

5393805
Livrare imediată!

8,29Lei(-12%) 7,32Lei

Shad Owner Jr Minnow JRM88 88mm Blue Gill

Shad Owner Jr Minnow JRM88 88mm Blue Gill

801025587110
Livrare 48-72 ore

25,88Lei

Vobler Owner Tango Dancer 5249 TD-95 95mm 11gr 27 Rainbow Trout

Vobler Owner Tango Dancer 5249 TD-95 95mm 11gr 27 Rainbow Trout

804020104
Livrare 48-72 ore

48,51Lei

Struna Owner Nr.3 30lb 50cm Nr.8 Pro Wire Rig 50QS

Struna Owner Nr.3 30lb 50cm Nr.8 Pro Wire Rig 50QS

402538293
Livrare imediată!

20,03Lei

Rig Crap Owner 56992 Nr.2 25Lb Linealigner Rig -21%

Rig Crap Owner 56992 Nr.2 25Lb Linealigner Rig

5699202
Livrare imediată!

12,02Lei(-21%) 9,53Lei

Jig Owner Lestat 11751 Nr. 4 4 gr. Jig 28 BC -13%

Jig Owner Lestat 11751 Nr. 4 4 gr. Jig 28 BC

117510404
Livrare imediată!

15,00Lei(-13%) 13,10Lei

Twin Tail Owner RB1 13 Ring Twin Tail 82905 Smoke Ring

Twin Tail Owner RB1 13 Ring Twin Tail 82905 Smoke Ring

8290516
Livrare 48-72 ore

16,55Lei

Fir Owner Broad Silver Eye 0.20 mm 150 m

Fir Owner Broad Silver Eye 0.20 mm 150 m

6025611320
Livrare 48-72 ore

42,08Lei

Carlig Owner 50571 Nr.9 Hera Buna BL -40%

Carlig Owner 50571 Nr.9 Hera Buna BL

5057109
Livrare imediată!

9,40Lei(-40%) 5,67Lei

Rig Feeder Owner 56931 Nr.8 0.22 FD-53 Quick Stop BL

Rig Feeder Owner 56931 Nr.8 0.22 FD-53 Quick Stop BL

5693508
Livrare imediată!

19,64Lei

Rig Feeder Owner 56933 No.8 0.22 FD-63 Quick Stop BL

Rig Feeder Owner 56933 No.8 0.22 FD-63 Quick Stop BL

12030256933-108
Livrare 48-72 ore

23,34Lei

Carlig Owner 50281 No.11 Sode Light

Carlig Owner 50281 No.11 Sode Light

5000703
Livrare 48-72 ore

11,41Lei

Fir Owner Broad Fluorine Treated 0.16mm 150m

Fir Owner Broad Fluorine Treated 0.16mm 150m

11070256045-016
Livrare imediată!

46,56Lei

Carlig Owner 50057 Negru Semirotund, Nr.8, 17buc/pac

Carlig Owner 50057 Negru Semirotund, Nr.8, 17buc/pac

5005713
Livrare imediată!

13,60Lei

Vierme Owner Shiver Tail 115mm 06 Watermelon Green

Vierme Owner Shiver Tail 115mm 06 Watermelon Green

1301375597-06
Livrare 48-72 ore

20,75Lei

Afişare 1221 - 1240 din 1550 (78 pagini)
💬
WhatsApp Chat
👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)
Queries: 7, Total time: 86.100 ms [By time] [By id] [By file]
1 (0.120)
SELECT data
FROM `oc_session`
WHERE session_id = '32d424daa7690e5fc01330682b'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.139)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.137)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '15' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (34.809)
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 = '15'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (50.641)
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 = '15' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 1220,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.152)
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