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

July 14, 2023

The RunnerBox and RiderBox Bring the Heat with their Newest Summer Edition

/ENDURANCE SPORTSWIRE/ – The RunnerBox and RiderBox announce the release of their newest subscription series, the Summer Edition. Shipping throughout June and July, the Summer Edition features thoughtfully curated gear and nutrition to help athletes make their summer training and racing as successful as possible. With items like protein to recover...

Cycling

Press Releases

Products

Running

Triathlon

July 13, 2023

RunSignup’s RaceDay Mobile Timing App Now Offers Timer Backup Mode

July 13, 2023 - Moorestown, NJ/ENDURANCE SPORTSWIRE/ – RunSignup, the leading registration and technology solution provider for endurance events in the United States, announces its RaceDay Mobile Timing App new release offering “backup mode” for timers. RunSignup’s free Mobile Timing App is a timing product for smaller or remote events and...

Press Releases

Products

Running

Triathlon

July 13, 2023

BibBoards Introduces Custom Shoe Charms, Elevating Race Day Swag for Event-Goers

BibBoards Launches Custom Shoe Charms, Enabling Race Goers to Personalize Their Race Day Swag San Ramon, 7/13/2023 - /ENDURANCE SPORTSWIRE/ – BibBoards, a leading provider of innovative event bib fasteners, is thrilled to announce the launch of their latest product: custom shoe charms. Designed specifically for race goers, these customizable charms...

Events

Press Releases

Products

Running

Triathlon

July 12, 2023

Pickle Juice® Looks to Prevent People from Buying… Pickles?

MESQUITE, Tex. (July 12, 2023)/ENDURANCE SPORTSWIRE/ – As word spreads about the benefits of pickle juice, The Pickle Juice Company has crafted a tongue-in-cheek campaign to educate consumers and athletes alike on the difference between Pickle Juice® and pickle brine. The former is a supplement beverage scientifically proven to prevent muscle cramps...

Press Releases

Products

July 12, 2023

Master Spas expands partnership with Michael Phelps to launch innovative cold tub for ultimate recovery

FORT WAYNE, Ind. — JULY 12, 2023/ENDURANCE SPORTSWIRE/ – Master Spas, a leading manufacturer of hot tubs and swim spas, is proud to announce the launch of the Michael Phelps Chilly GOAT Cold Tubs in collaboration with legendary swimmer and longtime Master Spas brand ambassador Michael Phelps. Phelps, the most decorated...

Press Releases

Products

Sponsorship

July 11, 2023

Suunto Offers Improved Pricing On Elite Watch Models

HELSINKI (July 11, 2023 ) /ENDURANCE SPORTSWIRE/ - Suunto, a leader in design and innovation for sports watches, dive computers, compasses and digital services used by adventurers all over the globe, announced today that it has dropped prices on a variety of its celebrated watch models, making the company’s brand...

Press Releases

Products

July 11, 2023

Run Industry Veterans Tanya and Bert Pictor and Luke Rowe Launch Jogology™ Running Socks Exclusively for Run Specialty Stores

Wake Forest, N.C. (July 11, 2023) /ENDURANCE SPORTSWIRE/ – Running industry veterans Tanya and Bert Pictor and Luke Rowe introduce a new running sock brand called Jogology, to be sold exclusively at Run Specialty stores beginning in September. Founded by lifelong runners with a combined century of knowledge on running-focused brands,...

Press Releases

Products

Running

July 11, 2023

USA Triathlon Chooses Wintergreen® as an Official Warm-up and Recovery Partner

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – USA Triathlon today announced it has partnered with Wintergreen as the organization’s official warm-up and recovery partner. The lifestyle of a triathlete: Train / Recover / Repeat is the foundation of the Wintergreen product line. Unlike almost every other topical analgesic Wintergreen offers a comprehensive range of products including gels, creams, sprays and soaks...

Press Releases

Products

Sponsorship

Triathlon