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

November 13, 2024

“Power Comes from Within” Thermore Launches First Consumer Campaign

Milan, Italy/ENDURANCE SPORTSWIRE/ - Thermore, an Italian manufacturing firm that has been innovating in the apparel insulation sector for over 50 years, announces the launch of its first consumer campaign. Imagined by global creative team, Innocean Italy, “Power Comes from Within,” is a brand manifesto highlighting the quality and versatility of...

Business

Press Releases

Products

November 13, 2024

Sumarpo Embraces Top Portuguese Talent to Drive Innovation in Triathlon Gear

November 13th. /ENDURANCE SPORTSWIRE/ - Sumarpo has officially partnered with Hugo Figueiredo, a leading figure in Portugal’s triathlon community and the current Portuguese National Champion. The partnership underscores both Sumarpo’s and Figueiredo’s dedication to advancing excellence, innovation, and sustainability in triathlon sportswear. A Journey of Dedication and Success Hugo’s journey...

Business

Press Releases

Sponsorship

Triathlon

November 12, 2024

The Best Just Got Bolder: The James Brand × Timex Automatic GMT Emerald Edition

Portland, OR (November 12, 2024) /OUTDOOR SPORTSWIRE/ - Travel rarely goes the way you plan it; that’s what transforms it into adventure. The James Brand ventured deep into the headlands of Nova Scotia and found inspiration for its most recent collaboration with legendary watchmaker, Timex. Evoking the deep, lush tones...

Business

Press Releases

Products

November 12, 2024

Enabled Tracking to Provide Live GPS Tracking for November 2024 Endurance Events

Front Royal, VA – November 2024 /ENDURANCE SPORTSWIRE/ – Enabled Tracking, a division of Adventure Enablers specializing in timing and tracking solutions, is excited to unveil its state-of-the-art live GPS tracking services. These advanced solutions will be available for both upcoming and ongoing endurance events. Designed to support participants as...

Business

Events

Press Releases