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 (21085)
) 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 1140, 10

January 11, 2023

Reduce your need for Volunteers with WaterMonster!

Kerrville, Texas (January 2023) /ENDURANCE SPORTSWIRE/ – Now that we are seeing a flush of events coming back and (crossing our fingers) staying around, Race and Event Directors are working harder than ever to recruit and sustain Volunteer for its events. At Event Hydration Solutions, we know events. We have been...

Press Releases

Products

January 10, 2023

Showcased

An Iron-Clad Patent for an Iron Man Product

/ENDURANCE SPORTSWIRE/ - A Patent as Secure as Our Product BibBoards are well-known for how secure they keep your race bib secured to your shirt on race day. The only thing more secure than the BibBoard product is the patent that protects the technology and design that is bringing an...

Awards

Business

Cycling

Press Releases

Products

Running

Trade Shows

Triathlon

January 10, 2023

MAAP X 100% Hypercraft Has Landed In Fresh, New Seasonal Shades

SAN DIEGO, Calif. – January 10, 2023 /ENDURANCE SPORTSWIRE/ – Uniquely combining color and craft, MAAP x 100% Hypercraft sunglasses have returned in fresh new seasonal colors. Part of an ongoing collaboration, MAAP have again teamed up with the California-based performance eyewear specialists, 100%. MAAP x 100% Hypercraft lenses are built...

Cycling

Press Releases

Products

Triathlon

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 9, 2023

The RiderBox Highlights Female Professional Cyclists in its Latest Winter Edition

/ENDURANCE SPORTSWIRE/ – The RiderBox, a leader in the endurance gift and subscription industry, has debuted their Winter Edition which is receiving high acclaim due to its focus on female professional cyclists. The RiderBox, which itself was founded by two former professional female cyclists, has given back to the sport through...

Cycling

Press Releases

Products

Triathlon

January 6, 2023

Gnarly Nutrition Partners with Method Outdoor Collective National Sales Agency

Salt Lake City, UT (January 6, 2023) /ENDURANCE SPORTSWIRE/ - Gnarly Nutrition, makers of clean, effective, and great-tasting sports nutrition supplements, is excited to announce a new sales partnership with specialty sales agency Method Outdoor Collective. Method Outdoor Collective was founded by Sasha Dietschi-Cooper, former Vice President of Sales at...

Business

Press Releases

Products