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

August 10, 2023

Cycling travel expert Sportive Breaks announces North America launch

/ENDURANCE SPORTSWIRE/ – Sports travel expert Sportive Breaks offers customized premium travel packages for cyclists looking to take part in the world’s most prestigious grand tours, cycling classics and weekenders. They offer an expertly curated range of customized travel packages including cycling tours, training camps, hospitality and VIP experiences. Customers...

Business

Cycling

Press Releases

August 10, 2023

BibRave and Brooks Running Host Speedrun LA – an Influencer Event Celebrating Competition, Content Creation, and Charity for 30,000 Twitch Viewers

Los Angeles, CA /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, collaborated with Brooks Running, a global leader in running footwear and apparel, to host the first-ever Brooks Speedrun LA in Los Angeles on August 5, 2023. This electric and one-of-a-kind track event garnered over 30,000 viewers and...

Events

Press Releases

Running

August 10, 2023

ROKA Renews Partnership with Olympic Gold Medalist Gwen Jorgensen

Austin, Texas (Aug. 10, 2023) /ENDURANCE SPORTSWIRE/ - ROKA, a leading performance design brand that creates and manufactures eyewear and technical apparel for lifestyle and competitive endurance athletes, announced today the re-signing of Olympic gold medalist and two-time World Champion, Gwen Jorgensen. Jorgensen returns to triathlon after taking several years...

Press Releases

Sponsorship

August 10, 2023

Maryland Cycling Classic Presented by UnitedHealthcare Releases Full Schedule of Weekend Events

BALTIMORE, Md. – The Maryland Cycling Classic presented by UnitedHealthcare today announced its full schedule of events for Labor Day weekend beginning Thursday, August 31 and culminating with America’s top-ranked professional road cycling race on Sunday, September 3, 2023, in Baltimore, Md. Featuring a wide range of free activities for...

Cycling

Events

Press Releases

August 10, 2023

Kerrville Tri and GU Energy Labs Join Forces to Power Athletes

Kerrville, Texas, August 10, 2023 /ENDURANCE SPORTSWIRE/ – Kerrville Triathlon Festival is excited to announce its continuing partnership with GU Energy Labs for the third year in a row. The company will be the official Energy Gel and Chews sponsor for the event, providing on-course nutrition for participants competing in the...

Press Releases

Sponsorship

Triathlon