SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (21085)
) AND (
( wp_postmeta.meta_key = 'editors_choice' AND wp_postmeta.meta_value LIKE '{ffcf04414835bc14d703860d97bfed5af163201964a2c5af05c8f7915ee531a0}yes{ffcf04414835bc14d703860d97bfed5af163201964a2c5af05c8f7915ee531a0}' )
) 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.post_date DESC
LIMIT 640, 10
January 9, 2020
Target has big ambitions in the athletic space. The chain today announced the launch of All in Motion, a private-label athletic and sporting goods brand — and it says the label could do $1 billion in sales in its first year. The size-inclusive brand launches this month with men’s, women’s and children’s...
January 9, 2020
China-based Huami (HMI) already has set its sights on being the innovation leader in the wearable fitness device market. Now the ambitious company, little known in the U.S., is making a splash at CES 2020 with a lineup of impressive new contraptions, and not all of them wearable. Not familiar with the...
