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

August 17, 2023

Showcased

Danny Faupel has Joined RaceTimes Magazine as Associate Publisher

St. Louis, MO/ ENDURANCE SPORTSWIRE/ - RaceTimes Magazine has hired Danny Faupel as Associate Publisher. “Danny comes to us with more than 30 years of experience in all aspects of the magazine publishing business,” said Kurt Hansen, President and CEO of Innovative Timing Systems, the publisher of RaceTimes Magazine. “Danny...

Business

Press Releases

August 17, 2023

OOFOS Announces Promotion of Dave Mischler to Chief Operating Officer

/ENDURANCE SPORTSWIRE/ – OOFOS, the global leader in Active Recovery footwear, announced today that it has promoted Dave Mischler to the role of Chief Operating Officer. Dave is approaching his one-year anniversary with OOFOS and his accomplishments on the operations side of the business have been exceptional in preparing the...

Business

Press Releases

August 15, 2023

Meb Keflezighi Selects RunDot as His Run Coaching Platform

DALLAS, TX – August 15, 2023 /ENDURANCE SPORTSWIRE/ – Predictive Fitness announces that Meb Keflezighi, one of the greatest American distance runners of all time, is partnering with RunDot, a run training app driven by decades of data and patents-pending artificial intelligence, to power his coaching business. The intelligence engine produces...

Business

Press Releases

Products

Running

August 13, 2023

XTERRA Czech World Cup Weekend Wrap

/ENDURANCE SPORTSWIRE/ - Felix Forissier (FRA) and Solenne Billouin (FRA) won the XTERRA Czech Republic full-distance off-road triathlon elite titles in Prachatice on Saturday, August 12, 2023, and Billouin and Arthur Serrières (FRA) captured the XTERRA Czech Short Track titles on a beautiful blue sky day at Ktišský Lake on...

Business

Press Releases

Triathlon

August 11, 2023

XTERRA World Cup – Czech Republic this Weekend in Prachatice

/ENDURANCE SPORTSWIRE/ – The XTERRA World Cup rolls into the medieval town of Prachatice in the Czech Republic with full distance and XTERRA Short Track races this Saturday and Sunday, August 12-13. It’s the start of an intense set of five races in 15 days across three countries that could...

Business

Press Releases

Triathlon