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 (21084)
) 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 130, 10

January 19, 2024

KeyBank Named Title Partner of the Run for a Reason Charity Program for the 2024 DICK’S Sporting Goods Pittsburgh Marathon

PITTSBURGH, PA (January 19, 2024) /ENDURANCE SPORTSWIRE/ – P3R, the engine behind Pittsburgh's most exhilarating sporting events, has announced that KeyBank has been named title partner of the Run for a Reason Charity Program for the 2024 DICK’S Sporting Goods Pittsburgh Marathon Weekend of Events. More than 2,700 charity runners are...

Events

Giving

Press Releases

Running

Sponsorship

January 16, 2024

California Coast Classic Raises Total Fundraising Goal for 2024 after Banner Year

LOS ANGELES – January 16, 2024 /ENDURANCE SPORTSWIRE/ – The California Coast Classic, known as “The Ride of a Lifetime” for its fully supported format and epic route from San Francisco to Los Angeles along the California Coast, is back for 2024 with a bigger-than-ever fundraising goal of $1.5 million. “With...

Cycling

Events

Giving

Press Releases

January 11, 2024

The Cowtown fulfills 5,620 C.A.L.F. grants at 104 schools in North Texas

Fort Worth, Texas/ENDURANCE SPORTSWIRE/ – In the weeks preceding race weekend, February 24-25, 2024 at Will Rogers Memorial Center, the Cowtown staff and an army of volunteers will visit 104 schools delivering much needed running shoes, socks, and assistance with entry fees to youth in need enabling them to run the...

Events

Giving

Press Releases

Running

January 9, 2024

Pat Tillman Foundation Opens Registration For 20th Annual Pat’s Run, Presented by Teksystems

CHICAGO (Jan. 9, 2024) /ENDURANCE SPORTSWIRE/ - Registration opened today for the 20th Annual Pat’s Run, the Pat Tillman Foundation’s marquee fundraising event, presented by TEKsystems. Pat’s Run, a 4.2-mile run / walk with a .42-mile Kids Run, will take place in-person and virtually on April 13, 2024. The in-person...

Events

Giving

Press Releases

Running

December 29, 2023

Falmouth Road Race Inc. Announces Over $93,000 Awarded in Winter Grants

FALMOUTH, Mass. /ENDURANCE SPORTSWIRE/ - Falmouth Road Race, Inc. had a record-breaking year across the board, with top times at the road race and best-ever fundraising numbers. Their successful fundraising allowed the organization to award a total $218,997.54 in grants this past year, which includes $93,455.54 being awarded to five...

Giving

Press Releases