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 (1)
) 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 40, 10
September 7, 2022
A study published in The Journal of Physiology argues that athletes using cooling methods to aid recovery may be preventing their bodies from synthesizing protein, an essential ingredient in the recovery process. Amino acids that come from ingested protein are crucial to rebuilding and strengthening muscles after exercise. Canadian Running
August 29, 2022
TRX, which filed for bankruptcy in June to pursue a sale, announced that its founder and former CEO, Randy Hetrick, and partner, Jack Daly, have acquired the fitness brand. Hetrick founded TRX in 2004 after inventing the Suspension Trainer as a SEAL team squadron commander and will now lead the...
