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

March 19, 2024

GoFundraise Announces New Partnership with IRONMAN UK

/ENDURANCE SPORTSWIRE/ – In an exciting milestone for both the world of endurance sports and charitable fundraising, GoFundraise announced its inaugural partnership with IRONMAN UK. For the first time, fundraising via the GoFundraise platform will be integrated into IRONMAN, marking a significant leap forward in connecting IRONMAN athletes with charitable...

Business

Giving

PR Newswire Syndication

Press Releases

Running

March 19, 2024

Monuments of Cycling Announces Official Bike Tour Partnership With Thomson Bike Tours, The Premier Cycle Tour Operators

SAN DIEGO /ENDURANCE SPORTSWIRE/ - Monuments of Cycling (MoC), the renowned producer of the iconic Belgian Waffle Ride (BWR), is delighted to unveil its partnership with Thomson Bike Tours (TBT) as the Official Bike Tour Partner of the Belgian Waffle Ride series. Thomson Bike Tours holds the esteemed position as...

Business

Cycling

Events

Press Releases

Sponsorship

March 18, 2024

Gold’s Gym West Covina Gets a Makeover, Major Functional Upgrades Unveiled

Los Angeles, CA (March 18, 2024) /ENDURANCE SPORTSWIRE/ - Gold’s Gym SoCal – the original home of fitness workouts – unveils a state-of-the-art refit of its West Covina location. Today. The club opens the doors to its signature playground turf area, offering members a functional area to practice a wide...

Business

Press Releases

March 18, 2024

PTO Confirms ‘Battle of Champions’ for Women’s Singapore T100

London, UK /ENDURANCE SPORTSWIRE/ - The Professional Triathletes Organisation (PTO) and World Triathlon have confirmed a powerful line up for the women’s Singapore T100 triathlon on 13 April, 2024, the second stop on the new eight-leg T100 Triathlon World Tour. Included is Miami T100 champion India Lee, who will be...

Business

Press Releases

Triathlon

March 18, 2024

Cycling travel experts Sportive Breaks announce new self guided road cycling holidays

18th March 2024 - UK /ENDURANCE SPORTSWIRE/ – Cycling travel experts, Sportive Breaks promote bespoke premium travel packages for cyclists looking to take part in the world’s most prestigious grand tours, cycling classics and weekenders. The team offer a range of customised travel packages including cycling tours, training camps, hospitality,...

Business

Cycling

Press Releases

March 14, 2024

Adventure Cycling Secures BikeInsure as Official Bike Insurance Partner

Missoula, MT / March 14, 2024 /ENDURANCE SPORTSWIRE/ - We are excited to announce that Adventure Cycling Association has partnered with BikeInsure to provide our members with opt-in, comprehensive, and easy-to-understand bicycle insurance. Adventure Cycling members may access a discounted rate with BikeInsure to protect their bicycles and e-bikes from...

Business

Cycling

Press Releases

Products

Sponsorship

March 14, 2024

TrainingPeaks Partners with Japan Cycling Federation as Official Software Provider

Louisville, Colo., March 14, 2024 /ENDURANCE SPORTSWIRE/ - TrainingPeaks, the industry-leading training app for endurance coaches and athletes, today announced an exclusive partnership with the Japan Cycling Federation (JCF). TrainingPeaks is now the official training and coaching software for the national governing body of cycle racing in Japan. Established in...

Business

Cycling

Press Releases

Sponsorship