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

September 8, 2022

Showcased

A Business as Secure as Your Bib: BibBoards Celebrates 5 Years

/ENDURANCE SPORTSWIRE/ - BibBoards is celebrating five years of serving endurance athletes, brands, and race coordinators. BibBoards has grown significantly in the last few years and has made a commitment to partnering with more brands, races, and organizations to get BibBoards into the hands and onto the shirts of more...

Awards

Business

Giving

Press Releases

Products

Sponsorship

Studies

Trade Shows

Triathlon

September 6, 2022

Elevation Culture launches creative event services

/ENDURANCE SPORTSWIRE/ – Since 2015 Elevation Culture has designed and created for over 3,000 + trail/mountain sports events across the USA, in addition to working with some of the most influential outdoor industry brands. Founder and Designer of Elevation Culture Eric Chrisman pioneered the authentic finish line experience with the creation...

Business

Press Releases

September 2, 2022

Steve Lenz Jr. Helps bring BibBoard’s Partnerships across the Finish Line

/ENDURANCE SPORTSWIRE/ – As BibBoards continues to grow and partner with endurance events around North America it is important to bring in industry experts to help manage sponsorships and partnerships. BibBoards are the perfect tool for endurance event coordinators to provide added value to their events while factoring in marketing potential....

Business

Cycling

Press Releases

Running

Triathlon

September 1, 2022

Lakeshore Athletic Services West Region Expansion

Lakeshore Athletic Services is pleased to announce the move to our new and improved office and warehouse location in Mesa, Arizona. Our new AZ headquarters are located in a brand new construction building, boasting a 1700 square foot office and warehouse facility. Event Equipment & Services Lakeshore Athletic Services has...

Business

Cycling

Press Releases

Products

Running

Triathlon

September 1, 2022

Showcased

INFINIT Nutrition announces its expansion to the European market

Prague, Czech Republic, September 01, 2022 /ENDURANCE SPORTSWIRE/ – Started in 2003, INFINIT was one of the first companies to establish themselves in the now rapidly growing personalized nutrition space. Their proprietary Osmo-Fit technology gives consumers the ability to create customized hydration and protein ready-to-mix nutritional drinks. After its 18 successful years’...

Business

Cycling

Press Releases

Running

Triathlon