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

March 8, 2022

The King of All Crits Weekend Returns April 9-10

Anniston, AL, March 8, 2022 /ENDURANCE SPORTSWIRE/ - Alabama’s annual premier professional cycling event weekend, the Alabama Cycling Classic, returns to the City of Anniston and Main Street Anniston’s, Noble Street corridor on April 9-10, 2022. The day one event, the Sunny King Criterium is the first venue and stop of the...

Cycling

Events

Press Releases

March 8, 2022

Ashworth Awards to Open Second U.S. Manufacturing Facility

/ENDURANCE SPORTSWIRE/ - Ashworth Awards is in the process of constructing their second manufacturing facility for their fully made in USA domestic medallions and awards line. In February of 2020, Ashworth Awards launched its new line of MADE IN USA medals and awards and it quickly became apparent that an...

Business

Press Releases

Products

March 7, 2022

Publix named Title Partner for Rock ‘n’ Roll Running Series Clearwater Scheduled to take place October 1-2, 2022

TAMPA, Fla. (March 7, 2022) /ENDURANCE SPORTSWIRE/ - The Rock ‘n’ Roll® Running Series announced today that Publix Super Markets, Inc., the largest employee-owned grocery retailer in the country, will serve as the title partner for the inaugural Publix Rock ‘n’ Roll Running Series Clearwater scheduled to take place on Oct. 1-2,...

Press Releases

Running

Sponsorship

March 7, 2022

New UPMC Health Plan Pittsburgh BACK Half Marathon Celebrates Outstanding Charity Runners with Red Carpet Experience

PITTSBURGH, PA (March 7, 2022)/ENDURANCE SPORTSWIRE/ - This year P3R is unrolling the red carpet and celebrating outstanding charity runners with the new UPMC Health Plan Pittsburgh BACK Half Marathon. Limited to the first 500 runners who fundraise $1,500 or more for charity, the new race will start in Shadyside...

Events

Press Releases

Running

March 7, 2022

3,200 Runners Take On Baptist Health 305 Half Marathon & 5K produced by Life Time March 5

MIAMI, Fla., Mar. 6, 2022/ENDURANCE SPORTSWIRE/ - More than 3,200 runners hit the pavement today at the Baptist Health 305 Half Marathon and “305K”, owned and produced by Life Time. As a fast follow to the Miami Marathon, which is also produced by Life Time, the 305 Half offers runners the...

Events

Press Releases

Running

March 7, 2022

Pic2Go Partnered with The Ventura Marathon to deliver Race Day Photos and Rich Finisher Galleries!

/ENDURANCE SPORTSWIRE/ - The fast and scenic Ventura Marathon returned this year, offering a point-to-point marathon (and half marathon) with the perfect amount of downhill starting in Ojai and ending in Ventura. This year the organizers have partnered with Pic2Go to enhance the participants’ experience with auto-delivered free race day...

Press Releases

Products

Running

Sponsorship

March 7, 2022

Super League Triathlon Secures Live and Highlights Coverage Across Europe on Eurosport and discovery+ in 2022

SLT’s Arena Games Triathlon and Championship Series to air in 50 markets in Europe across Discovery’s network of channels and platforms Live and on-demand coverage of SLT events to reach more than 200 million viewers via broad television coverage and streaming via discovery+ and the Eurosport App /ENDURANCE SPORTSWIRE/ -...

Business

Press Releases

Triathlon