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 (22)
) 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 840, 10

January 12, 2023

Meet the 2023 USA Triathlon Foundation Ambassador Team

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – The 2023 USA Triathlon Foundation Ambassador Team will feature 90 ambassadors, the Foundation announced today, making up a passionate, nationwide community committed to both fundraising and advocacy for the USA Triathlon Foundation, the sport and multisport communities. The ambassadors include some of the top age...

Press Releases

Sponsorship

Triathlon

January 12, 2023

SIS announce partnership with international cyclist Freddy Ovett – supporting his 2023 gravel adventures

12th January - London, UK/ENDURANCE SPORTSWIRE/ – British-born, Australian Freddy Ovett has enjoyed a successful last few seasons as a professional cyclist, most recently riding for UCI Continental team L3GION of Los Angeles; with career highlights including a 2nd place finish in the 2022 Esports World Championships and 9th overall at...

Cycling

Press Releases

Sponsorship

January 11, 2023

GU Energy Labs announces ultrarunner and Indigenous advocate Callie Vinson as 2023 WSER 100 entry recipient

BERKELEY, Calif. /ENDURANCE SPORTSWIRE/ - GU Energy Labs is excited to announce that ultrarunner Callie Vinson will receive the company’s Western States 100 entry for 2023. Vinson, a member of the Choctaw community of the desert southwest and an advocate for body inclusivity and positivity in running, will be representing...

Press Releases

Running

Sponsorship

January 10, 2023

Chargel Fuels Cycling Athletes in 2023 Inking Partnerships with KHS Pro MTB Race Team and SoCalCycling.com Elite Cycling Team

IRVINE, Calif., (January 10, 2023) –  Chargel, a delicious, one-of-a-kind athletic gel drink designed to meet the unique energy needs of runners, cyclists, weekend warriors and everyone in between, today announced 2023 partnerships with two world-class cycling organizations, KHS Pro MTB Race Team, and SoCalCycling.com Elite Cycling Team. The partnerships...

Cycling

Press Releases

Products

Sponsorship

Wire Syndication

January 5, 2023

Enduro Proudly Sponsors Grasshopper Adventure Series

Oakland, California (January 5, 2023)/ENDURANCE SPORTSWIRE/ – Enduro Bearings, innovators of a wide range of bicycle bearings, seals, components and tools, recently signed on to sponsor the 2023 Grasshopper Adventure Series (GAS), a long-running mixed-terrain event series that has become a favorite of many of the top names in the sport. This...

Cycling

Press Releases

Sponsorship

January 5, 2023

P3R Announces Name, Image and Likeness Partnership with Nine Local College Athletes

PITTSBURGH /ENDURANCE SPORTSWIRE/ – P3R has announced a name, image and likeness (NIL) partnership with nine college student-athletes. As part of this opportunity, these P3R Athletes will create content for P3R’s social networks including instructional videos, blogs and other resources to inspire all ages to MOVE. The 2023 P3R Athletes include...

Press Releases

Running

Sponsorship