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

July 12, 2023

Marathon Tours & Travel announces launch in Australia

/ENDURANCE SPORTSWIRE/ – Marathon Tours & Travel offers travel packages for runners, with guaranteed entry, transport, accommodation and ‘on the ground’ team support for some of the most famous running events around the world. The team offer an industry-leading line up of race packages from the famous Abbott World Marathon Majors,...

Business

Press Releases

Running

July 11, 2023

Showcased

UNDRBUDR Launches New ULTRABUDR Product Line and Shifts Toward More Sustainable Packaging

UNDRBUDR® Launches New ULTRABUDR® Product Line and Shifts Toward More Sustainable Packaging Launches new line of consumer-focused, athletic massage oil product family Introduces limited “Summer Edition” massage oil Introduces more sustainable packaging July 10, 2023 - Montclair NJ /ENDURANCE SPORTSWIRTE/ - UNDRBUDR, LLC, developer of high performance, natural derived skincare,...

Business

Cycling

Press Releases

Products

Running

Triathlon

July 11, 2023

RunSignup Reports Strong Q2 2023 Business Growth and Positive Market Trends

Moorestown, NJ - July 11, 2023/ENDURANCE SPORTSWIRE/ – RunSignup, the leading provider of race registration and technology solutions for endurance events in the U.S., announces its Q2 2023 business update, highlighting significant growth and positive trends in the company's performance. RunSignup's Q2 results demonstrate a strong recovery from the pandemic and...

Business

Press Releases

Running

Triathlon

July 11, 2023

Liv Cycling Hosts Watch Parties Across the Globe for the Tour de France Femmes avec Zwift

NEWBURY PARK, CA — JULY 11, 2023 /ENDURANCE SPORTSWIRE/ - Liv Cycling, official partner of the Tour de France Femmes avec Zwift and sponsor of the white jersey for the ‘Best Young Rider Classification’ , today announces a global series of watch parties to encourage more viewership of the iconic race...

Business

Cycling

Events

Press Releases

Sponsorship

July 10, 2023

FRESHJUNKIE Racing Launches New AmBADASSador Program to Empower Athletes and Promote Healthy Lifestyles

Baton Rouge, LA /ENDURANCE SPORTSWIRE/ - FRESHJUNKIE Racing, a leading event production company known for its exceptional race experiences, is thrilled to announce the launch of its highly anticipated AmBADASSador program. The program aims to inspire, support, and empower athletes of all levels while fostering a community dedicated to health,...

Business

Events

Press Releases

Running

July 10, 2023

USA Triathlon Officials Program Now Recognized as a World Triathlon Accredited Technical Officials Education Program

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – USA Triathlon today announced the organization’s Officials Program is now recognized as a World Triathlon Accredited Technical Officials Education Program (ATOEP), joining 16 other leading world federations with the designation and global recognition. “Being recognized by World Triathlon accreditation is a major step forward in USA Triathlon’s...

Business

Press Releases

Triathlon

July 10, 2023

Juice Plus+ Announces Travis Garza as New Global Chief Executive Officer

COLLIERVILLE, TN (July 10th, 2023)/ENDURANCE SPORTSWIRE/ – Leading global health and wellness company, Juice Plus+, has announced today that Travis Garza has been appointed as Global Chief Executive Officer (CEO). A veteran in the industry, Garza has two decades of experience driving strategy, growth, and innovation within leading direct sales and...

Business

Press Releases