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

October 24, 2024

Nissan Formula E Team Announces Reflo As Official Teamwear and Apparel Partner

UK, 24th October 2024 /ENDURANCE SPORTSWIRE/ - Nissan Formula E Team has today announced a new partnership with sustainable sportswear brand Reflo, who become the team's Official Teamwear and Apparel partner. The two year deal starting from the first race of Season 11 of the ABB FIA Formula E World...

Business

Press Releases

Products

Running

Sponsorship

October 24, 2024

Boston Athletic Association and The Reggie Lewis Track and Athletic Center at Roxbury Community College Announce Partnership

BOSTON (October 24,2024) /ENDURANCE SPORTSWIRE/ - The Reggie Lewis Track and Athletic Center (RLTAC) at Roxbury Community College and the Boston Athletic Association (B.A.A.) today announced a groundbreaking multi-year partnership advancing athletic programming and opportunities at the Roxbury athletic facility. A financial contribution over four years, combined with fundraising potential...

Business

Giving

Press Releases

Running

October 24, 2024

Sumarpo Strengthens 1% for the Planet Commitment Through New Partnership with Circular Flow for Neoprene Recycling

Octoeber 24th, /ENDURANCE SPORTSWIRE/ - A pioneer in eco-friendly triathlon gear has partnered with Circular Flow, a leading organization in neoprene recycling, to strengthen its dedication to environmental protection. This collaboration represents a significant step forward in addressing the challenge of neoprene waste and advancing sustainable practices within the watersports...

Business

Press Releases

Triathlon

October 24, 2024

Showcased

Mountain Hardwear Announces Fifth Annual Open Aperture Photo Clinic

Richmond, Calif. [October 24, 2024] /ENDURNACE SPORTSWIRE/– Mountain Hardwear is thrilled to announce the launch of the fifth edition of the Open Aperture Photo Clinic, a transformative program dedicated to amplifying the voices of underrepresented communities through the art of outdoor photography and videography. This year’s clinic, taking place in...

Business

Giving

OSW Syndicated

Press Releases

Sponsorship

SWW Syndication