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

December 20, 2024

GoFundraise and ACTIVE, a Winning Integration for Charities

Dec 20, 2024 /OUTDOOR SPORTSWIRE/ - GoFundraise, a leading online fundraising platform, and ACTIVE, a global leader in sports and activity management, are excited to announce a strategic integration that will enhance fundraising opportunities in sporting events. This powerful integration between GoFundraise and ACTIVE will enable fundraisers to create fundraising...

Business

Press Releases

December 19, 2024

New Year, New You: IRONMAN Announces 2025 Commitment Day Aimed at Encouraging Athletes to Find Their IRONMAN or IRONMAN 70.3 Finish Line

TAMPA, Fla. (Dec. 19, 2024) /ENDURANCE SPORTSWIRE/ - IRONMAN® Commitment Day is returning in 2025, kicking off on January 1 and encouraging athletes to pledge to the goal of completing an IRONMAN and or an IRONMAN® 70.3® triathlon. The toughest part of the journey is committing, and 2025 IRONMAN Commitment...

Events

Press Releases

Triathlon

December 19, 2024

Reviewed: Sumarpo Race Wetsuit

December 19, 2024 /ENDURANCE SPORTSWIRE/ - Rating: ★★★★☆ Best For: Competitive triathletes, Confident open-water swimmers, Sleek, Fast, and Affordable Notable Features: Slip Skin technology, Yamamoto SCS coating, 5mm leg buoyancy, flattering fit If you’re looking for a wetsuit that performs as well as it looks, the Sumarpo Race Wetsuit might...

Press Releases

Products

Triathlon

December 19, 2024

Challenge Almere-Amsterdam to Extend Hosting of European Championships

/ENDURANCE SPORTSWIRE/ - Challenge Almere-Amsterdam will host the European Championship Long Distance Triathlon in 2025 and for the following three years with a 25% increase in prize money plus an extended cooperation with Rabobank. Following Challenge Almere-Amsterdam's hosting of the Europe Triathlon Challenge Long Distance Championships for the past three...

Press Releases

Triathlon

December 19, 2024

Adventure Enablers Reflects on an Exceptional 2024 and Gears Up for an Exciting 2025

Front Royal, Va. /Adventure Enablers (December 19, 2024) /ENDURANCE SPORTSWIR/ - Adventure Enablers and Enabled Tracking express heartfelt gratitude to all their partners and supporters for an incredible year in 2024. The enthusiasm and trust have been instrumental in expanding our mission to bring unparalleled visibility and engagement to endurance...

Business

Press Releases

Products

December 19, 2024

Movemint Introduces SMS Texting for Organizers

/ENDURANCE SPORTSWIRE/ -The new texting tool is designed to make event communication even easier Movemint is excited to announce a new SMS texting feature. Texting is available alongside Movemint’s suite of email marketing tools in a unified Communications Hub. Texting is perfect for event updates, day-of reminders, and post-event results...

Press Releases

Products

December 19, 2024

Avalon Benefit 50 Mile/50K Run Sells Out Ahead of 2025 Event

AVALON, Calif. (December 19, 2024) /ENDURANCE SPORTSWIRE/ – The Avalon Benefit 50 Mile/50K Run, produced by Spectrum Sports Management, is returning for its annual event on Jan. 11, 2025. The 2025 event sold out its 1,000 registrations almost 3 months ahead of the event date, a month earlier than the previous...

Events

Press Releases

December 18, 2024

Double Bridge Run filling up quick!

Pensacola, FL (Dec. 18, 2024) /ENDURANCE SPORTSWIRE/ - Runner registration is filling up fast for the 2025 Pensacola Double Bridge Run presented by Publix. The race, limited to 4,000 runners, is a local favorite that draws runners from all over the U.S. Dubbed “the race with a view,” the Pensacola...

Events

Press Releases

SWW Syndication

December 18, 2024

Helmets Using WaveCel Technology Outperform Competitors in a Research Study on Head and Brain Protection

Wilsonville, OR—December 18, 2024 /ENDURANCE SPORTSWIRE/ — WaveCel, setting new benchmarks in helmet safety technology by going beyond standards to help protect the head and the brain, today announced formative results from a research study published by the Journal of Forensic Biomechanics. The research evaluated the latest generation of ANSI...

Business

Press Releases

Products

Studies

December 18, 2024

Kids of STEEL Goes Global: First International Site Inspires Movement in South Africa

PITTSBURGH, PA (Dec. 18, 2024) /ENDURANCE SPORTSWIRE/ - Kids of STEEL, P3R’s acclaimed youth fitness program, is making its international debut in Kempton Park, South Africa. This expansion showcases the universal appeal of the program, which inspires families to move together through fun and engaging activities. Kids of STEEL offers...

Events

Press Releases

Running