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

December 8, 2021

Suzanne Cohen Joins The IRONMAN Group As New Chief Marketing Officer

TAMPA, Fla. (Dec 8, 2021) /ENDURANCE SPORTSWIRE/ - The IRONMAN Group is pleased to announce the addition of Suzanne Cohen as the company’s new Chief Marketing Officer (CMO). Cohen joins the executive team at The IRONMAN Group after leadership roles with JPMorgan Chase & Co., Marriott International, Starwood Hotels &...

Business

Events

Press Releases

Triathlon

December 8, 2021

Sportograf Becomes Official Event Participant Photography and Video Services Provider for The IRONMAN Group Events in Asia, Emea, and Oceania

Singapore / London / Sydney (8 December, 2021) /ENDURANCE SPORTSWIRE/ - The IRONMAN Group announced today a multi-year agreement with long-time sport photography company Sportograf to become the Official Event Participant Photography and Video Services Provider for events across Asia, EMEA, and Oceania. As the world’s first digital-only photo service provider,...

Business

Press Releases

Running

Triathlon

December 8, 2021

Lyric Introduces First-of-its-Kind On-Device Video Guidance

SANTA MONICA, Calif., Dec. 8, 2021 /ENDURANCE SPORTSWIRE/ - The innovators behind the Lyric, the revolutionary Wi-Fi-enabled therapeutic massager, debuted its latest groundbreaking feature: full-color, on-device video guidance. Now, with one simple software update, anyone with a Lyric massager can access new free, guided content, starting with a hand/arm therapy...

Business

Press Releases

Products

December 7, 2021

Showcased

Events.com Launches Sales Tax Solution for Event Organizers

LA JOLLA, CA - December 7, 2021 /ENDURANCE SPORTSWIRE/ - Events.com, a mobile-first event registration, ticketing and management platform, today announced the launch of its automated sales tax management solution. This release makes event organizers' lives easier by automating complex tax calculations and submissions for customers. As many states and...

Business

Cycling

Press Releases

Products

Running

Triathlon