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

November 11, 2022

Spartan and World Obstacle Agree to Historic Partnership

Lausanne, Switzerland (November 11, 2022) /ENDURANCE SPORTSWIRE/ - Spartan and World Obstacle, the Fédération Internationale de Sports d’Obstacles (FISO), have signed a Memorandum of Understanding and established a cooperation framework to develop the sport of obstacle racing worldwide. The collaboration includes the sanctioning and hosting of elite-level races, cooperation on...

Business

Events

Press Releases

November 11, 2022

Tracy Campbell Joins Peak State Fit Coaching Staff

Salt Lake City, Utah. /ENDURANCE SPORTSWIRE/ – Tracy is a wife, mother of five children, triathlete, runner, cyclist, yogi, and fan of healthy living. She lives life wrapped in constant personal activity, challenging fitness endeavors, and cherished time with close friends and family. Tracy has been competing in triathlon for over...

Business

Press Releases

November 11, 2022

Blind Runner Carlos Terrazas Wins 4th Annual Happy Hippie Harvest Run 10K

LAS VEGAS, NEVADA – November 11, 2022 /ENDURANCE SPORTSWIRE/ – Beyond Limits Running today announced for the first time ever a blind runner has outright won one of its races. Carlos Terrazas won the 10K division at the 4th Annual Happy Hippie Harvest Run held on November 5, 2022 at the non-profit...

Events

Press Releases

Running

November 10, 2022

USA Triathlon Announces 2023 National Championships Calendar

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ - USA Triathlon today unveiled the dates and locations for its 2023 National Championships, a robust calendar of triathlon and multisport events across the United States. At USA Triathlon National Championships, athletes will have the opportunity to compete for U.S. national titles against the top...

Events

Press Releases

Triathlon

November 10, 2022

Roberts, Benegas, and Marino Transfer to BMX Freestyle Finals at the 2022 Urban Cycling World Championships

ABU DHABI, United Arab Emirates /ENDURANCE SPORTSWIRE/ – The Elite Women’s BMX Freestyle Park Qualifying kicked off the 2022 UCI Urban Cycling World Championships. Twenty-five women were on the start list, six representing the United States. Team USA women’s roster included: Hannah Roberts (Buchanan, Mich.; Hyper BMX), Perris Benegas (Reno, Nev.; Haro BMX),...

Cycling

Events

Press Releases

November 10, 2022

Publix Battleship 12K honors our military this Sunday

SPANISH FORT, AL. /ENDURANCE SPORTSWIRE/ – Runners from across the country will honor those who serve this Sunday at the 7th Annual Publix Battleship 12K in Spanish Fort, AL. A Veterans Day tradition for many, so far over 2300 participants from 23 states & Canada have registered. The patriotic run takes...

Events

Press Releases

Running

November 10, 2022

Orlando Selected to Host The 2024 U.S. Olympic Team Trials – Marathon

Orlando, FL /ENDURANCE SPORTSWIRE/ – Together with the Greater Orlando Sports Commission, the City of Orlando, and Orange County, Track Shack is thrilled to announce that Orlando will be the host city for the 2024 U.S. Olympic Team Trials - Marathon. The Trials will be Saturday, February 3, 2024, in downtown...

Events

Press Releases

Running

November 10, 2022

OKAI Debuts Its Highest-Performing E-Scooter, the OKAI Neon Pro, Under Manhattan’s Spotlight

POMONA, CA /ENDURANCE SPORTSWIRE/ – OKAI, a global leader in the manufacturing of e-scooters and e-bikes, announces the release of the OKAI Neon Pro, the best-performing, longest-range and most powerful e-scooter in its popular Neon series. With top-notch PROgrammable safety LED lighting and other remarkable features, the OKAI Neon Pro delivers...

Cycling

Press Releases

Products

November 10, 2022

Super Sunday: GFNY closes 2022 with three races on same day

/ENDURANCE SPORTSWIRE/ GFNY Cozumel The 9th GFNY Cozumel is the largest bike race in the Americas south of NYC. The long course offers riders a flat and furiously fast 157km around the tropical paradise island of Cozumel. Like no other, the race combines panoramic views of the beautiful turquoise ocean...

Cycling

Events

Press Releases