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

September 6, 2023

Kinomap announces new video preview integration with Strava

(Sept. 6, 2023) /ENDURANCE SPORTSWIRE/ - Kinomap, an interactive video-based training app for runners, cyclists and rowers, today announced a new integration with Strava, the leading subscription platform at the center of connected fitness, that allows users of both platforms to upload 10-second video clips. Integrated with Strava since 2016,...

Business

Cycling

Press Releases

Products

Running

September 5, 2023

Life Time Unveils Company’s First Ground-Up Pickleball Club in Chanhassen, Minnesota

CHANHASSEN, Minn., Sept. 5, 2023 /ENDURANCE SPORTSWIRE/ - As pickleball continues its explosive growth trajectory, Life Time (NYSE: LTH), the nation's premier healthy lifestyle brand and the largest provider of permanent pickleball courts in the country, today announced the groundbreaking of Life Time Pickleball Chanhassen, the Company's first ground-up pickleball location in the country. Life Time Chanhassen...

Business

Press Releases