SELECT SQL_CALC_FOUND_ROWS mrml52_posts.ID
FROM mrml52_posts INNER JOIN mrml52_postmeta ON ( mrml52_posts.ID = mrml52_postmeta.post_id )
WHERE 1=1 AND (
(
( mrml52_postmeta.meta_key = 'professionnel_correspondant' AND mrml52_postmeta.meta_value IN ('11155','9511','2508','8201','7828','6349','6179','5843','5631','5622','4897','5126','5109','5088','4700','3720','3599') )
)
) 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 42, 21