SELECT SQL_CALC_FOUND_ROWS wp_pmcsf7c24x_posts.ID
FROM wp_pmcsf7c24x_posts
WHERE 1=1 AND ((wp_pmcsf7c24x_posts.post_type = 'product' AND (wp_pmcsf7c24x_posts.post_status = 'publish')))
GROUP BY wp_pmcsf7c24x_posts.ID
ORDER BY wp_pmcsf7c24x_posts.post_title ASC
LIMIT 12, 6