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 (11)
) 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 2290, 10

January 17, 2023

Rebranded RUN Varsity Aims to Support Teenagers Moving

PITTSBURGH /ENDURANCE SPORTSWIRE/ – P3R has announced that 4RUN2 Varsity has rebranded to RUN Varsity. The rebrand is designed to be more inclusive of ALL youth in the area. RUN Varsity adds to P3R’s robust programming to motivate any and all to MOVE and will continue to support, educate and encourage teenage...

Business

Giving

Press Releases

Running

January 17, 2023

National Cycling League (NCL) announces ZIeL Concept Store as the Miami Race Fan Headquarters and Club House for the Miami Nights Cycling Club

Miami, FL, January 17, 2023 /ENDURANCE SPORTSWIRE/ – The National Cycling League, the first of its kind in professional sports built around 21st century values of diverse ownership, gender equality, technology, and sustainability, today announced that it has selected ZIeL Concept store, Miami’s preeminent cycling resource and lifestyle community store as the...

Business

Cycling

Events

Press Releases

January 13, 2023

DMSE Sports Serves More Than 120,000 Participants In 2022

BOSTON /ENDURANCE SPORTSWIRE/ – DMSE Sports has released key facts and figures from their 2022 events, showing evidence of road racing’s recovery over the past year. The leading event operations organization founded and lead by Dave McGillivray assisted with the planning and production of 24 events this year, ushering more than...

Business

Events

Press Releases

January 12, 2023

Runners take over Baton Rouge for the running festival with lagniappe

BATON ROUGE, LA. /ENDURANCE SPORTSWIRE/ - Thousands of runners from over 47 states, Canada, Mexico, and Honduras will celebrate more than a decade’s worth of passion for running and Louisiana culture at this weekend’s Louisiana Marathon. Celebrating its 12th year, the Louisiana Marathon aims to encourage the community to embrace...

Business

Events

Press Releases

Running

Sponsorship