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

February 28, 2023

Showcased

MOTTIV Training App Reduces Subscription Fee by 65%

VANCOUVER, CANADA /ENDURANCE SPORTSWIRE/ - MOTTIV, an athlete-run company dedicated to ensuring endurance sports and the transformations they bring are accessible to everyone, today launched MOTTIV 2.0, an all-encompassing training and motivation app for runners at every level. After extensive beta testing, new functions have been added including an athlete...

Business

Press Releases

February 28, 2023

Yamaha Bicycles Adds Northwest Regional Field Sales and Marketing Rep

CYPRESS, Calif. /ENDURANCE SPORTSWIRE/ - Yamaha Bicycles continues its field sales and marketing team growth, most recently adding Nate Espinosa as the new representative for the northwest region of the United States. Espinosa, who has spent a lifetime in the bike industry with over two decades of retail, race mechanic...

Business

Cycling

Press Releases

February 28, 2023

Enabled Tracking to Provide Live GPS Tracking for the 2023 Endurance Hunter Trail Race

/ENDURANCE SPORTSWIRE/ Front Royal, VA - Enabled Tracking will be providing tracking for the Endurance Hunter Trail Run for the third year in a row. After expanding from tracking just the 100-mile distance in 2021, Enabled Tracking will provide tracking for the 100-mile and 100K distances in 2023, as they...

Business

Events

Press Releases

February 24, 2023

Meg Treat, APR, named Director of Operations and Communications for Dave McGillivray Finish Strong Foundation

MISSION VIEJO, Calif. /ENDURANCE SPORTSWIRE/ – Treat Public Relations has expanded its engagement with clients Dave McGillivray and the Dave McGillivray Finish Strong Foundation. The PR agency representing endurance sports events and public figures will also continue to support media relations initiatives for DMSE Sports alongside their in-house communications team. Owner...

Business

Press Releases