SELECT SQL_CALC_FOUND_ROWS mrml52_posts.ID
FROM mrml52_posts LEFT JOIN mrml52_term_relationships ON (mrml52_posts.ID = mrml52_term_relationships.object_id)
WHERE 1=1 AND (
(
mrml52_posts.ID NOT IN (
SELECT object_id
FROM mrml52_term_relationships
WHERE term_taxonomy_id IN (7)
)
)
AND
mrml52_term_relationships.term_taxonomy_id IN (35)
) AND mrml52_posts.post_type = 'product' AND ((mrml52_posts.post_status = 'publish'))
GROUP BY mrml52_posts.ID
ORDER BY mrml52_posts.post_title ASC
LIMIT 0, 21
