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 (11)
) 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 480, 10

June 28, 2024

Favorite Bikes Launches Brand New Hybrid CSC ST To COSTCO Canada Online

Favorite Bikes, Los Angeles, California /ENDURANCE SPORTSWIRE/ - Favorite Bikes, a pioneer in electric bike technology, proudly announces the launch of its newest model, the Hybrid CSC ST, available online at Favorite Bikes and through the newly formed relationship with Costco’s Canada and their online store for $1999 CAD. This cutting-edge...

Business

Cycling

Press Releases

Products

June 28, 2024

Ultra X Announces Big Summer Sale

/ENDURANCE SPORTSWIRE/ - Ultra X, renowned for organizing world-class ultra-marathons, is thrilled to announce the launch of its highly anticipated Big Summer Sale. This exclusive sale offers participants a chance to enjoy a 20% discount on all 2024 events, making it the perfect opportunity to secure a spot in some...

Business

Events

Press Releases

Running

June 28, 2024

Hap Seliga Appointed President of Scott USA

/ENDURANCE SPORTSWIRE/ - SCOTT Sports, manufacturer and distributor of high-quality Bike and Outdoor equipment and apparel, welcomes industry veteran Hap Seliga as President of SCOTT USA, the United States subsidiary of SCOTT Corporation. Alongside teams based in Salt Lake City and Ogden, Utah, Seliga will work to drive growth in...

Business

Cycling

Press Releases

June 26, 2024

Chargel Continues On-Site Samplings and Sponsorships at California’s Truckee Tahoe Gravel

IRVINE, Calif. (June 26, 2024)/ENDURANCE SPORTSWIRE/ - Chargel®, a first-of-its-kind, delicious Gel Drink that delivers convenient and delightfully unexpected instant pre-workout energy with zero caffeine, today announced it will be sampling its half drink, half snack, energy source at the 2024 Truckee Tahoe Gravel. Running from June 28-29 in Truckee,...

Business

Cycling

Events

Giving

Press Releases

Products

Sponsorship

Wire Syndication

June 21, 2024

Austin International Half Replaces 3M Half Marathon

Austin, Texas – June 21, 2024/ENDURANCE SPORTSWIRE/ – High Five Events is thrilled to announce the rebranding of the renowned 3M Half Marathon to the Austin International Half. The race, set to take place on January 19, 2025, will continue to offer the same scenic route through Austin, Texas, while embracing...

Business

Events

Press Releases

Running