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

February 1, 2022

F2C Nutrition Official Nutrition Partner of the Okanagan Granfondo and the Okanagan Graveller

/ENDURANCE SPORTSWIRE/ - F2C Nutrition Inc. is proud to be the official nutrition partner for the Okanagan Granfondo and the Okanagan Graveller cycling events. F2C Nutrition, known for its clean, athlete-focused, science driven premium sports nutrition products and internationally recognized for quality and innovation, will support both events with race fuel,...

Cycling

Press Releases

Sponsorship

February 1, 2022

GallantFew, Classy, and sodisp.com partner up to bring an integrated fundraising and challenge experience for the Patriot Challenge

Feb 1, 2022/ENDURANCE SPORTSWIRE/ - February 2022 marks the 10th year of GallantFew’s Patriot Challenge, a month-long advocacy, community fitness, and fundraiser for the organization of GallantFew to provide individualized transition assistance to veterans.  In 2021, Patriot Challenge connected America to its veterans with nearly 8,000 participants from all backgrounds. Patriot...

Giving

Press Releases

February 1, 2022

XTERRA Announces Retirement of Janet Clark

February 1, 2022 /ENDURANCE SPORTSWIRE/ - XTERRA Global, LLC, today announced the retirement of Janet Clark, president of the XTERRA World Tour. Born and raised in Canberra, Australia, Clark was a founding member of the team who produced the inaugural XTERRA triathlon in 1996 on the island of Maui, and...

Business

Press Releases

Running

Triathlon

January 31, 2022

Barebells Protein Bars Releases a Variety Pack with Top Selling Flavors

LOS ANGELES (January 31, 2022) /ENDURANCE SPORTSWIRE/ - Barebells, the revolutionary, high-in-protein, no added sugar* protein bar brand – is announcing the release of a variety pack with their top flavors from their direct-to-consumer website which will include cookies and cream, caramel cashew, salty peanut, and chocolate dough. “We have...

Press Releases

Products

January 31, 2022

Sun Belt Conference Basketball Tournaments Single-Game Tickets on Sale February 1

  NEW ORLEANS  /ENDURANCE SPORTSWIRE/ - Single-game tickets for the 2022 Sun Belt Conference Men’s and Women’s Basketball Tournaments will go on sale Tuesday, Feb. 1 at 11 a.m. ET/10 a.m. CT. In partnership with Pensacola Sports and Visit Pensacola, the tournaments will be held March 2-7, 2022, at the...

Events

Press Releases

January 31, 2022

Destination Sport Experiences Guarantee Entry into Brighton Marathon and Dublin Marathon for 2022

/ENDURANCE SPORTSWIRE/ -Destination Sport Experiences are the official Travel Partners for the Brighton Marathon Weekend and as such are pleased to be able to offer clients guaranteed entry, despite general entry now being closed. Brighton Marathon has exploded in popularity in recent years and is now a sell-out event every...

Events

Press Releases

Running

January 31, 2022

Pic2Go Releases New Race Photo Sales Solution

/ENDURANCE SPORTSWIRE/ - Pic2Go’s new photo sales solution introduces a simple approach where participants can pay a fixed fee to access their full personal finisher gallery and download their high-res photos. The solution takes advantage of Pic2Go’s patented 2d barcodes for automated race photo tagging and maintain all the benefits of...

Cycling

Press Releases

Products

Running

Triathlon