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

November 4, 2021

3000 riders tackle 8th GFNY Cozumel

This weekend, the 8th edition of GFNY Cozumel will be held with a sold out field of 3000 riders flooding to the beautiful island. GFNY Cozumel is the largest bike race in the Americas south of NYC because it combines exciting racing with a spectacular vacation like arguably no one...

Cycling

Events

Press Releases

November 4, 2021

Uruguayan cycling marks its comeback with GFNY Colonia

After not having been able to hold races in Uruguay due to the pandemic, GFNY is back with two races in Uruguay. The first race being this weekend, with GFNY Uruguay - Colonia del Sacramento. The South American race offers a long, competitive route of 148km long with an elevation...

Cycling

Events

Press Releases

November 4, 2021

Showcased

Quintana Roo advances high-performance, lightweight tri with the debut of the V-PR

Chattanooga, TN (Nov. 4, 2021) — Quintana Roo announces the debut of the V-PR triathlon bike, marking QR’s evolution in tri bikes toward greater strides in performance across a wider variety of courses, thanks to a renewed focus on next-level weight savings and aerodynamic gains. Newly designed from the ground...

Cycling

Press Releases

Products

November 3, 2021

New Rhythm Cycling Group Exercise Solution from Stages Cycling

(Boulder, CO – 3 November 2021) /ENDURANCE SPORTSWIRE/ - StagesⓇ Cycling, a leading cycling technology company, has added a new rhythm-based indoor cycling experience to its Stages Studio group display and data collection software, as well as the tools to dynamically create a custom brand experience in studio. The Stages...

Cycling

Press Releases

Products

November 3, 2021

Standard Chartered Singapore Marathon 2021 returns with hybrid finale events that celebrates the community’s resilience

SINGAPORE, 3 November 2021 /ENDURANCE SPORTSWIRE/ - It was announced today that the Standard Chartered Singapore Marathon (SCSM) will return with a hybrid format for the second straight year in 2021 and will feature a special series on the SCSM Virtual Club (VC). In addition to the usual challenges and...

Events

Press Releases

Running

November 3, 2021

Barebells Launches New Mouthwatering Flavor Just In Time For The Holidays

LOS ANGELES - (November 3, 2021) /ENDURANCE SPORTSWIRE/ - Barebells- the revolutionary, high-in-protein, no sugar added protein bar brand- has just announced the launch of their new protein bar, Holiday Crisp, a limited edition for the Holiday Season. Barebells’ Holiday Crisp will be available for purchase starting November through their...

Press Releases

Products

Triathlon

November 3, 2021

Nomination Period Now Open for 2022 Running USA Industry Conference Awards

(Nov. 3, 2021) /ENDURANCE SPORTSWIRE/ Running USA announced today that nominations are now being accepted for its 2022 Industry Awards, which will be presented at the upcoming Industry Conference presented by Race Roster in Orlando. The event will be held Feb. 20-22, 2022. The 2022 awards are: The Running USA...

Awards

Press Releases

Running

November 3, 2021

Santamaria defends his title at GFNY North American Championship

After the GFNY Marathon debut last week, GFNY was back at cycling with the GFNY North America Championship race in Sebring, Florida.  Moderate Floridian temperatures and partly cloudy skies offered ideal racing conditions. The race started out fast with a peloton of about 150 riders forming quickly, followed by another...

Cycling

Events

Press Releases

November 2, 2021

Designer Wellness Introduces Designer Smoothie, A Shelf Stable and Portable Protein Fruit Snack

CARLSBAD, CA, - November 2, 2021— Designer Wellness, the trusted source for nutrient-filled protein powders and other wellness products, today introduced Designer Smoothie, a shelf stable and portable protein fruit smoothie that is made with real fruit, contains 12 grams of whey protein isolate, is all natural, gluten free, has...

Cycling

Press Releases

Products

Running