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 (8742)
) 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 3270, 10

May 11, 2023

Delivgear Launches Revolutionary Phone Holder for Cyclists

Amsterdam, Netherlands/ENDURANCE SPORTSWIRE/ – Delivgear Inc, a leader in delivery cycling accessories, has announced the launch of their first product for all cyclists. ”DG MODEL 8 Phone Holder”. This revolutionary phone holder is specifically designed for cyclists who want to keep their phones safe and secure while riding in all conditions....

Cycling

Press Releases

Products

May 11, 2023

PTO Signs Up ROUVY as New Partner of PTO Tour

London/ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) has announced a new partnership with ROUVY, who will become the Official Virtual Ride Partner of the 2023 PTO Tour. As part of the partnership, the leading indoor cycling platform will give amateur triathletes the exclusive opportunity to join a Virtual Ride by ROUVY...

Press Releases

Sponsorship

Triathlon

May 11, 2023

Nulo & Spartan Team Up to Promote Proper Nutrition for Pets Across the U.S.

Boston, MA and Austin, TX, May 11, 2023 /ENDURANCE SPORTSWIRE/ – Nulo, the innovative pet nutrition brand that believes that inside our best friend lives an incredible canine or feline athlete, today announced their partnership with Spartan, making Nulo the Official Pet Food and Pet Treat of Spartan Race U.S. For...

Press Releases

Products

Running

Sponsorship

May 11, 2023

PTO Adds Singapore’s Mediacorp to Growing Roster for 2023 PTO Tour

London, UK/ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) has added Singapore’s Mediacorp to its growing roster of broadcasters for the 2023 PTO Tour. Mediacorp is Singapore’s largest content creator and national media network, operating a suite of TV channels, radio stations and multiple digital platforms. It will show the PTO Asian...

Events

Press Releases

Triathlon

May 11, 2023

America’s Top Pro Cycling Race Maryland Cycling Classic, presented by UnitedHealthcare Reveals Official Commemorative Jersey for 2023

BALTIMORE, Maryland (May 11, 2023)/ENDURANCE SPORTSWIRE/ – The Maryland Cycling Classic, presented by UnitedHealthcare, America’s top-ranked cycling race, today revealed its official commemorative jersey for 2023 designed by Athlos Sportswear. Headquartered in Baltimore, the custom cycling apparel company is returning as technical partner of the event for a second year, which takes...

Cycling

Events

Press Releases

May 11, 2023

Run Tucson Hosts RRCA Coaching Certification Courses at May 27th TMC Meet Me Downtown

/ENDURANCE SPORTSWIRE/ Runners and fitness enthusiasts are invited to the Road Runners Club of America (RRCA) Coaching Certification courses held in Tucson, Arizona on Memorial Day Weekend as part of the RRCA West Regional Championship events. As part of a three-way partnership, the RRCA Level One and Level Two courses...

Press Releases

Running

Trade Shows

May 10, 2023

Take the Lead Opens Registration for 2023 Retreat

Seattle, Wash. (May 10, 2023)/ENDURANCE SPORTSWIRE/ - Take the Lead, a first-of-its-kind retreat for women and femme of color (WFOC) in the running industry, today opens registration for the 2023 retreat in Chicago, IL this August 14-16. The retreat launched in 2022 with the goal of providing WFOC who work...

Events

Giving

Press Releases

Trade Shows

May 10, 2023

Long Beach Runners Have New Opportunities to Prepare for October Marathon

Long Beach, CA – May 10, 2023/ENDURANCE SPORTSWIRE/ – The Long Beach Marathon and Half Marathon today announced a new partnership with specialty outdoor retailer REI for the 2023 event, including a series of events leading up to the races. The marathon is Southern California’s largest fall road race and will...

Press Releases

Running

Sponsorship

May 10, 2023

All In Adventure Stories releases June 13th on Amazon

ALL IN ADVENTURE STORIES The Bold Pursuit of Your Potential By adventurer, trainer, coach, inspirational speaker, and author Tim Walther /ENDURANCE SPORTSWIRE/ – Find flow, elevate your life, and experience higher levels of peak performance. Inspiring stories and a practical framework that will fuel your next adventure to expand your limits in...

Press Releases

Products