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 (21085)
) 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 1650, 10

October 26, 2021

Pic2Go’s Finishers Experience Platform RunPage Exceeds 100,000 Registrations

/ENDURANCE SPORTSWIRE/ -RunPage is Pic2Go’s standard finisher gallery, claimed to be the richest finisher gallery in the market including: Race photos are auto-tagged and available for participants early on race day. Includes finisher's distance, finish time and custom digital medal. Industry leading sharing rate - 85% of participants using the...

Press Releases

Products

Running

October 25, 2021

Compass Diversified-Backed Marucci Sports Announces Acquisition of Lizard Skins

BATON ROUGE, La. – October 25, 2021 /ENDURANCE SPORTSWIRE/ - Marucci Sports, LLC (“Marucci”), a subsidiary of Compass Diversified (NYSE: CODI) and a leading designer and manufacturer of baseball and softball equipment and apparel, today announced it has acquired Lizard Skins LLC (“Lizard Skins”), a designer and seller of branded grip...

Business

Cycling

Press Releases

Products

October 25, 2021

GU Adds New Small-Bite Energy Chews to its Lineup

Berkeley, Calif. — October 25, 2021 /ENDURANCE SPORTSWIRE/ - GU Energy Labs announces a new addition to its popular Energy Chews lineup with small-bite mini Chews now available in a convenient pouch. The new format complements the existing original Energy Chews stick pack, giving athletes more options for fueling on...

Cycling

Press Releases

Products

Running

October 22, 2021

Pic2Go Delivered Race Photo Based Video Clips at the Warsaw Marathon 2021

/ENDURANCE SPORTSWIRE/ - Pic2Go has successfully delivered Race Photo based Video Clips to participants of the 43. Warsaw Marathon, while boosting social reach and engagement to the activation sponsor – Bridgestone Poland! Pic2Go’s photo-based videos let organizers offer finishers with video clips to share, while keeping affordable activation costs (saving...

Events

Press Releases

Products

Running

October 21, 2021

Showcased

MarathonPhotos launches LIVE in Canada

October 21, 2021 /ENDURANCE SPORTSWIRE/ - MarathonPhotos.Live isn’t wasting any time in conquering the world. On the same day the world-leading endurance photo company launched its ground-breaking service in Canada, teams were also photographing events live in the UK and Europe. With the traditional Scotiabank Toronto Waterfront Marathon shortened this...

Events

Press Releases

Products

Running

October 21, 2021

ROUVY takes Workouts to another level by combining them with beautiful augmented route videos of your choice

ROUVY is a well known and popular indoor app that enables cyclists and triathletes to ride anywhere in the world from home, be it an exotic or iconic cycling location or the next race. Less talked about is the number of features and the other training options of the platform....

Cycling

Press Releases

Products

Triathlon