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

August 3, 2023

Showcased

PERCEEV – the Digital Stadium of Endurance Sports – Seeks Ignitor Accounts

Carlsbad, CA /ENDURANCE SPORTSWIRE/ - Perceev, a software as a service platform for endurance racing events, is emerging from stealth. Perceev is seeking race organizers who are interested in utilizing the platform as strategic partners. These partners will benefit from FREE use of the platform and FREE in-house builds for...

Business

Press Releases

August 2, 2023

Helijet Superweek announced in celebration of RBC GranFondo Whistler 2023 partnership

[Vancouver, BC] /ENDURANCE SPORTSWIRE/ - RBC GranFondo Whistler today announced the week of August 7-13, 2023 will be designated as Helijet Superweek. Helijet is the official air transport partner of the event which holds the title of North America’s largest Gran Fondo, a mass-participation cycling challenge. Helijet Superweek is a new...

Business

Cycling

Events

Press Releases

Sponsorship

August 2, 2023

Elite Podiatrist and Footwear Developer Simon Bartold Backs Innovative Vimazi, Will Exclusively Distribute in AU and NZ

Portland, Ore., (August 2, 2023) /ENDURANCE SPORTSWIRE/ - Vimazi, maker of the first ever pace-tuned running shoes, and Simon Bartold, globally recognized podiatrist to the running elite and advanced development consultant for industry leaders ASICS and Salomon, announce today a partnership to have Bartold be Vimaz’s exclusive distributor for Australia...

Business

Press Releases

Running

August 2, 2023

10 Years and Counting: haku Notches Anniversary Milestone

Miami, August, 2023 /ENDURANCE SPORTSWIRE/ –haku is thrilled to announce a momentous milestone as it celebrates its 10-year anniversary, commemorating a decade of excellence in providing comprehensive business solutions to event organizers. With an unwavering commitment to empowering organizers in their technology transformation journey, haku has redefined the landscape of how...

Business

Press Releases

August 1, 2023

Sports Flooring Franchise, Innovative Sports Surfacing, Kicks Off Nationwide Sales Launch with New Territories Signed

Louisville, KY /ENDURANCE SPORTSWIRE/ - Innovative Sports Surfacing, a differentiated sports flooring franchise specializing in poured-in-place rubber, artificial grass installation, bonded rubber mulch, sports flooring, and more, has just kicked off its nationwide franchise launch with two new territories signed. The brand, which officially opened its franchise opportunity just weeks ago,...

Business

Press Releases