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 (16)
) 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 920, 10

April 18, 2024

OUTRIGGER Resorts & Hotels Digs In as Title Sponsor of The Big West Men’s and Women’s Volleyball Championship

HONOLULU /ENDURANCE SPORTSWIRE/ - OUTRIGGER Resorts & Hotels, the Official Hospitality Partner of The Big West, is the title sponsor for The Hawaiian Islands presents the 2024 OUTRIGGER Big West Men‘s Volleyball Championship, April 18-20, 2024 at SimpliFi Arena at Stan Sheriff Center. As part of a multi-year partnership renewal...

Events

Press Releases

Sponsorship

April 18, 2024

April 21st Marks the 20th Anniversary of the Delaware Running Festival

Wilmington, DE/ENDURANCE SPORTSWIRE/ – Corrigan Sports Enterprises (CSE) is thrilled to announce the commemoration of its 20th anniversary, celebrating two decades of hosting an event that promotes health and community spirit. The Delaware Running Festival will celebrate its 20th Anniversary on Sunday, April 21 with over 2,500 runners. Participants of...

Events

Press Releases

Running

April 18, 2024

Tyler McCandless: The Champion Returns to Conquer DICK’S Sporting Goods Pittsburgh Marathon Once More

PITTSBURGH, PA (April 18, 2024) /ENDURANCE SPORTSWIRE/ – The streets of Pittsburgh are set to witness a battle of endurance and speed as defending champion Tyler McCandless gears up to claim victory at the 2024 DICK’S Sporting Goods Pittsburgh Marathon. McCandless, who broke the finisher’s tape in 2:16:08 last year,...

Events

Press Releases

Running

April 18, 2024

XTERRA Portugal Preview: An Off-Road Decade of Endurance

GOLEGÃ, PORTUGAL /ENDURANCE SPORTSWIRE/ – Revered as Portugal’s Capital of the Horse, the town of Golegã is set to host XTERRA Portugal for one of the most challenging off-road triathlons in Europe. The Full Distance race will take place on April 21, 2024 in the Jardim Equuspolis, a distinguished garden...

Cycling

Events

Press Releases

Running

Triathlon

April 18, 2024

XTERRA Australia Preview: An Elite Pursuit Through Paradise

DUNSBOROUGH, AUSTRALIA /ENDURANCE SPORTSWIRE/ – Outdoor sports reigns supreme in The Southern Hemisphere as XTERRA Australia hosts the Full Distance Triathlon taking center stage on April 21, 2024. The scenic Dunsborough Country Club and Meelup Regional Park marks the fourth stop on the XTERRA APAC Tour as a bucket list...

Cycling

Events

Press Releases

Running

Triathlon

April 18, 2024

Mortal Hydration Becomes The Official Sports Beverage and Hydration Partner of The IRONMAN and IRONMAN 70.3 North American Triathlon Series

TAMPA, Fla. / BOULDER, Colo. (April 18, 2024) /ENDURANCE SPORTSWIRE/ – IRONMAN and Mortal Hydration today announced Mortal Hydration as the official sports beverage and hydration partner for the IRONMAN® and IRONMAN® 70.3® North American Triathlon Series. Varieties of the Mortal Hydration Drink Mix will be available on-course, giving athletes...

Events

Press Releases

Sponsorship

Triathlon

April 18, 2024

OOFOS Unveils One-of-a-Kind Recovery Sponsorship at Boston Marathon Finish Line

BRAINTREE, MA /ENDURANCE SPORTSWIRE/ – OOFOS, the Boston-based global leader in Active Recovery footwear, confirms its commitment to recovery by implementing a completely unique sponsorship initiative that supports and celebrates “Real People” in their recovery journey following the Boston Marathon. With a pop-up retail store located by the Boston Marathon...

Events

Press Releases

Running

Sponsorship

April 18, 2024

Inaugural Michelob Ultra GFNY Miami this Sunday

/ENDURANCE SPORTSWIRE/ - This Sunday, Michelob Ultra GFNY Miami offers riders an entirely flat and fast racecourse of 70.7 miles completely closed to traffic. The North American Championship race starts and finishes at Miccosukee Resort & Casino on the western edge of Miami at the portal to the Everglades. Race...

Cycling

Events

Press Releases

April 17, 2024

Riviera Nayarit, Mexico Set To Host New IRONMAN 70.3 Triathlon

- Organizers of the IRONMAN 70.3 Acapulco, IRONMAN 70.3 Campeche, IRONMAN 70.3 Cozumel, IRONMAN 70.3 Monterrey, and IRONMAN Cozumel races to host new event - The inaugural IRONMAN 70.3 Riviera Nayarit triathlon is scheduled to take place on Sunday, Nov. 10, 2024; Registration is now available by visiting www.ironman.com/im703-riviera-nayarit MEXICO...

Events

Press Releases

Triathlon