MTN OPS Enduro - Non-Caffeinated Cardio Enhancement, 30 Scoops
|SQL||SELECT DISTINCT a.style_id, max(CASE WHEN m.description IS NULL OR RTRIM(LTRIM(m.description)) = '' THEN a.web_desc ELSE m.description END) as realname, sum(c.qoh+c.qc) as overallqoh, max(a.picture_id) as picture_id, max(a.of8) as of8, max(b.sku_id) as sku_id, max(b.sku_of7) as sku_of7, max(b.scale_entry_id) as scaleid, max(b.attr2_entry_id) as attr2id, max(b.attr1_entry_id) as attr1id, max(a.style) as style, max(r.package_id) as usepackage, max(a.web_style) as webStyle, max(m.capacity) as capacity, max(m.webstyle_sort) as webstyle_sort, max(a.NON_INVT) as NON_INVT FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id AND NOT (c.qoh < 1 AND a.of8 in (?,?,?,?,?,?,?,?)) AND NOT (c.qoh < 1 AND a.of8='INACTIVE') AND c.store_id in(?,?,?) ) LEFT JOIN web_product_information m WITH (NOLOCK) ON (a.style_id = m.style_id) LEFT JOIN dbo.tb_inet_names f WITH (NOLOCK) on (f.orig_text = a.brand and f.field_name='BRAND') LEFT JOIN tb_package r WITH (NOLOCK) on (r.sku_id=b.sku_id) INNER JOIN web_all_products wb WITH (NOLOCK) ON (wb.style_id = a.style_id) WHERE a.web_style = ? AND (upper(f.web_text) = ? or upper(f.orig_text) = ? or upper(a.brand) = ?) GROUP BY a.style_id,a.of8 HAVING (sum(c.qoh+c.qc) > 0 OR a.of8='STK') ORDER BY max(m.webstyle_sort), a.style_id|
ENDURO™ works in concert with your body’s cardiovascular system to increase hydration, performance, and endurance during intense physical activity. Enduro™ is a non-stimulated, non-caffeinated energy booster designed with two special ingredients, L-Arginine & L-Citrulline, which help increase blood flow and oxygen to the muscles and cells of the body. The black pepper extract and bio protected blend in Enduro™ help maintain absorption of nutrients to the body and improve circulation and blood flow to the body. If you’re looking for a non-caffeinated, non-stimulated pick me up that’s health and safe for daily use, ENDURO is the answer.
- Increased Blood Flow (20+ Hours of Nitric Oxide Boost)
- Cardiovascular Endurance
- Caffeine Free Natural Energy
- Daily Wellness
- Amazing Taste
SERVING SIZE: 10 grams (1 level scoop)
SERVINGS PER TUB: 30
USAGE: Mix 1 serving (1 scoop) of MTN OPS ENDURO™ in 8-12 oz of water. Take up to twice per day. Best used as a non caffeinated natural energy boost and endurance product. Great as a caffeine free pre workout, cardiovascular boost for long distance/endurance athletes and oxygen boost during strenuous activities. MTN OPS ENDURO™ has many great cardiovascular health benefits for those with High Blood Pressure and Neuropathy Pain and Numbness.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review