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 (22)
) 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 1070, 10

January 17, 2023

Frederic Funk and Marten Van Riel join ROUVY as Brand Ambassadors for 2023

Prague, Czech Republic / January 17th, 2023 /ENDURANCE SPORTSWIRE/ – Whether one’s goal is just to stay fit or to make the next race podium, ROUVY’s unique virtual racing platform is there to make the training process fun and engaging. With thousands of popular cycling and tri spots around the world,...

Press Releases

Sponsorship

Triathlon

January 17, 2023

IRC Tire Selected as Official Tire of Unbound Gravel

Davis, CA /ENDURANCE SPORTSWIRE/ – IRC Tire is pleased to announce that they have been chosen as the official tire of Garmin Unbound Gravel presented by Craft, the premier gravel cycling event in the world. Unbound Gravel, known for its challenging terrain, requires tires that can withstand the rigors of off-road...

Cycling

Press Releases

Sponsorship

January 16, 2023

IRC Expands Partnership with Belgian Waffle Ride

Davis, CA /ENDURANCE SPORTSWIRE/ IRC Tire (Inoue Rubber Company) is pleased to announce an expanded partnership with Monuments of Cycling (MOC)’s iconic Belgian Waffle Ride (BWR). IRC will continue as the Official Tire of the growing series of BWR’s ‘Unroad Races’, which are unique mixed-surface Classics-style events. New for 2023,...

Cycling

Press Releases

Sponsorship

January 12, 2023

Runners take over Baton Rouge for the running festival with lagniappe

BATON ROUGE, LA. /ENDURANCE SPORTSWIRE/ - Thousands of runners from over 47 states, Canada, Mexico, and Honduras will celebrate more than a decade’s worth of passion for running and Louisiana culture at this weekend’s Louisiana Marathon. Celebrating its 12th year, the Louisiana Marathon aims to encourage the community to embrace...

Business

Events

Press Releases

Running

Sponsorship

January 12, 2023

Meet the 2023 USA Triathlon Foundation Ambassador Team

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – The 2023 USA Triathlon Foundation Ambassador Team will feature 90 ambassadors, the Foundation announced today, making up a passionate, nationwide community committed to both fundraising and advocacy for the USA Triathlon Foundation, the sport and multisport communities. The ambassadors include some of the top age...

Press Releases

Sponsorship

Triathlon

January 12, 2023

SIS announce partnership with international cyclist Freddy Ovett – supporting his 2023 gravel adventures

12th January - London, UK/ENDURANCE SPORTSWIRE/ – British-born, Australian Freddy Ovett has enjoyed a successful last few seasons as a professional cyclist, most recently riding for UCI Continental team L3GION of Los Angeles; with career highlights including a 2nd place finish in the 2022 Esports World Championships and 9th overall at...

Cycling

Press Releases

Sponsorship

January 11, 2023

GU Energy Labs announces ultrarunner and Indigenous advocate Callie Vinson as 2023 WSER 100 entry recipient

BERKELEY, Calif. /ENDURANCE SPORTSWIRE/ - GU Energy Labs is excited to announce that ultrarunner Callie Vinson will receive the company’s Western States 100 entry for 2023. Vinson, a member of the Choctaw community of the desert southwest and an advocate for body inclusivity and positivity in running, will be representing...

Press Releases

Running

Sponsorship

January 10, 2023

Chargel Fuels Cycling Athletes in 2023 Inking Partnerships with KHS Pro MTB Race Team and SoCalCycling.com Elite Cycling Team

IRVINE, Calif., (January 10, 2023) –  Chargel, a delicious, one-of-a-kind athletic gel drink designed to meet the unique energy needs of runners, cyclists, weekend warriors and everyone in between, today announced 2023 partnerships with two world-class cycling organizations, KHS Pro MTB Race Team, and SoCalCycling.com Elite Cycling Team. The partnerships...

Cycling

Press Releases

Products

Sponsorship

Wire Syndication