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

January 13, 2023

DMSE Sports Serves More Than 120,000 Participants In 2022

BOSTON /ENDURANCE SPORTSWIRE/ – DMSE Sports has released key facts and figures from their 2022 events, showing evidence of road racing’s recovery over the past year. The leading event operations organization founded and lead by Dave McGillivray assisted with the planning and production of 24 events this year, ushering more than...

Business

Events

Press Releases

January 13, 2023

Showcased

Chinkapin Hollow Moves To Last Saturday In October

FAYETTEVILLE, Ark. /ENDURANCE SPORTSWIRE/ - Registration with early bird pricing is open for the 2023 Chinkapin Hollow Gravel Grinder which will be held on Saturday, October 28. Previously, the event was on the third Sunday in October, typically the day after the Big Sugar gravel race in Northwest Arkansas. The...

Cycling

Events

Press Releases

January 12, 2023

eMSR – Open National Slovak Cycling eSport Finals on ROUVY

Bratislava, Slovakia / January 12, 2023 /ENDURANCE SPORTSWIRE/ - After 4 completed rounds of the Slovak eCup, the e-cycling series will culminate this Sunday, January 15th with a fight for the home championship jersey in virtual cycling. The best Slovak riders in each category will battle in Styla Arena in...

Cycling

Events

Press Releases

January 12, 2023

Runners take over Baton Rouge for the running festival with lagniappe

BATON ROUGE, LA. /ENDURANCE SPORTSWIRE/ - Thousands of runners from over 47 states, Canada, Mexico, and Honduras will celebrate more than a decade’s worth of passion for running and Louisiana culture at this weekend’s Louisiana Marathon. Celebrating its 12th year, the Louisiana Marathon aims to encourage the community to embrace...

Business

Events

Press Releases

Running

Sponsorship

January 12, 2023

Corrigan Sports Enterprises bringing NEW event to Annapolis

January 12, 2023 /ENDURANCE SPORTSWIRE/ – Corrigan Sports Enterprises is proud to announce that they have reached an agreement with the City of Annapolis and Anne Arundel County to host the 1st annual Annapolis Running Festival to be held on March 11, 2023. “CSE is thrilled to bring our endurance event formula...

Events

Press Releases

Running

January 12, 2023

Meet the 2023 USA Triathlon Foundation Ambassador Team

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – The 2023 USA Triathlon Foundation Ambassador Team will feature 90 ambassadors, the Foundation announced today, making up a passionate, nationwide community committed to both fundraising and advocacy for the USA Triathlon Foundation, the sport and multisport communities. The ambassadors include some of the top age...

Press Releases

Sponsorship

Triathlon

January 12, 2023

P3R Launches MOVE Pass to Inspire People to Move All Year Long

PITTSBURGH, PA (January 12, 2023) /ENDURANCE SPORTSWIRE/ – Always offering the best ways for everyone to MOVE, P3R introduces the 2023 P3R MOVE Pass. This special pass grants MOVERS access to three of P3R’s signature events including the 2023 DICK’S Sporting Goods Pittsburgh Marathon or UPMC Health Plan Pittsburgh Half Marathon,...

Events

Press Releases

Running

January 12, 2023

Lake Sonoma Race 100k & 55k In Its 3rd Year Moves To Fall: Registration to Open 1/15/23

/ENDURANCE SPORTSWIRE/ – For those looking for a late fall challenge, the Lake Sonoma 100K and 55K registrations will open on January 15th at 9 am PST. The relentless Lake Sonoma 100K serves as a Western States Endurance Run qualifier, while the 55K is the perfect next step for marathoners looking...

Events

Press Releases

Running

January 12, 2023

SIS announce partnership with international cyclist Freddy Ovett – supporting his 2023 gravel adventures

12th January - London, UK/ENDURANCE SPORTSWIRE/ – British-born, Australian Freddy Ovett has enjoyed a successful last few seasons as a professional cyclist, most recently riding for UCI Continental team L3GION of Los Angeles; with career highlights including a 2nd place finish in the 2022 Esports World Championships and 9th overall at...

Cycling

Press Releases

Sponsorship