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 (21085)
) 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 1040, 10

January 12, 2023

ROUVY Regulars launched with new features at the iconic Lago di Garda and Alpe d’Huez

January 12th, 2023 /ENDURANCE SPORTSWIRE/ – ROUVY continues to bring the joy of fitness and new legendary virtual locations to the home of every athlete and fitness enthusiast around the globe. Based on augmented real videos from across the world, riders and triathletes can experience real-life cycling and triathlon racing through...

Cycling

Press Releases

Products

Triathlon

January 11, 2023

Reduce your need for Volunteers with WaterMonster!

Kerrville, Texas (January 2023) /ENDURANCE SPORTSWIRE/ – Now that we are seeing a flush of events coming back and (crossing our fingers) staying around, Race and Event Directors are working harder than ever to recruit and sustain Volunteer for its events. At Event Hydration Solutions, we know events. We have been...

Press Releases

Products

January 10, 2023

Showcased

An Iron-Clad Patent for an Iron Man Product

/ENDURANCE SPORTSWIRE/ - A Patent as Secure as Our Product BibBoards are well-known for how secure they keep your race bib secured to your shirt on race day. The only thing more secure than the BibBoard product is the patent that protects the technology and design that is bringing an...

Awards

Business

Cycling

Press Releases

Products

Running

Trade Shows

Triathlon

January 10, 2023

MAAP X 100% Hypercraft Has Landed In Fresh, New Seasonal Shades

SAN DIEGO, Calif. – January 10, 2023 /ENDURANCE SPORTSWIRE/ – Uniquely combining color and craft, MAAP x 100% Hypercraft sunglasses have returned in fresh new seasonal colors. Part of an ongoing collaboration, MAAP have again teamed up with the California-based performance eyewear specialists, 100%. MAAP x 100% Hypercraft lenses are built...

Cycling

Press Releases

Products

Triathlon

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