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

September 18, 2023

Jogology™ Running Socks Now Available Exclusively at Select Run Specialty Stores

Wake Forest, N.C. (September 18, 2023) /ENDURANCE SPORTSWIRE/ – New running sock brand Jogology is available now exclusively at Run specialty retailers throughout the U.S. Jogology founders Tanya and Bert Pictor and Luke Rowe created the brand to provide a high quality product as well as grow the running community in...

Press Releases

Products

Running

September 18, 2023

SH1FT Fitness Introduces a Fresh Series of Express Workouts to Keep You Moving

/ENDURANCE SPORTSWIRE/ – As the sun sets on summer and daily routines regain their momentum, time becomes a precious commodity. SH1FT Fitness, a frontrunner in innovative fitness programs, has responded to the time-crunched schedules of its community with the launch of an exciting range of express workouts. These new additions...

Press Releases

Products

September 15, 2023

Leading road safety sportswear experts Bodylite announce UK launch

September 2023 - UK /ENDURANCE SPORTSWIRE/ – Bodylite are a leading Irish sportswear brand that specialise in visibility products and active gear for runners, walkers, cyclists and outdoor enthusiasts. Founded by Padraic George in 2013, the dedicated team based in Co Carlow, Ireland, have spent many years developing their industry-leading product range,...

Press Releases

Products

Running

September 15, 2023

Tifosi Launches 2nd Annual Awareness Collection in Support of Breast Cancer Research

Watkinsville, GA (September 15, 2023)/ENDURANCE SPORTSWIRE/ – Tifosi Optics, a leading sport and lifestyle sunglasses brand, is proud to reintroduce the brand’s Breast Cancer Awareness Collection in support of the Lynn Sage Breast Cancer Foundation. The popular collection features pink colorways in Tifosi’s most popular active-lifestyle eyewear and a portion of...

Giving

Press Releases

Products