CPK


BOILIES, CPK, TARE, XXL, 1KG, 16MM, 999202, Boilies Pentru Nadit, Boilies Pentru Nadit CPK, CPK

BOILIES, CPK, TARE, XXL, 1KG, 16MM, 999202, Boilies Pentru Nadit, Boilies Pentru Nadit CPK, CPK

999202
Livrare imediată!

57,00Lei

Micro, Pop-up, CPK, 8mm,, Natural, 999247, Boilies Pop-Up, Boilies Pop-Up CPK, Boilies CPK, Pop-Up CPK, CPK
Boilies CPK pentru carlig XXL Tari 20.24.26mm

Boilies CPK pentru carlig XXL Tari 20.24.26mm

999687
Livrare imediată!

28,00Lei

Fir fluorocarbon CPK 007 Fluorocarbon Hooklink 0.38mm/25m Transparent

Fir fluorocarbon CPK 007 Fluorocarbon Hooklink 0.38mm/25m Transparent

999870
Livrare imediată!

35,00Lei

Vartej CPK Quick Change Swivel Nr10 10buc/plic

Vartej CPK Quick Change Swivel Nr10 10buc/plic

999901
Livrare imediată!

10,00Lei

Aditiv lichid CPK Bagman PVA Next 250ml

Aditiv lichid CPK Bagman PVA Next 250ml

1000167
Livrare imediată!

29,00Lei

Aditiv, lichid, CPK, Bagman, PVA, Special, Fruits, 250ml, 1000186, Aditivi Lichizi / Arome / Dip-uri, Aditivi Lichizi / Arome / Dip-uri CPK, CPK
Boilies, CPK,, Tigernuts,, 20mm,, 3kg, 1000959, Boilies pentru Nadit, Boilies pentru Nadit CPK, Boilies CPK, pentru CPK, Nadit CPK, CPK
Pelete CPK XXL, 800g

Pelete CPK XXL, 800g

999063
Livrare imediată!

24,00Lei

CARLIGE, CPK, SUPERCAMO, WIDE, GAPE, NR, 4, 10BUC, 999731, Carlige Crap, Carlige Crap CPK, CPK

CARLIGE, CPK, SUPERCAMO, WIDE, GAPE, NR, 4, 10BUC, 999731, Carlige Crap, Carlige Crap CPK, CPK

999731
Livrare imediată!

11,00Lei

Boilies CPK High Attract Sweetcorn Tari 16mm 800g

Boilies CPK High Attract Sweetcorn Tari 16mm 800g

999536
Livrare imediată!

25,00Lei

PELETE DE CARLIG FLOTANTE CPK KRILL FEEDER 6MM 25G

PELETE DE CARLIG FLOTANTE CPK KRILL FEEDER 6MM 25G

999854
Livrare imediată!

20,00Lei

Fir Monoflament CPK Glow Supercast 1000m, 0.37mm, 11.50kg

Fir Monoflament CPK Glow Supercast 1000m, 0.37mm, 11.50kg

999956
Livrare imediată!

80,00Lei

Fir Textil 007 CPK SILKY NATURAL Hooklink 0.20 MM 22 lb/ 9.9 kg BROWN

Fir Textil 007 CPK SILKY NATURAL Hooklink 0.20 MM 22 lb/ 9.9 kg BROWN

999963
Livrare imediată!

29,00Lei

Aditiv lichid CPK Aroma Concentrata Capsuna 100ml

Aditiv lichid CPK Aroma Concentrata Capsuna 100ml

1000616
Livrare imediată!

10,00Lei

Pop-Up CPK Washed and Fluo Bayou Koi Squid 12mm, 28g

Pop-Up CPK Washed and Fluo Bayou Koi Squid 12mm, 28g

1000642
Livrare imediată!

25,00Lei

Groundbait, CPK, Clasic, Catcher, Squid,, 1kg, 999749, Nada (Groundbait), Nada (Groundbait) CPK, CPK

Groundbait, CPK, Clasic, Catcher, Squid,, 1kg, 999749, Nada (Groundbait), Nada (Groundbait) CPK, CPK

999749
Livrare imediată!

10,00Lei

GROUNDBAIT CPK AMUR 1KG

GROUNDBAIT CPK AMUR 1KG

999231
Livrare imediată!

10,00Lei

BOILIES CPK TARE SWEETCORN 800gr 20 MM

BOILIES CPK TARE SWEETCORN 800gr 20 MM

999539
Livrare imediată!

25,00Lei

PORUMB FLOTANT CPK CAPSUNA SI BANANAN

PORUMB FLOTANT CPK CAPSUNA SI BANANAN

999668
Livrare imediată!

15,00Lei

Afişare 201 - 220 din 451 (23 pagini)
Queries: 7, Total time: 64.222 ms [By time] [By id] [By file]
1 (0.088)
SELECT data
FROM `oc_session`
WHERE session_id = '84566e477999fa366a81c021a3'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.130)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.153)
SELECT *
FROM oc_url_alias
WHERE keyword = 'CPK'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.113)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '100' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (28.712)
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 = '0' AND p.manufacturer_id = '100'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (34.923)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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 = '0' AND p.manufacturer_id = '100' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 200,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.103)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38