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

May 9, 2023

Limited Early Bird tickets released for Snowbound Expo 2023

/ENDURANCE SPORTSWIRE/ – The 2023 Expo will take place at the new location, Boston Convention & Exhibition Center (BCEC) and will be held earlier in the year, November 3-5, 2023 and will play host to over 120 brands, and a speaker series packed with professional athletes and influential members of the...

Press Releases

Trade Shows

May 9, 2023

Puerto Princesa to Host The IRONMAN 70.3 Asia Triclub & Relay Championship this November

PUERTO PRINCESA, Philippines / TAMPA, Fla. (May 9, 2023)/ENDURANCE SPORTSWIRE/ – IRONMAN today announced that the IRONMAN® 70.3® Puerto Princesa triathlon taking place on November 12, 2023, will be designated as the 2023 Asia TriClub and Relay Championship for 2023. Puerto Princesa joins the 2023 Global IRONMAN TriClub Championship Series as...

Events

Press Releases

Triathlon

May 9, 2023

UltraSignup Announces Inaugural Event Series: the Dirt Circus

May, 2023 – Nashville, TN/ENDURANCE SPORTSWIRE/ – UltraSignup, the world's leading online registration platform for trail and ultra-running events, is excited to announce its first event series, The Dirt Circus. This exciting new event series is designed to bring the trail running community together in six different cities across the United...

Events

Press Releases

Running

May 9, 2023

Emerging Brand KINeSYS Sunscreen invited to Runchella 2023

/ENDURANCE SPORTSWIRE/ – KINeSYS Performance Sunscreen is honoured to be invited to Runchella 2023, the Running Industry Association’s membership summit, as an emerging brand. Runchella is being held in Chicago from 8 - 11 May and combines educational programming, collaborations and brand presentations. It is open to RIA members only. Lisa and...

Press Releases

Products

Running

Trade Shows

May 9, 2023

Showcased

New Book, Ultrarunning Europe, Guides Runners Through the Continent’s Most Scenic Trails

Columbus, OH, May 9, 2023/ENDURANCE SPORTSWIRE/ – Ultrarunning enthusiasts, adventure seekers, and nature lovers now have the ultimate guide to exploring Europe's most stunning trail running destinations with the release of Ultrarunning Europe. Written by seasoned ultrarunner and adventurer Luke Tuttle, this comprehensive guidebook offers readers a unique and detailed look...

Press Releases

Products

Running

May 9, 2023

Sports And Hollywood Stars Join Forces to Crush Cancer at The 11th Annual Tour De Pier

LOS ANGELES, Calif., May 9, 2023 – The 11th Annual Tour de Pier, a unique outdoor stationary cycling fundraiser is pleased to announce its star-studded lineup. The award-winning fitness fundraiser for Outstanding Special Event welcomes sports and Hollywood stars in helping create awareness about advancing cancer research. Celebrities scheduled to...

Business

Cycling

Events

Giving

Press Releases

May 9, 2023

MOTTIV Announces Free Version of their App with new a Basic Plan

/ENDURANCE SPORTSWIRE/ – MOTTIV, an athlete-run company dedicated to ensuring endurance sports and the transformations they bring are accessible to everyone has announced it now has a free price tier of their training app. Research has shown that while 30 percent of endurance athletes work with a coach, 60 percent...

Cycling

Press Releases

Products

Running

SWW Syndication

Triathlon

May 9, 2023

Vittoria’s NEW Corsa PRO: Feel What the Pros Feel

/ENDURANCE SPORTSWIRE/ – Compared to the previous Tour-winner version, Corsa PRO tubeless-ready clincher and tubular offer increased speed, wet & cornering grip, puncture resistance and comfort. Corsa PRO uses Vittoria latest developed graphene & silica compound, and a new electrical vulcanization process, allowing a seamless application of the tread to the...

Cycling

Press Releases

Products

May 9, 2023

The Championship 2023 Confirms Final World-Class Field

/ENDURANCE SPORTSWIRE/ – With less than two weeks to go until Challenge Family’s flagship event, The Championship, a world-class 70-strong professional field has been confirmed, including the sport’s newest World Triathlon Long Distance World Champions, Clément Mignon and Marjolaine Pierré. Taking place at the x-bionic® sphere Olympic training venue in Šamorín,...

Events

Press Releases

Triathlon