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

February 9, 2022

Quincy Cass Associates Marathon Challenge to Highlight Elite Runners of 2022 Los Angeles Marathon

Los Angeles, CA (February 10, 2022) /ENDURANCE SPORTSWIRE/ - The 2022 Los Angeles Marathon presented by ASICS is proud to announce the return of the Quincy Cass Associates Marathon Challenge, an exciting 26.2-mile race-within-a-race competition that will highlight the talented runners of the women’s and men’s elite fields in an...

Events

Press Releases

Running

Sponsorship

February 9, 2022

“Krewe” of runners to roll through Baton Rouge for Mardi Gras Mambo

BATON ROUGE, La. /ENDURANCE SPORTSWIRE/ - Celebrate Carnival Season with a “krewe” of over 1500 other runners from across the South taking on the Mardi Gras Mambo in Baton Rouge this weekend. The Saturday race boasts a distance for everyone from beginners to runners dipping their toe into longer distances...

Events

Press Releases

Running

February 9, 2022

Courses Announced for the 2022 DICK’S Sporting Goods Pittsburgh Marathon Weekend of Events

PITTSBURGH, PA /ENDURANCE SPORTSWIRE/ - Today P3R revealed the courses for the highly anticipated return of the 2022 DICK’S Sporting Goods Pittsburgh Marathon Weekend of Events, scheduled for April 29-May 1. Sunday’s events will feature a similar course as 2019, and Saturday’s 5K and Kids Marathon will now cross the...

Events

Press Releases

Running

February 9, 2022

BikeFlights.com Announces 2022 Brand Ambassadors

PORTLAND, OR (February 9, 2022) /ENDURANCE SPORTSWIRE/ - BikeFlights, an easy-to-use bicycle shipping service and supplier of easy-to-pack bike boxes, is pleased to introduce its Brand Ambassadors for the 2022 season, including 39 individuals and one team. “We have an amazing and talented roster of cyclists who will represent BikeFlights...

Cycling

Press Releases

Sponsorship

Triathlon

February 9, 2022

Get set for a blissful triathlon experience in Ibiza this April

IBIZA, Spain - February 9, 2022 /ENDURANCE SPORTSWIRE/ - Looking for an endurance sporting experience with a touch of Zen? Kick off your 2022 triathlon season with Six Senses Ibiza. Capturing the authentic Ibiza experience of community, spirituality and celebration, the resort - opened in July 2021 - is swiftly...

Events

Press Releases

Triathlon