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 (21087)
) 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 300, 10

September 22, 2021

Run Show USA, Boston Partners with Boston Athletic Association

/ENDURANCE SPORTSWIRE/-- Run Show USA, Boston the inaugural consumer running exposition scheduled Jan. 29-30, 2022, at Boston’s Hynes Convention Center, today announced that the Boston Athletic Association (B.A.A.), a non-profit organization with a mission of promoting a healthy lifestyle through sports, especially running, will be a key partner for the...

Press Releases

Running

Trade Shows

September 22, 2021

Rosalyn Durant to Open 2022 Running USA Industry Conference with Keynote Remarks

ORLANDO (Wednesday, Sept. 22, 2021) /ENDURANCE SPORTSWIRE/ -- Running USA, the non-profit trade organization for the sport of running, today announced its keynote speaker for the 2022 Industry Conference presented by Race Roster. Rosalyn (Roz) Durant, Senior Vice President of Operations for Walt Disney World Resort, will open the event...

Press Releases

Running

Trade Shows

September 22, 2021

NYC Bike Expo 2022 held May 13-15

/ENDURANCE SPORTSWIRE/ -- On May 13-15, 2022  NYC Bike Expo returns for its 10th annual edition. The road cycling show will attract more than 10,000 visitors who are avid road cyclists, endurance athletes and cycling fans. Exhibitors will showcase products such as bike components, bike brands, and cycling events. New...

Cycling

Press Releases

Trade Shows

September 13, 2021

Run Show USA Partners with the Chicago Area Runners Association

Run Show USA, the inaugural consumer running exposition scheduled June 4-5, 2022, at DES Convention Center in Rosemont, IL, today announced that the Chicago Area Runners Association (CARA), the non-profit organization known as Chicagoland’s running club will be a key partner for the event. Run Show, USA, Chicago is set...

Business

Press Releases

Running

Trade Shows