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

February 2, 2022

ASICS Returns as Official Partner for Canada Running Series’ Top Three Races

[February 2, 2022 – Toronto, CAN] /ENDURANCE SPORTSWIRE/ - Today, ASICS and Canada Running Series (CRS) are thrilled to announce a partnership between the two brands which will see ASICS serve as the official partner for CRS's three largest events, the TCS Toronto Waterfront Marathon, 21K de Montréal, and Vancouver...

Press Releases

Running

Sponsorship

February 2, 2022

BibRave Marketing Savvy Leads Missoula Marathon To First Sellout Since 2013

Portland, OR /ENDURANCE SPORTSWIRE/ - BibRave, the leading-edge endurance and fitness marketing agency led the Missoula Marathon to its first Marathon sell-out in almost a decade. Capacity was reached in the race’s Marathon event in just 3.5 months. BibRave led the Missoula Marathon team to a strong registration opening in...

Events

Press Releases

Running

February 1, 2022

GFNY Mexico adds GFNY Zapopan

NEW YORK CITY, February 2, 2022 /ENDURANCE SPORTSWIRE/ - GFNY Global Endurance Sports Series brings GFNY Zapopan, scheduled for October 2, 2022. The competitive long distance of GFNY Zapopan is 146km long with 1234m of climbing. Start and finish are hosted in the historic centre in front of the Basilica...

Cycling

Events

Press Releases

February 1, 2022

Rock ‘N’ Roll Running Series Las Vegas Partners with Resorts World Las Vegas To Bring the Health and Fitness Expo to The Strip

LAS VEGAS, Nev. (Feb. 1, 2022) /ENDURANCE SPORTSWIRE/ - The Rock ‘n’ Roll® Running Series Las Vegas is going all in on new race weekend experiences including moving the three-day Health & Fitness Expo to the Strip at Resorts World Las Vegas, which also signed on as the expo’s presenting...

Press Releases

Running

Sponsorship

February 1, 2022

ARCHER Components Launches New Multi-Function Remote for Drop-Bar Bikes

Scotts Valley, California (February 1, 2022) — ARCHER Components’ proven wireless electronic system continues to shift the paradigm of electronic components, adding a universal drop-bar remote for gravel or road bikes, preferably with a 1x drivetrain, to their existing MTB and brake-specific gravel systems. Their new Multi Function Remote (MFR)...

Cycling

Press Releases

Products

Triathlon

February 1, 2022

HOP WTR Heads Into 2022 with Zest: Introducing Lime

LOS ANGELES (February 1, 2021)/ENDURANCE SPORTSWIRE/ -  HOP WTR - a non-alcoholic brew of crisp, bold hops, sparkling water and mood-boosting ingredients - is introducing Lime to the flavor roster. The new refreshing and hydrating flavor delivers a tart, sunny flavor with crisp, bold hops. Plus, like all HOP WTR...

Press Releases

Products

February 1, 2022

Showcased

The Antarctica Marathon & Half-Marathon Returns to King George Island

KING GEORGE ISLAND, ANTARCTICA, February 1, 2022 ENDURANCE SPORTSWIRE/ - The 21st running of the Antarctica Marathon & Half-Marathon took place on King George Island in the South Shetland Islands of Antarctica on Friday, January 28.  After deferring the event in 2020 and 2021, the Marathon Tours & Travel (MTT)...

Events

Press Releases

Running