Cresta


MOMITOR CRESTA PELLET FEEDER 35GR

MOMITOR CRESTA PELLET FEEDER 35GR

004722-00123-00000
Livrare imediată!

18,17Lei

Penar Cresta Modular Feeder Hooklength System 15cm -23%

Penar Cresta Modular Feeder Hooklength System 15cm

004724-00700-00000
Livrare imediată!

93,00Lei(-23%) 71,15Lei

Cutie pentru Momeala Cresta Baitbox Holed, 0.60l

Cutie pentru Momeala Cresta Baitbox Holed, 0.60l

006403-00302-00000
Livrare imediată!

16,86Lei

VARTEJ RAPID CRESTA FEEDER NR 20 7BUC

VARTEJ RAPID CRESTA FEEDER NR 20 7BUC

004723-00121-00000
Livrare imediată!

13,92Lei

CRESTA METHOD FEEDER 35 GR ELASTIC -15%

CRESTA METHOD FEEDER 35 GR ELASTIC

004722-00114-00000
Livrare imediată!

18,90Lei(-15%) 16,15Lei

CRESTA FEEDER SWIVELS SAFE-BEAD NR. 12 8BUC

CRESTA FEEDER SWIVELS SAFE-BEAD NR. 12 8BUC

004723-00162-00000
Livrare imediată!

11,68Lei

COSULET CRESTA SPEED FEEDERS S 20 GR 1BUC

COSULET CRESTA SPEED FEEDERS S 20 GR 1BUC

004020-00220-00000
Livrare imediată!

10,85Lei

COSULET CRESTA CAGE M 3X3CM 30 GR 1 BUC PLIC

COSULET CRESTA CAGE M 3X3CM 30 GR 1 BUC PLIC

004020-00530-00000
Livrare imediată!

10,66Lei

MONTURA CRESTA FEEDER LOOPED 06 2BUC 35CM

MONTURA CRESTA FEEDER LOOPED 06 2BUC 35CM

004720-00600-00000
Livrare imediată!

19,81Lei

Sita Cresta Riddle Square Mesh 2mm

Sita Cresta Riddle Square Mesh 2mm

006403-00106-00000
Livrare imediată!

112,84Lei

STOPPER CRESTA FEEDER

STOPPER CRESTA FEEDER

004722-00010-00000
Livrare 48-72 ore

11,88Lei

ELASTIC RUBENSIANA SOLID CRESTA 1.2 MM 6M

ELASTIC RUBENSIANA SOLID CRESTA 1.2 MM 6M

004724-00304-00000
Livrare imediată!

18,90Lei

PELLETE CRESTA ARTICIFCIALE YELLOW 39 BUC

PELLETE CRESTA ARTICIFCIALE YELLOW 39 BUC

004714-00604-00000
Livrare imediată!

10,15Lei

MULINETA CRESTA FEEDER SNYPER 6000

MULINETA CRESTA FEEDER SNYPER 6000

001312-01600-00000
Livrare 48-72 ore

262,32Lei

CRESTA METHOD FEEDER 22 GR ELASTIC

CRESTA METHOD FEEDER 22 GR ELASTIC

004722-00111-00000
Livrare imediată!

18,79Lei

Cosulet Feeder Cresta Accelerate Block Large 60g

Cosulet Feeder Cresta Accelerate Block Large 60g

004021-00360-00000
Livrare imediată!

19,30Lei

MOMITOR CRESTA PELLET FEEDER 42GR -19%

MOMITOR CRESTA PELLET FEEDER 42GR

004722-00124-00000
Livrare imediată!

17,50Lei(-19%) 14,21Lei

MASUTA LATERALA CRESTA PT SCAUN FEEDER 49.5X38.5CM

MASUTA LATERALA CRESTA PT SCAUN FEEDER 49.5X38.5CM

003902-00300-00000
Livrare imediată!

215,55Lei

Sita pentru Momeala Cresta Baitstrainer

Sita pentru Momeala Cresta Baitstrainer

006403-00304-00000
Livrare 48-72 ore

38,62Lei

VARTEJ RAPID CRESTA FEEDER NR 18 7BUC

VARTEJ RAPID CRESTA FEEDER NR 18 7BUC

004723-00122-00000
Livrare imediată!

11,68Lei

Afişare 61 - 80 din 98 (5 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: 41.691 ms [By time] [By id] [By file]
1 (0.170)
SELECT data
FROM `oc_session`
WHERE session_id = '73ba3d37622d04d7703c08edbb'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.116)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.145)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cresta'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.140)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '324' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (19.866)
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 = '324'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (21.106)
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 = '324' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 60,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.148)
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