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 (16)
) 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 1990, 10

June 7, 2023

Attaquer Time Attack Strava Challenge and Giveaway

/ENDURANCE SPORTSWIRE/ – Australian cycling kit pioneers Attaquer have just launched their Time Attack Strava Challenge. Clock up 100 minutes in 10 days to score a $75AUD Attaquer voucher and go into the running to win $3,000AUD of kit, plus anyone who completes the challenge in a single activity also has...

Cycling

Events

Press Releases

June 7, 2023

Coming This Month: USA Triathlon’s Seventh Annual National Triathlon Week Presented By Nix Biosensors

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – USA Triathlon today announced the dates for the seventh annual National Triathlon Week Presented by Nix Biosensors, a nationwide initiative to celebrate the sport of triathlon and all its constituency groups. The social-media-based campaign brings the multisport community together from June 26-July 2 — not only to swim,...

Events

Press Releases

Triathlon

June 7, 2023

Inaugural Bruce Lee Challenge Announced for 2023

San Diego, CA /ENDURANCE SPORTSWIRE/ - “The Key to immortality is first living a life worth remembering.” The inaugural Bruce Lee Challenge is underway until December 31st. “Willing is not enough, we must do.” The Bruce Lee Challenge features a custom 12-week training program inspired by Bruce Lee’s workout regime....

Cycling

Events

Giving

Press Releases

Products

Running

June 6, 2023

Registration for 128th Boston Marathon® presented by Bank of America to Open September 11-15, 2023

BOSTON/ENDURANCE SPORTSWIRE/ – The Boston Athletic Association (B.A.A.) announced today that registration for the 128th Boston Marathon® presented by Bank of America, to be run on Monday, April 15, 2024, will take place over five days, September 11–15, 2023, within www.baa.org. This will be the first Boston Marathon with Bank of...

Events

Press Releases

Running

June 6, 2023

Cycling Travel Experts Sportive Breaks Announce Australia Launch

6th June 2023- Australia /ENDURANCE SPORTSWIRE/ – Sports travel experts Sportive Breaks offer bespoke premium travel packages for cyclists looking to take part in the world’s most prestigious grand tours, cycling classics and weekenders. Be it that you are looking for your next big endurance challenge or simply some time away cycling...

Cycling

Events

Press Releases

June 6, 2023

The Ultimate Test of Endurance Returns for Its Third Year

/ENDURANCE SPORTSWIRE/ – 2023 will be the third time Ultra X Wales runs and it will have the largest field yet. 300 runners and over 30 nationalities are expected to bring in over £100,000 in direct economic value into the local economy, Ultra X Wales by ASICS is a multi-stage ultra-marathon...

Events

Press Releases

Running

June 6, 2023

Challenge Geraardsbergen Gears Up for Great Race Weekend

/ENDURANCE SPORTSWIRE/ – This coming weekend a great battle awaits at Challenge Geraardsbergen. Dutch defending champion Diede Diederiks returns hoping to win again and in the men's race Joe Skipper, Ruben Zepuntke and Menno Koolhaas are ready for a head-to-head. Challenge Geraardsbergen is not only a beautiful, but also a very...

Events

Press Releases

Triathlon