select * from itak_zaloga where id_product_attribute = 78854 Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 1 [quantity] => 0 [last_update] => 2019-12-14 16:33:10 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 3 [quantity] => 0 [last_update] => 2019-12-14 16:33:42 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 4 [quantity] => 0 [last_update] => 2019-12-14 16:34:22 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 5 [quantity] => 0 [last_update] => 2019-12-14 16:35:07 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 7 [quantity] => 0 [last_update] => 2019-12-14 16:35:33 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 26 [quantity] => 0 [last_update] => 2019-12-14 16:36:03 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 62 [quantity] => 0 [last_update] => 2019-12-14 16:36:47 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 105 [quantity] => 0 [last_update] => 2019-12-14 16:37:28 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 106 [quantity] => 0 [last_update] => 2019-12-14 16:37:49 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 107 [quantity] => 0 [last_update] => 2019-12-14 16:38:26 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 108 [quantity] => 0 [last_update] => 2019-12-14 16:38:59 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 109 [quantity] => 0 [last_update] => 2019-12-14 16:39:32 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 110 [quantity] => 0 [last_update] => 2019-12-14 16:40:01 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 111 [quantity] => 0 [last_update] => 2019-12-14 16:40:36 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 112 [quantity] => 0 [last_update] => 2019-12-14 16:41:03 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 113 [quantity] => 0 [last_update] => 2019-12-14 16:41:30 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 114 [quantity] => 0 [last_update] => 2019-12-14 16:42:01 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 115 [quantity] => 0 [last_update] => 2019-12-14 16:42:41 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 116 [quantity] => 0 [last_update] => 2019-12-14 16:43:05 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 117 [quantity] => 0 [last_update] => 2019-12-14 16:43:23 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 118 [quantity] => 0 [last_update] => 2019-12-14 16:43:44 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 119 [quantity] => 0 [last_update] => 2019-12-14 16:44:21 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 120 [quantity] => 0 [last_update] => 2019-12-14 16:44:40 ) select * from itak_zaloga where id_product_attribute = 78854 Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 1 [quantity] => 0 [last_update] => 2019-12-14 16:33:10 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 3 [quantity] => 0 [last_update] => 2019-12-14 16:33:42 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 4 [quantity] => 0 [last_update] => 2019-12-14 16:34:22 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 5 [quantity] => 0 [last_update] => 2019-12-14 16:35:07 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 7 [quantity] => 0 [last_update] => 2019-12-14 16:35:33 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 26 [quantity] => 0 [last_update] => 2019-12-14 16:36:03 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 62 [quantity] => 0 [last_update] => 2019-12-14 16:36:47 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 105 [quantity] => 0 [last_update] => 2019-12-14 16:37:28 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 106 [quantity] => 0 [last_update] => 2019-12-14 16:37:49 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 107 [quantity] => 0 [last_update] => 2019-12-14 16:38:26 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 108 [quantity] => 0 [last_update] => 2019-12-14 16:38:59 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 109 [quantity] => 0 [last_update] => 2019-12-14 16:39:32 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 110 [quantity] => 0 [last_update] => 2019-12-14 16:40:01 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 111 [quantity] => 0 [last_update] => 2019-12-14 16:40:36 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 112 [quantity] => 0 [last_update] => 2019-12-14 16:41:03 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 113 [quantity] => 0 [last_update] => 2019-12-14 16:41:30 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 114 [quantity] => 0 [last_update] => 2019-12-14 16:42:01 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 115 [quantity] => 0 [last_update] => 2019-12-14 16:42:41 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 116 [quantity] => 0 [last_update] => 2019-12-14 16:43:05 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 117 [quantity] => 0 [last_update] => 2019-12-14 16:43:23 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 118 [quantity] => 0 [last_update] => 2019-12-14 16:43:44 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 119 [quantity] => 0 [last_update] => 2019-12-14 16:44:21 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 120 [quantity] => 0 [last_update] => 2019-12-14 16:44:40 ) select * from itak_zaloga where id_product_attribute = 78854 Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 1 [quantity] => 0 [last_update] => 2019-12-14 16:33:10 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 3 [quantity] => 0 [last_update] => 2019-12-14 16:33:42 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 4 [quantity] => 0 [last_update] => 2019-12-14 16:34:22 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 5 [quantity] => 0 [last_update] => 2019-12-14 16:35:07 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 7 [quantity] => 0 [last_update] => 2019-12-14 16:35:33 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 26 [quantity] => 0 [last_update] => 2019-12-14 16:36:03 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 62 [quantity] => 0 [last_update] => 2019-12-14 16:36:47 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 105 [quantity] => 0 [last_update] => 2019-12-14 16:37:28 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 106 [quantity] => 0 [last_update] => 2019-12-14 16:37:49 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 107 [quantity] => 0 [last_update] => 2019-12-14 16:38:26 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 108 [quantity] => 0 [last_update] => 2019-12-14 16:38:59 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 109 [quantity] => 0 [last_update] => 2019-12-14 16:39:32 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 110 [quantity] => 0 [last_update] => 2019-12-14 16:40:01 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 111 [quantity] => 0 [last_update] => 2019-12-14 16:40:36 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 112 [quantity] => 0 [last_update] => 2019-12-14 16:41:03 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 113 [quantity] => 0 [last_update] => 2019-12-14 16:41:30 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 114 [quantity] => 0 [last_update] => 2019-12-14 16:42:01 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 115 [quantity] => 0 [last_update] => 2019-12-14 16:42:41 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 116 [quantity] => 0 [last_update] => 2019-12-14 16:43:05 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 117 [quantity] => 0 [last_update] => 2019-12-14 16:43:23 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 118 [quantity] => 0 [last_update] => 2019-12-14 16:43:44 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 119 [quantity] => 0 [last_update] => 2019-12-14 16:44:21 ) Array ( [id_product] => 48340 [id_product_attribute] => 78854 [warehouse] => 120 [quantity] => 0 [last_update] => 2019-12-14 16:44:40 ) Warrior Dynasty HD3 composite hockey stick - Junior
  • Reduced price

Warrior Dynasty HD3 composite hockey stick - Junior

€71.94
€119.90
-40%
Quantity
Check stock
Visa

Warrior Dynasty HD3 composite hockey stick - Junior

  • HyperDrive Engineered Kick-Zone unleashes your power with an easy flexing mid-kick point that turns out high velocity slap shots and one timers
  • With True1 Construction we create a stick with the right weight, best balance and feel
  • Strong Arm Taper geometry is wide and resists torque to improve power transfer and accuracy when firing slap shots and one timers
  • ProTex Grip offers a textured surface coupled with a tacky soft grip feel that locks your hands in place for optimum drive and control
HD350G5
026585503279

Models in stock

Flex Model Direction Stock Delivery time
50 Flex P92 / W03 / Backstrom / P29 / PP26 / E3 / TC2 Right Deliverable 5-10 working days

Check availability for this product



Cancel