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 7240, 10

September 2, 2022

Steve Lenz Jr. Helps bring BibBoard’s Partnerships across the Finish Line

/ENDURANCE SPORTSWIRE/ – As BibBoards continues to grow and partner with endurance events around North America it is important to bring in industry experts to help manage sponsorships and partnerships. BibBoards are the perfect tool for endurance event coordinators to provide added value to their events while factoring in marketing potential....

Business

Cycling

Press Releases

Running

Triathlon

September 2, 2022

Super League Triathlon Announce FORM As Official Swim Goggles Partner

/ENDURANCE SPORTSWIRE/ – Super League Triathlon is the world’s premiere swim-bike-run Series, with its biggest ever Championship Series, featuring short, sharp, and exciting racing formats starring the best athletes in the world, kicking-off in London on Sunday, September 4. FORM is the tech-enabled swim platform with a simple mission: to break down...

Press Releases

Sponsorship

Triathlon

September 1, 2022

Sea to Summit Triathlon moves to Kennebunkport, Maine

/ENDURANCE SPORTSWIRE/ – Maine’s coastal villages of Kennebunkport and Kennebunk will host the swim segment as well as the start of the bike leg for 2023’s Sea to Summit Adventure Triathlon. The announcement was made by the race organizer, New England Endurance Events. For the past decade the point-to-point race has...

Events

Press Releases

Triathlon

September 1, 2022

Red Kite Ride & Bike Club issue commemorative NFT jersey for all participants

/ENDURANCE SPORTSWIRE/ – Red Kite Ride, a UK charity ride benefitting multiple charities, has partnered with Bike Club to issue the first-ever NFT jersey as a participation reward. “We are thrilled to give every participant a timeless digital collectible as a keepsake from our ride this year,” says Kylie Grant, event...

Cycling

Events

Press Releases

Products

September 1, 2022

Lakeshore Athletic Services West Region Expansion

Lakeshore Athletic Services is pleased to announce the move to our new and improved office and warehouse location in Mesa, Arizona. Our new AZ headquarters are located in a brand new construction building, boasting a 1700 square foot office and warehouse facility. Event Equipment & Services Lakeshore Athletic Services has...

Business

Cycling

Press Releases

Products

Running

Triathlon

September 1, 2022

Elite: Iconic Canadian brand Ciele Athletics launches a top-of-the-line collection

MONTREAL (Sep. 1, 2022) /ENDURANCE SPORTSWIRE/ – Ciele Athletics, the high-end performance running brand from Montréal, Québec, is proud to announce the launch of Elite, a new collection for runners who want the very best in quality, comfort and technical innovation. “Elite is a key step in our continued commitment to...

Press Releases

Products

Running

September 1, 2022

CADEX Releases New Film Documenting Kristian Blummenfelt’s Historic Sub7 Triathlon Achievement

/ENDURANCE SPORTSWIRE/ - CADEX, a leading brand of high-performance cycling products, is set to release “Impossibly Fast: Kristian Blummenfelt’s Pursuit of Sub7,” a new film that documents the Norwegian’s journey to becoming the first athlete to complete the full Ironman triathlon distance in less than 7 hours. “The world sees...

Press Releases

Triathlon

September 1, 2022

Showcased

INFINIT Nutrition announces its expansion to the European market

Prague, Czech Republic, September 01, 2022 /ENDURANCE SPORTSWIRE/ – Started in 2003, INFINIT was one of the first companies to establish themselves in the now rapidly growing personalized nutrition space. Their proprietary Osmo-Fit technology gives consumers the ability to create customized hydration and protein ready-to-mix nutritional drinks. After its 18 successful years’...

Business

Cycling

Press Releases

Running

Triathlon

August 31, 2022

Pikes Peak APEX Adds Three New Partners for September Event

Colorado Springs, CO, September 1, 2022 /ENDURANCE SPORTSWIRE/ - Sports Strategies announces three new partners of The Pikes Peak APEX presented by RockShox. REI, Fat Tire and Flow Formulas have all partnered with the APEX to provide an enhanced experience to racers this September 22-25. “We always want to partner...

Cycling

Events

Press Releases

Sponsorship