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 (11)
) 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 1430, 10

March 23, 2023

RunSignup Concludes Initial Roadshow, Announces Additional Stops

Moorestown, NJ /ENDURANCE SPORTSWIRE/ - RunSignup, the leading registration and technology solution for U.S. endurance events, wrapped up their inaugural Winter Roadshow in Moorestown, NJ on 3/14. However, with the initial series complete, RunSignup announces that the Roadshow will continue onto more locations throughout 2023. RunSignup opted to forego their...

Business

Cycling

Events

Press Releases

Products

Running

March 23, 2023

Registration launches for the 2023 Mississippi Gulf Coast Marathon and the 2024 Louisiana Marathon

BATON ROUGE, LA. /ENDURANCE SPORTSWIRE/ - The tandem of the Mississippi Gulf Coast Marathon and the Louisiana Marathon have launched registration and are off to a great start. The weekend-long events bookend the holiday season with Coastal Mississippi hosting on December 9-10, 2023, and Baton Rouge hosting on January 13-14,...

Business

Events

Press Releases

Running

March 23, 2023

Cardio Equipment Manufacturer BODYCRAFT® and Kinomap Launch Strategic Partnership

San Diego, CA (March, 2023) /ENDURANCE SPORTSWIRE/ – Today it was announced at the 2023 IHRSA Conference in San Diego, that BODYCRAFT Fitness, a leading manufacturer of cardio equipment worldwide, and Kinomap have launched a strategic partnership for BODYCRAFT exercisers. As a result of this partnership, BODYCRAFT’s exercisers will be able...

Business

Press Releases

Products

March 22, 2023

Aleck Acquires Tocsen, Maker of Helmet-Mounted Crash Sensors

South Lake Tahoe, CA (Mar. 22, 2023) /ENDURANCE SPORTSWIRE/ – Aleck®, maker of the industry’s best-selling wireless audio and communication systems for outdoor sports, announced today its acquisition of Tocsen, the German maker of intelligent helmet-mounted crash sensors. Tocsen was founded in 2019 by Alexander Schumacher, Andreas Botsch, and Malte Buttjer...

Business

Press Releases

March 22, 2023

The IRONMAN Group Appoints Marieka Barnard as New Chief Marketing Officer

TAMPA, Fla. (March 22, 2023) /ENDURANCE SPORTSWIRE/ – The IRONMAN Group is pleased to announce the appointment of Marieka Barnard to Chief Marketing Officer (CMO) after serving most recently as Vice President of Event Marketing for The IRONMAN Group in EMEA. Barnard has deep institutional knowledge and expertise of the endurance...

Business

Press Releases

Triathlon