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 (16)
) 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 550, 10

October 30, 2024

Chargel Finishes 2024 On-Site Samplings with Bi-Coastal Events in New York and Southern California

IRVINE, Calif. (October 30, 2024) /ENDURANCE SPORTSWIRE/ — Chargel®, a first-of-its-kind, delicious Gel Drink that delivers convenient and delightfully unexpected instant pre-workout energy before any workout with zero caffeine, today, announced its November competitive event station lineup. Chargel will round out its 2024 sampling events by showcasing its half drink,...

Cycling

Events

Newswire Syndication

Press Releases

Running

Sponsorship

October 30, 2024

Showcased

San Francisco Marathon Shatters Fundraising Records by Over 40% with GoFundraise Partnership

/ENDURANCE SPORTSWIRE/ - The San Francisco Marathon is an open charity event, welcoming any charity to join. This year, the marathon, in partnership with GoFundraise, is proud to announce a record-breaking fundraising year. They reached a new milestone, raising over $128,000 for local charities, exceeding their goal by 28%. Surpassing...

Events

Giving

Press Releases

Running

October 30, 2024

Marten Van Riel Leads Men’s Start List For First Dubai T100 Triathlon World Championship Final

/ENDURANCE SPORTSWIRE/ - The two-time T100 winner is currently top of the T100 series standings following wins in San Francisco and Ibiza, along with a second place in Lake Las Vegas, and goes into the season finale needing to finish in any top three spot to be crowned the first...

Events

Press Releases

Triathlon

October 30, 2024

XTERRA Zhangjiajie Wulingyuan Trail Run in “Avatar Mountains” Award Zhu & Cheng in Marathon, Wu & Stuck in Half Marathon

XTERRA Zhangjiajie Wulingyuan Trail Run in “Avatar Mountains” Award Zhu & Cheng in Marathon, Wu & Stuck in Half Marathon ZHANGJIAJIE, CHINA /ENDURANCE SPORTSWIRE/ — The XTERRA Trail Run World Series made its landmark debut in the iconic landscapes of Zhangjiajie’s Wulingyuan Scenic Area, welcoming 2,000 athletes from 27 countries...

Events

Press Releases

Running

October 29, 2024

14 Athletes Take the Title in Their Age Group At The 2024 Men’s Vinfast IRONMAN World Championship In Kailua-Kona, Hawai’i

Images of the Age Group 2024 VinFast IRONMAN World Champions and a race B-Roll package are available here: IMAGES (Credit: FinisherPix) KAILUA-KONA, Hawai`i (Oct. 28, 2024) /ENDURANCE SPORTSWIRE/ - The best male long-distance triathletes in the world from 14 age groups claimed their respective titles at the 2024 VinFast IRONMAN® men's...

Events

Press Releases

Triathlon

October 29, 2024

Taylor Knibb Vs Ashleigh Gentle Headlines Women’s Start List For First Dubai T100 Triathlon World Championship Final

/ENDURANCE SPORTSWIRE/ - Three-time T100 winner Knibb is currently top of the T100 series standings with a win or second place in Dubai on Saturday 16 November enough for her to be crowned the first ever T100 Triathlon World Champion. If two-time T100 winner Gentle were to win and Knibb...

Events

Press Releases

Triathlon

October 29, 2024

Sumarpo Concludes Successful Sponsorship of 2024 Triathlon Events

October 2024 /ENDURANCE SPORTSWIRE/ – Sumarpo proudly announces the successful conclusion of its sponsorship for numerous triathlon and swimrun events in 2024. The brand has made a significant impact across various countries, including the United States, Canada, and the United Kingdom, providing essential gear such as swim caps, race bags,...

Business

Events

Press Releases

Sponsorship

October 29, 2024

supertri returns to NEOM Beach Games fuelling record-breaking growth in triathlon across Saudi Arabia

/ENDURANCE SPORTSWIRE/ - supertri kicks-off the 2024 NEOM Beach Games this weekend, marking the third consecutive year of the triathlon event taking place in the region. Having already tripled broadcast viewership of the sport in Saudi Arabia and significantly increased participation, supertri aims to build on this success. Since operating...

Events

Giving

Press Releases

Triathlon