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

September 14, 2023

Innovative Sport Surfacing Announces New Locations in Texas

Houston, TX /ENDURANCE SPORTSWIRE/ - Up-and-coming sports flooring franchise Innovative Sport Surfacing has just announced new active territories throughout Texas. The newest agreement was completed with Don Pearcy who now owns 15 territories throughout the state. “This is a monumental deal for our company as we seek to gain ground throughout...

Business

Press Releases

September 14, 2023

Jose Maldonado Named Chief Marketing Officer of PeopleForBikes

BOULDER, COLO. /ENDURANCE SPORTSWIRE/ - PeopleForBikes, the U.S. bicycle industry’s trade association and a national advocacy nonprofit, announced Jose Maldonado as its first chief marketing officer. Maldonado started with PeopleForBikes in October 2019 and recently returned to lead strategy and amplify campaigns aimed at making the U.S. the best place to...

Business

Cycling

Press Releases

September 13, 2023

The Running Event Names Low Impact Alliance Environmental Impact Partner

PORTLAND, Maine (September 13, 2023)/ENDURANCE SPORTSWIRE/ – The Running Event (TRE), North America’s premier specialty retail conference and tradeshow, has named the Low Impact Alliance (LIA) its Environmental Impact Partner. The Running Event will take place November 28-30 at the Austin Convention Center in Austin, TX. The LIA is a collective of...

Business

Press Releases

Running

Trade Shows

September 13, 2023

Introducing Solarcore®, a Thermal Solutions Company that Leverages NASA-inspired Aerogel

PORTLAND, Ore. (Sept. 13, 2023)/ENDURANCE SPORTSWIRE/ – Today, Solarcore® officially launches as a standalone materials technology brand, leveraging the thermal properties of NASA-licensed Aerogel, the world’s lowest thermally conductive solid, to revolutionize insulation for a multitude of applications – from structures and packaging to cold weather apparel and footwear. By combining cutting-edge...

Business

Press Releases

Products

Wire Syndication

September 12, 2023

ReSport provides advanced tracking technology for Paulie’s Push: Newark to Shanksville

/ENDURANCE SPORTSWIRE/ - ReSport provided technological support and live GPS tracking for Paulie's Push, an anniversary tribute to the flight crews who lost their lives during the 9/11 terrorist attacks. From mid-August to September 11, former flight attendant Paulie Veneto pushed a beverage cart over 300 miles from Newark Airport...

Business

Events

Press Releases