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

October 19, 2021

KOM Cycling Signs Deal with Bob Elliot & Co LTD, For UK Distribution

East Lansing, Michigan (October 19, 2021) /ENDURANCE SPORTSWIRE/ - With record numbers of people across the globe, KOM Cycling has been working to expand their distributor network, and they’ve found their ideal partners in Bob Elliot & CO Ltd, which boasts decades of relevant experience and the requisite network to maximize...

Business

Cycling

Press Releases

Triathlon

October 19, 2021

Showcased

BikeFlights Makes It Easier To Ship E-Bikes

PORTLAND, OR (October 19, 2021) /ENDURANCE SPORTSWIRE/ - BikeFlights.com, a bicycle shipping service and bike box supplier, has just made it easier for individual cyclists and businesses to ship e-bikes within the contiguous U.S. “As more people have purchased e-bikes, the need to buy and sell as well as travel...

Business

Cycling

Press Releases

Products

October 18, 2021

Spaero Triathlon Launches with State-of-the-Art Performance Gear and New Ambassador Team

Vista, CA. (October 18, 2021) Spaero Triathlon - a California-based advanced technical triathlon apparel brand formerly known as Wattie Ink, announces its new brand name, Spaero Triathlon, with a new line of advanced technical triathlon gear and robust ambassador team program. Headquartered in the birthplace of the sport, San Diego,...

Business

Press Releases

Triathlon