Owner


Carlige Legate Owner S-560 No.12, 65cm, 0.12mm

Carlige Legate Owner S-560 No.12, 65cm, 0.12mm

5691612
Livrare imediată!

13,43Lei

Carlige Legate Owner RL340 53816 Nr.9 Fir 0.16mm

Carlige Legate Owner RL340 53816 Nr.9 Fir 0.16mm

5381609
Livrare imediată!

21,82Lei

Carlig Owner C-4 Carp Aya Nr.6

Carlig Owner C-4 Carp Aya Nr.6

5000044
Livrare 48-72 ore

14,77Lei

CARLIG OWNER MINNOW S-55M cod 51770 Nr.4

CARLIG OWNER MINNOW S-55M cod 51770 Nr.4

5177001
Livrare 48-72 ore

11,92Lei

ANCORA OWNER ST26 BC Nr.14

ANCORA OWNER ST26 BC Nr.14

5626004
Livrare 48-72 ore

39,46Lei

Ancora Owner ST66 TN Nr.1

Ancora Owner ST66 TN Nr.1

5666109
Livrare 48-72 ore

64,99Lei

Jig Owner Amaz Jig-28 11751 Bend Fine Wire, No.6, 17buc/plic

Jig Owner Amaz Jig-28 11751 Bend Fine Wire, No.6, 17buc/plic

1175106
Livrare 48-72 ore

18,28Lei

Carlige Owner Seigo 50610, Nr.6, 11buc/plic

Carlige Owner Seigo 50610, Nr.6, 11buc/plic

5061007
Livrare 48-72 ore

12,41Lei

Carlig Owner So-Chinu 50081 Nr 5

Carlig Owner So-Chinu 50081 Nr 5

5008105
Livrare 48-72 ore

11,41Lei

Carlig Owner Sode 50282 Nr 14

Carlig Owner Sode 50282 Nr 14

5028207
Livrare imediată!

11,58Lei

Carlig Owner Chika 50363 Nr 14

Carlig Owner Chika 50363 Nr 14

5036304
Livrare imediată!

11,17Lei

Carlig Owner Pint-S 50922 NR 16

Carlig Owner Pint-S 50922 NR 16

5092207
Livrare imediată!

11,58Lei

Carlig Owner Keiryu 56807 Nr 7

Carlig Owner Keiryu 56807 Nr 7

5680707
Livrare 48-72 ore

11,58Lei

Vobler Owner Shallow Runner 5227 TWO-38SR 38mm 3.5gr 22 Light Green

Vobler Owner Shallow Runner 5227 TWO-38SR 38mm 3.5gr 22 Light Green

804020023
Livrare 48-72 ore

101,86Lei

Vobler Owner Rip n Minnow 65mm 6.0gr 16 Cooper scales

Vobler Owner Rip n Minnow 65mm 6.0gr 16 Cooper scales

804020305
Livrare 48-72 ore

49,67Lei

Carlige Owner Iseama With Eye 50188, Nr.3, 6buc/plic

Carlige Owner Iseama With Eye 50188, Nr.3, 6buc/plic

5018803
Livrare imediată!

12,08Lei

Carlige Legate OWNER S363 56915 Nr.12 Fir 0.12mm Rosu

Carlige Legate OWNER S363 56915 Nr.12 Fir 0.12mm Rosu

5691501
Livrare 48-72 ore

13,93Lei

Jig Owner Lestat 56978 Nr.3/0 8.00gr Round Jig Head

Jig Owner Lestat 56978 Nr.3/0 8.00gr Round Jig Head

56978380
Livrare 48-72 ore

32,57Lei

Carlig Owner 5177 No10 Mosquito Red Hook

Carlig Owner 5177 No10 Mosquito Red Hook

5177023
Livrare imediată!

12,08Lei

Rig Feeder Owner 56930 No.14 0.18 FD 02 P.Band

Rig Feeder Owner 56930 No.14 0.18 FD 02 P.Band

5693114
Livrare 48-72 ore

19,14Lei

Afişare 721 - 740 din 1548 (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: 116.982 ms [By time] [By id] [By file]
1 (0.147)
SELECT data
FROM `oc_session`
WHERE session_id = '69cd24f8cae21666c30c368609'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.086)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.127)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Owner'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.119)
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 (64.497)
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 (51.839)
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 720,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.167)
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