Gold Star


Opritoare Gold Star Boilies Siliconice In Rama 99buc

Opritoare Gold Star Boilies Siliconice In Rama 99buc

79630035
Livrare imediată!

4,46Lei

Aparat Goldstar Pentru Legat Carlige GS

Aparat Goldstar Pentru Legat Carlige GS

49650999
Livrare imediată!

9,14Lei

PILKER GOLDSTAR ECO 40G ALBASTRU/ARGINT

PILKER GOLDSTAR ECO 40G ALBASTRU/ARGINT

84305140
Livrare 24-48 ore

11,07Lei

Vobler GoldStar Shad culoare 3

Vobler GoldStar Shad culoare 3

87245903
Livrare imediată!

10,06Lei

Inel Gold Star Lansete 2 picioare WCG : 20

Inel Gold Star Lansete 2 picioare WCG : 20

81010020
Livrare imediată!

9,53Lei

VARGA GOLD STAR VIKING 2MT FIBRA DE STICLA

VARGA GOLD STAR VIKING 2MT FIBRA DE STICLA

11001200
Livrare 24-48 ore

21,24Lei

Vobler GoldStar Perch 2 Culoare 18 4cm

Vobler GoldStar Perch 2 Culoare 18 4cm

87225418
Livrare imediată!

10,06Lei

Inel Gold Star Cu Bucsa (Ceramica Fluo) 29.0mm

Inel Gold Star Cu Bucsa (Ceramica Fluo) 29.0mm

81001290
Livrare 24-48 ore

10,06Lei

Vobler GoldStar Popp culoare 6 5cm

Vobler GoldStar Popp culoare 6 5cm

87210506
Livrare imediată!

10,06Lei

ROD POD GOLD STAR BASIC

ROD POD GOLD STAR BASIC

77100205
Livrare 24-48 ore

121,90Lei

MINCIOG GOLDSTAR PENTRU COPII ROTUND

MINCIOG GOLDSTAR PENTRU COPII ROTUND

71000004
Livrare 24-48 ore

23,27Lei

PILKER GOLDSTAR ECO 15G PORTOCALIU/GALBEN

PILKER GOLDSTAR ECO 15G PORTOCALIU/GALBEN

84305415
Livrare 24-48 ore

8,02Lei

Vobler GoldStar Fat Shad culoare 9 9cm

Vobler GoldStar Fat Shad culoare 9 9cm

87250909
Livrare imediată!

10,06Lei

Inel EnergoTeam Lansete 2 picioare SEG : 20

Inel EnergoTeam Lansete 2 picioare SEG : 20

81011020
Livrare 24-48 ore

10,56Lei

Varga GoldStar Viking 5m

Varga GoldStar Viking 5m

11001500
Livrare 24-48 ore

53,87Lei

Vobler GoldStar Fat culoare 5 6cm

Vobler GoldStar Fat culoare 5 6cm

87240605
Livrare 24-48 ore

10,06Lei

Inel Gold Star Cu Bucsa (Ceramica Fluo) 34.0mm

Inel Gold Star Cu Bucsa (Ceramica Fluo) 34.0mm

81001340
Livrare 24-48 ore

10,56Lei

Opritor Dublu GoldStar Negru/Galben M

Opritor Dublu GoldStar Negru/Galben M

79006402
Livrare imediată!

2,53Lei

Vobler GoldStar Perch 1 Culoare 18 3cm

Vobler GoldStar Perch 1 Culoare 18 3cm

87225318
Livrare imediată!

10,06Lei

Set Plumbi Despicati Match 100g

Set Plumbi Despicati Match 100g

54132100
Livrare 24-48 ore

13,10Lei

Afişare 1 - 20 din 104 (6 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: 44.599 ms [By time] [By id] [By file]
1 (0.121)
SELECT data
FROM `oc_session`
WHERE session_id = '6bd4109bcad2b1a44d424800e5'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.169)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.157)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Gold-Star'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.139)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '39' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (20.972)
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 = '39'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (22.926)
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 = '39' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.115)
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