CPK


Carlige CPK Force Krank Nr.4

Carlige CPK Force Krank Nr.4

1000101
Livrare imediată!

11,00Lei

Boilies OLD SCHOOL CRAB & PRUNA 24 mm 5 kg

Boilies OLD SCHOOL CRAB & PRUNA 24 mm 5 kg

1000692
Livrare imediată!

190,00Lei

Pop, Up, CPK, 3D, Dumbell,, Krill,, 10mm,, 25g, 1000146, Boilies Pop-Up, Boilies Pop-Up CPK, CPK

Pop, Up, CPK, 3D, Dumbell,, Krill,, 10mm,, 25g, 1000146, Boilies Pop-Up, Boilies Pop-Up CPK, CPK

1000146
Livrare imediată!

20,00Lei

Carlige CPK C3 Feeder Hooks, Nr.14, 10buc/pac

Carlige CPK C3 Feeder Hooks, Nr.14, 10buc/pac

1000091
Livrare imediată!

11,00Lei

BLUZA CPK CU PROTECTIE UV Marime XXXL

BLUZA CPK CU PROTECTIE UV Marime XXXL

1000175
Livrare imediată!

115,00Lei

Pelete, Flotante, CPK, Feeder, Glow, in, the, Dark,, Capsuna,, 6mm,, 15g, 1000832, Boilies Pop-Up, Boilies Pop-Up CPK, Boilies CPK, Pop-Up CPK, CPK
Amestec CPK Pva Bag Man, Tigernut, 800g

Amestec CPK Pva Bag Man, Tigernut, 800g

1000941
Livrare imediată!

25,00Lei

Nada, CPK, Method, Feeder, Supreme, Black, Supreme, 900g, 1000147, Nada (Groundbait), Nada (Groundbait) CPK, CPK
Nada CPK Bagman Sticky Mix Sweet 800g

Nada CPK Bagman Sticky Mix Sweet 800g

1000606
Livrare imediată!

25,00Lei

, BLUZA, CPK, CU, PROTECTIE, UV, Camo, , , Marime, , XL, 1000652, Bluze UV, Bluze UV CPK, CPK

, BLUZA, CPK, CU, PROTECTIE, UV, Camo, , , Marime, , XL, 1000652, Bluze UV, Bluze UV CPK, CPK

1000652
Livrare imediată!

130,00Lei

Boilies, Tare, de, Carlig, CPK, Fluoroattract, +, Crab, &, Pruna,, Marime, S,, 16/20mm, 1000765, Boiliesuri Tari, Boiliesuri Tari CPK, Boiliesuri CPK, Tari CPK, CPK
Boilies Tare de Carlig CPK Fluoroattract + Feeder Special Fruits, Marime S, 10/14mm

Boilies Tare de Carlig CPK Fluoroattract + Feeder Special Fruits, Marime S, 10/14mm

1000766
Livrare imediată!

18,00Lei

Pop-up CPK Premium Competition, Monster Crab, 10mm, 35g

Pop-up CPK Premium Competition, Monster Crab, 10mm, 35g

1000926
Livrare imediată!

28,00Lei

POP, UP, 3D, CPK, DUMBELL, , Capsuna&Usturoi, 10MM, 1000142, Boilies Pop-Up, Boilies Pop-Up CPK, CPK

POP, UP, 3D, CPK, DUMBELL, , Capsuna&Usturoi, 10MM, 1000142, Boilies Pop-Up, Boilies Pop-Up CPK, CPK

1000142
Livrare imediată!

18,00Lei

Boilies, De, Carlig, Cpk, Fluroattract, Feeder,, Usturoi,, 10&14mm, 1000770, Pelete de Carlig, Pelete de Carlig CPK, Pelete CPK, Carlig CPK, CPK
Wafters CPK Glow In The Dark Critic Echilibrate UV, Usturoi, 8x10mm

Wafters CPK Glow In The Dark Critic Echilibrate UV, Usturoi, 8x10mm

1000828
Livrare imediată!

30,00Lei

Boilies, de, Carlig, Critic, Echilibrat, CPK, Bagman, Split,, Red, Fruits,, 10/14mm, 1000190, Critic Echilibrate / Wafters, Critic Echilibrate / Wafters CPK, CPK
Carlige CPK Force Mugga Nr.2

Carlige CPK Force Mugga Nr.2

1000097
Livrare imediată!

11,00Lei

Nada, CPK, 50/50, FEEDER, GROUNDBAIT, BIG, CARP, 1000676, Nada (Groundbait), Nada (Groundbait) CPK, CPK
Croseta CPK Splicing Needle

Croseta CPK Splicing Needle

1000719
Livrare imediată!

16,01Lei

Afişare 1 - 20 din 451 (23 pagini)
Queries: 9, Total time: 84.299 ms [By time] [By id] [By file]
1 (0.104)
SELECT data
FROM `oc_session`
WHERE session_id = 'e9a2a13f986b9c5207e96a2311'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.104)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.128)
SELECT *
FROM oc_url_alias
WHERE keyword = 'CPK'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.084)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (32.440)
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 = '2' AND p.manufacturer_id = '100'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1661
7 (51.038)
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 = '2' AND p.manufacturer_id = '100' 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:438
8 (0.154)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.136)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38