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 (8742)
) 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 6290, 10

November 8, 2021

Introducing MAAP Transit Apparel

/ENDURANCE SPORTSWIRE/ - It's made for movement and constantly in flux. It's M.A.A.P goes from A to B, or wherever it takes you. It's technical for the ride and, with progressive colour blocked design and unisex fit, styled for the inside. Four-way stretch provides a full range of movement with no...

Cycling

Press Releases

Products

November 8, 2021

Showcased

Online Cycling Community Seeks to Connect Cyclists with Sponsors

LONGMONT, CO (November 8, 2021) – 10 Buck Bike Club, LLC—an online community built by cyclists, for all cyclists—is building an online directory to connect cyclists with sponsors. “We're answering the calls we’ve been hearing from our cycling friends for years: 'I need help and know I could do so...

Cycling

Press Releases

Sponsorship

November 8, 2021

2022 DeSatnick Real Estate Escape the Cape Triathlon Sells Out In 7 Days

/ENDURANCE SPORTSWIRE/ - The 2022 DeSatnick Real Estate Escape the Cape Triathlon and Open Water Classic, presented by Inspira Health, reached capacity in just 7 days, selling out with 2,000 triathletes and swimmers. Athletes from 40 states, including 373 first time triathletes, will make the journey to Lower Township, NJ to...

Events

Press Releases

Triathlon

November 8, 2021

Pic2Go Partners with The Williams Route 66 Marathon to deliver Race Day Photos to Participants!

/ENDURANCE SPORTSWIRE/ - The Williams Route 66 Marathon in Tulsa, Oklahoma, announced a renewed collaboration with Pic2Go for taking photos of this year’s runners. Pic2Go’s unique solution not only auto-tag and brand the marathon photos, but also deliver rich finisher galleries to the participants while driving massive social sharing –...

Events

Press Releases

Products

Running

Sponsorship

November 8, 2021

The RunnerBox and RiderBox Unveil Highly Anticipated Limited Edition Holiday Boxes

November 8, 2021 /ENDURANCE SPORTSWIRE/ - The Runner and The RiderBox, leaders in the endurance sport gift industry, have released a Limited-Edition Holiday Box which will be available for sale on a first-come, first-served basis. This limited run box is an annual favorite and has sold out every year it...

Cycling

Press Releases

Products

Running

November 7, 2021

AbbottWMM Series XIII Champions Crowned

/ENDURANCE SPORTSWIRE/ - The Abbott World Marathon Majors (AbbottWMM) declared its first ever joint champions today after a thrilling finish to Series XIII at the TCS New York City Marathon. Kenyan duo Joyciline Jepkosgei and Peres Jepchirchir were named joint winners of the series after finishing level on points with...

Events

Press Releases

Running

November 7, 2021

3,700 Runners Ran through the Streets at the 2021 EQT Pittsburgh 10 Miler

PITTSBURGH (November 7, 2021) /ENDURANCE SPORTSWIRE/ - Thousands of runners returned to the live start line of the ‘most Pittsburgh race ever’ for the first time in two years at the 2021 EQT Pittsburgh 10 Miler Sunday morning. Participants from 36 states and four countries completed the 10-mile course that...

Events

Press Releases

Running

Sponsorship