SELECT SQL_CALC_FOUND_ROWS  wp_posts.*, IF(wppm.meta_value= 1, 'YES', NULL) as showcased
					 FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta as wppm ON (wp_posts.ID = wppm.post_id AND wppm.meta_key = 'promoted')
					 WHERE 1=1  AND ( 
  wp_term_relationships.term_taxonomy_id IN (8742)
) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) AND wp_posts.ID NOT IN ( SELECT ID FROM wp_posts WHERE post_type IN ('post','page','attachment','job_listing','podcasts','industry-news','product','business-directory','testimonial') AND ID IN ( SELECT post_id FROM wp_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value NOT IN (0) AND pm.meta_value IN ( SELECT group_id FROM wp_groups_group ) AND post_id NOT IN ( SELECT post_id FROM wp_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value IN (0) ) ) )  AND wp_posts.ID IN  (    SELECT ID FROM wp_posts WHERE ID NOT IN ( SELECT post_id FROM wp_postmeta WHERE wp_postmeta.meta_key = 'groups-groups_read_post' )    UNION ALL    SELECT post_id AS ID FROM wp_postmeta WHERE wp_postmeta.meta_key = 'groups-groups_read_post' AND wp_postmeta.meta_value IN ('')  ) 
					 GROUP BY wp_posts.ID
					 ORDER BY wp_posts.menu_order,  wp_posts.menu_order, wp_posts.post_date DESC
					 LIMIT 4390, 10

March 2, 2023

Pickle Juice Brings Functional Heat with New Chili Lime Shot

MESQUITE, TX (March 2, 2023) /ENDURANCE SPORTSWIRE/ – Pickle Juice, pioneers in providing scientifically proven methods to prevent muscle cramps and dehydration, is excited to announce the release of Chili Lime as the latest innovation of their 2.5oz Extra Strength Pickle Juice shot. Pickle Juice believes in providing natural and healthy...

Press Releases

Products

March 2, 2023

2022 IRONMAN 70.3 Athlete Choice Awards Announced for North American Region

TAMPA, Fla. (Mar. 2, 2023) /ENDURANCE SPORTSWIRE/ – IRONMAN today announced the North American regional results for the 2022 IRONMAN 70.3 Athlete Choice Awards, highlighting the highest-scoring events in a variety of categories based solely on athlete surveys from all the 2022 IRONMAN® 70.3 races across North America. Out of the all the...

Awards

Press Releases

Triathlon

March 2, 2023

Miami Nights Cycling Club Announces 2023 Race Schedule and Team Sponsors

Miami, Florida – March 2, 2023 /ENDURANCE SPORTSWIRE/ – The Miami Nights Professional Cycling Team, one of the premier professional teams in the National Cycling League, today announced their 2023 competition schedule and the list of world-class sponsors supporting their bid to win the $1 Million NCL prize purse, the largest in...

Cycling

Press Releases

Sponsorship

March 2, 2023

LA Sweat and Vittoria Tires announce continued multi-year partnership

/ENDURANCE SPORTSWIRE/ – We are proud to announce our continued partnership between LA Sweat Racing and Vittoria Tires. LA Sweat Racing is a professional women’s cycling team that competes in the US National Calendar. Vittoria Tires is a world-renowned tire manufacturer, known for its quality and performance. “Vittoria is proud to...

Cycling

Press Releases

Sponsorship

March 2, 2023

5th GFNY Monterrey this Sunday

/ENDURANCE SPORTSWIRE/ – This Sunday, GFNY Monterrey opens the jam packed 2023 GFNY Mexico season. Riders get to compete on a 137km course with an elevation gain of 1386m and a hilltop finish on iconic Chipinque. Start and finish will be at Macroplaza which true to its name is the world's...

Cycling

Events

Press Releases

March 1, 2023

Cannondale’s New SuperSix EVO is the Ultimate Evolution of the Modern Road Race Machine

Wilton, Conn. – March 1, 2023 /ENDURANCE SPORTSWIRE/ - Today, Cannondale ushers in a whole new era of speed, with the launch of the completely evolved SuperSix EVO road racing bike. “We’ve redesigned the SuperSix EVO to be faster everywhere,” says Sam Ebert, Cannondale Road Bike Product Manager. “When we...

Press Releases

Products

March 1, 2023

Boost Performance with Essential Elements’ New T-Hero Supplement

Los Angeles, CA (March 1, 2023) /ENDURANCE SPORTSWIRE/ - Essential Elements Nutrition (Ee)-the premium, affordable and science-backed sports nutrition brand-is changing the way testosterone supplements boost performance, health, and more. Meet T-Hero, Essential Elements’ cutting-edge supplement for comprehensive male health support. Essential Elements® T-Hero is engineered with a purpose–to boost...

Press Releases

Products

March 1, 2023

IRONMAN Announces 2023 IRONMAN and IRONMAN 70.3 Broadcast Schedule

TAMPA, Fla. (March 1, 2023) /ENDURANCE SPORTSWIRE/ – IRONMAN announced today its broadcast schedule for the 2023 season. The 2023 full-distance IRONMAN® triathlon broadcast schedule will feature 12 stops around the globe including both the men’s and women’s 2023 VinFast IRONMAN World Championship, which will be available on IRONMAN.com/LIVE, and IRONMAN...

Events

Press Releases

Triathlon